PART 234 – ASQP
On-Time Data
OMB NO: 2138-0041
EXPIRATION
DATE: 9/30/2011
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/RITA, RTS-42, Room E34, 1200 New Jersey Avenue, SE, Washington, D.C. 20590 or e-mail – [email protected].
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 |
Year (CCYY) |
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,,,,,,,,,,,,,,,,,,,,,,,,,
PART 234 – ASQP – Mishandled Baggage Report
OMB NO: 2138-0041
EXPIRATION
DATE: 9/30/2011
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/RITA, RTS-42, Room E34, 1200 New Jersey Avenue, SE, Washington, D.C. 20590 or e-mail – [email protected].
REQUIREMENTS
RECORD DESCRIPTION: ASQP – Mishandled Baggage Report
Field Description |
Data Type |
Length |
Comments |
Sample Data |
Carrier code |
Character |
2 |
Two letter IATA code |
XX |
Year of Data |
Numeric |
4 |
Year (CCYY) |
2010 |
Month of Data |
Numeric |
2 |
Month (MM) |
03 |
Number of Domestic Scheduled Passengers Enplaned |
Numeric |
Varies |
|
8004000 |
Number of Mishandled Baggage Reports Filed with Carrier |
Numeric |
Varies |
|
35000 |
RECORD FORMAT:
The ASQP – Mishandled Baggage 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-234mbr.csv
Sample Record Format:
XX,2010,03,8004000,35000
File Type | application/msword |
File Title | eSubmit Record formats for Directive |
Author | marianne.seguin |
Last Modified By | daphnis_k |
File Modified | 2013-03-29 |
File Created | 2013-03-29 |