USA Banner

Official US Government Icon

Official websites use .gov
A .gov website belongs to an official government organization in the United States.

Secure Site Icon

Secure .gov websites use HTTPS
A lock ( ) or https:// means you’ve safely connected to the .gov website. Share sensitive information only on official, secure websites.

Site Notification

Site Notification

U.S. Department of TransportationU.S. Department of Transportation IconUnited States Department of TransportationUnited States Department of Transportation
ESubmit User Guide Report Formats Manage Profile Contact OAI FAQ Log Out

PART 234 ASQP On-Time Data

PDF

OMB NO: 2138-0041

EXPIRATION DATE: 3/31/2019

Paperwork Reduction Act Burden Statement

A federal agency may not conduct or sponsor, and a person is not required to respond to, nor shall a person be subject to a penalty for failure to comply with a collection of information subject to the requirements of the Paperwork Reduction Act unless that collection of information displays a current valid OMB Control Number. The OMB Control Number for this information collection is 2138-0041. Public reporting for on-time performance, mishandled baggage, is estimated to be approximately 20 hours per response, including the time for reviewing instructions, completing and reviewing the collection of information. All responses to this collection of information are mandatory, as authorized by 14 CFR, Part 234. Send comments regarding this burden estimate or any other aspect of this collection of information, including suggestions for reducing this burden to: Information Collection Clearance Officer, Cecelia Robinson, OAI/BTS, RTS-42, Room E34, 1200 New Jersey Avenue, SE, Washington, D.C. 20590 or e-mail – cecelia.robinson@dot.gov.

REQUIREMENTS

RECORD DESCRIPTION: ASQP – Monthly On-Time Data

Field Description Data Type Length Comments Sample Data
Carrier code Character 2 IATA code XX
Flight number Character 4 1234
Origin airport code Character 3 Airport code DFW
Destination airport code Character 3 Airport code BNA
Date of flight operation DATE ccyymmdd Century & Year (ccyy) Month (mm)
Day (dd)		 20100301
Day of the week of flight operation Numeric 1 Mon = 1, Sun = 7 1
Scheduled departure time as shown in Official Airline Guide (OAG) Numeric 4 24 hour clock 0735
Scheduled departure time as shown in CRS Numeric 4 24 hour clock 0735
Gate departure time (actual) Numeric 4 24 hour clock 0737
Scheduled arrival time Numeric 4 24 hour clock 0915
Scheduled arrival time per CRS Numeric 4 24 hour clock 0915
Gate arrival time (actual) Numeric 4 24 hour clock 1148
Difference between OAG and CRS scheduled departure times Numeric 4 In minutes – G minus H
(2 hours=120 min) 		0
Difference between OAG and CRS scheduled arrival times Numeric 4 In minutes – J minus K 0
Scheduled elapsed time Numeric 4 In minutes – K minus H 100
Gate-to-Gate Time Numeric 4 In minutes – L minus I 251
Departure delay time (actual minutes CRS) Numeric 4 In minutes – I minus H 2
Arrival delay time (actual minutes CRS) Numeric 4 In minutes – L minus K 153
Elapsed time difference (actual minutes CRS) Numeric 4 In minutes – P minus O 151
Wheels-off time (actual) Numeric 4 24 hour clock 0753
Wheels-on time (actual) Numeric 4 24 hour clock 1141
Aircraft tail number Character 6 N123XX
Cancellation code Character 1 Values are A, B, C, D
Minutes late for Delay Code E – Carrier Caused Numeric 4 In minutes
Minutes late for Delay Code F – Weather Numeric 4 In minutes
Minutes late for Delay Code G – National Aviation System (NAS) Numeric 4 In minutes
Minutes late for Delay Code H – Security Numeric 4 In minutes
Minutes late for Delay Code I – Late Arriving Flight (Initial) Numeric 4 In minutes
First gate departure time (actual) Numeric 4 24 hour clock
Total ground time away from gate Numeric 4 In minutes
Longest ground time away from gate Numeric 4 In minutes
Number of landings at diverted airports Numeric 1 1 to 5 for diversions,
9 designates a fly return canceled flight		 1
Diverted airport code 1 Character 3 Airport code MEM
Wheels-on time at diverted airport Numeric 4 24 hour clock 1005
Total ground time away from gate at diverted airport Numeric 4 In minutes 69
Longest ground time away from gate at diverted airport Numeric 4 In minutes 69
Wheels-off time (actual) at diverted airport Numeric 4 24 hour clock 1114
Aircraft tail number Character 6 N234XX
Diverted airport code 2 Character 3 Airport code
Wheels-on time at diverted airport Numeric 4 24 hour clock
Total ground time away from gate at diverted airport Numeric 4 In minutes
Longest ground time away from gate at diverted airport Numeric 4 In minutes
Wheels-off time (actual) at diverted airport Numeric 4 24 hour clock
Aircraft tail number Character 6
Diverted airport code 3 Character 3 Airport code
Wheels-on Time at Diverted Airport Numeric 4 24 hour clock
Total ground time away from gate at diverted airport Numeric 4 In minutes
Longest ground time away from gate at diverted airport Numeric 4 In minutes
Wheels-off time (actual) at diverted airport Numeric 4 24 hour clock
Aircraft tail number Character 6
Diverted airport code 4 Character 3 Airport code
Wheels-on time at diverted airport Numeric 4 24 hour clock
Total ground time away from gate at diverted airport Numeric 4 In minutes
Longest ground time away from gate at diverted airport Numeric 4 In minutes
Wheels-off time (actual) at diverted airport Numeric 4 24 hour clock
Aircraft tail number Character 6
Diverted airport code 5 Character 3 Airport code
Wheels-on time at diverted airport Numeric 4 24 hour clock
Total ground time away from gate at diverted airport Numeric 4 In minutes
Longest ground time away from gate at diverted airport Numeric 4 In minutes
Wheels-off time (actual) at diverted airport Numeric 4 24 hour clock
Aircraft tail number Character 6


RECORD FORMAT:

The ASQP - On Time Data reports must be created as an electronic “comma separated values” file, using ASCII text character encoding, for uploading via the “eSubmit” application.

The comma separated values file MUST BE indicated when naming the file, by using the letters [CSV] or [csv] following the file name, as the file name extension.

The file name is flexible and may be determined by the individual air carrier, but the comma separated values (csv) file format is required, as outlined in the rule entitled, Submitting Airline Data via the Internet.

The fields in the sample record shown below follow the same order as the above record description, separated by commas, and saved with the file name extension of .csv.

Suggested file name: XX201003-234ontime.csv

Sample Record Format:

XX,1234,DFW,BNA,20100301,1,0735,0735,0737,0915,0915,1148,0,0,100,251,2,153,151,0753,1141,N123XX,,,,,,,,,,1,MEM,1005,69,69,1114,N234XX,,,,,,,,,,,,,,,,,,,,,,,,,