Document
eSubmit Record formats for Directive
ICR 202610-2138-001 · OMB 2138-0041 · Object 174281400.
Document Viewer [pdf]
Status: Original and derived artifacts are available for this document.
Download: pdf
Loading document viewer…
Document Metadata
| File Type | application/pdf |
|---|---|
| File Title | eSubmit Record formats for Directive |
| Author | marianne.seguin |
| Last Modified By | Microsoft® Word for Microsoft 365 |
| File Modified | 2021-11-02 |
| File Created | 2021-11-02 |
| Conversion State | complete |
Extracted Text
PART 234 – ASQP On-Time Data OMB NO: 2138-0041 EXPIRATION DATE: 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 is estimated to be approximately 10 hours per response for an air carrier to report for its operations and an additional 16 hours per response if the air carrier reports for covered code-share operations, 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, OAI/BTS/OST-R, RTS42, 1200 New Jersey Avenue, SE, Washington, D.C. 20590 REQUIREMENTS RECORD DESCRIPTION: ASQP – Monthly On-Time Data Form 1: On-Time Performance Data for Non-Codeshare and Codeshare Flights1 Field A B C D E F G H I J K L M N O P Q R S T U V W X Description Type Length Comments Carrier code Flight number Departure airport code Arrival airport code Date of flight operation Day of the week of flight operation Scheduled departure time as shown in Official Airline Guide(OAG) Scheduled departure time as shown in CRS(selected by the Carrier) Gate departure time (actual) Scheduled arrival time per OAG Scheduled arrival time per CRS Gate arrival time (actual) Difference between OAG and CRS scheduled departure times Character Character Character Character Num Num Num 2 Max length of 4 3 3 8 1 4 Three letter Airport code Three letter Airport code Format ccyymmdd Mon = 1, Sun = 7 Local time 24 hour clock Num 4 Local time 24 hour clock Num Num Num Num Num 4 4 4 4 Max length of 4 Difference between OAG and CRS scheduled arrival times Scheduled elapsed time per CRS Actual gate-to-gate time Departure delay time (actual minutes CRS) Arrival delay time (actual minutes CRS) Elapsed time difference (actual minutes CRS) Wheels-off time (actual) Wheels-on time (actual) Aircraft tail number Cancellation code Minutes late for Delay Code E – Carrier Caused Num Max length of 4 Local time 24 hour clock Local time 24 hour clock Local time 24 hour clock Local time 24 hour clock In minutes (2 hours=120 min) G minus H In minutes – J minus K Num Num Num Num Num Num Num Character Character Num Max length of 4 Max length of 4 Max length of 4 Max length of 4 Max length of 4 4 4 6 1 Max length of 4 Two letter IATA code In minutes – K minus H In minutes – L minus I In minutes – I minus H In minutes – L minus K In minutes – P minus O Local time 24 hour clock Local time 24 hour clock Values are A, B, C, D In minutes 1 A reporting carrier must use this form to report on-time performance data if the flight was not a codeshare flight with another U.S. carrier. A reporting carrier must also use this form to report on-time performance data if the reporting carrier operated, but did not market, a codeshare flight. -1- Y Z AA AB AC AD AE AF AG AH AI AJ AK AL AM AN AO AP AQ AR AS AT AU AV AW AX AY AZ BA BB BC BD BE BF BG BH BI BJ Minutes late for Delay Code F – Weather Minutes late for Delay Code G – National Aviation System (NAS) Minutes late for Delay Code H – Security Minutes late for Delay Code I – Late Arriving Flight (Initial) First gate departure time (actual) Total ground time away from gate Longest ground time away from gate Number of landings at diverted airports Num Num Max length of 4 Max length of 4 In minutes In minutes Num Num Max length of 4 Max length of 4 In minutes In minutes Num Num Num Num 4 Max length of 4 Max length of 4 1 Diverted airport code 1 Wheels-on time at diverted airport Total ground time away from gate at diverted airport Longest ground time away from gate at diverted airport Wheels-off time (actual) at diverted airport Aircraft tail number Diverted airport code 2 Wheels-on time at diverted airport Total ground time away from gate at diverted airport Longest ground time away from gate at diverted airport Wheels-off time (actual) at diverted airport Aircraft tail number Diverted airport code 3 Wheels-on time at diverted airport Total ground time away from gate at diverted airport Longest ground time away from gate at diverted airport Wheels-off time (actual) at diverted airport Aircraft tail number Diverted airport code 4 Wheels-on time at diverted airport Total ground time away from gate at diverted airport Longest ground time away from gate at diverted airport Wheels-off time (actual) at diverted airport Aircraft tail number Diverted airport code 5 Wheels-on time at diverted airport Total ground time away from gate at diverted airport Longest ground time away from gate at diverted airport Wheels-off time (actual) at diverted airport Aircraft tail number Character Num Num 3 4 Max length of 4 Local time 24 hour clock In minutes In minutes 1 to 5 for diversions, 9 designates a fly return canceled flight Three letter Airport code Local time 24 hour clock In minutes Num Max length of 4 In minutes Num Character Character Num Num 4 6 3 4 Max length of 4 Local time 24 hour clock Num Max length of 4 In minutes Num Character Character Num Num 4 6 3 4 Max length of 4 Local time 24 hour clock Num Max length of 4 In minutes Num Character Character Num Num 4 6 3 4 Max length of 4 Local time 24 hour clock Num Max length of 4 In minutes Num Character Character Num Num 4 6 3 4 Max length of 4 Local time 24 hour clock Num Max length of 4 In minutes Num Character 4 6 Local time 24 hour clock -2- Three letter Airport code Local time 24 hour clock In minutes Three letter Airport code Local time 24 hour clock In minutes Three letter Airport code Local time 24 hour clock In minutes Three letter Airport code Local time 24 hour clock In minutes -3- Form 2A: On-Time Performance Data for Codeshare Flights (Long)2 Field A1 B1 A2 B2 C D E F G H I J K L M N O P Q R S T U V W X Y Z AA AB AC AD AE AF AG AH AI AJ Description Type Length Comments Marketing Carrier code Marketing Carrier Flight number Operating Carrier Code Operating Carrier Flight Number Departure airport code Arrival airport code Date of flight operation Day of the week of flight operation Scheduled departure time as shown in Official Airline Guide(OAG) Scheduled departure time as shown in CRS(selected by the Carrier) Gate departure time (actual) Scheduled arrival time per OAG Scheduled arrival time per CRS Gate arrival time (actual) Difference between OAG and CRS scheduled departure times Character Character Character Character Character Character Num Num Num 2 Max length of 4 2 Max length of 4 3 3 8 1 4 Num 4 Local time 24 hour clock Num Num Num Num Num 4 4 4 4 Max length of 4 Difference between OAG and CRS scheduled arrival times Scheduled elapsed time per CRS Actual gate-to-gate time Departure delay time (actual minutes CRS) Arrival delay time (actual minutes CRS) Elapsed time difference (actual minutes CRS) Wheels-off time (actual) Wheels-on time (actual) Aircraft tail number Cancellation code Minutes late for Delay Code E – Carrier Caused Minutes late for Delay Code F – Weather Minutes late for Delay Code G – National Aviation System (NAS) Minutes late for Delay Code H – Security Minutes late for Delay Code I – Late Arriving Flight (Initial) First gate departure time (actual) Total ground time away from gate Longest ground time away from gate Number of landings at diverted airports Num Max length of 4 Local time 24 hour clock Local time 24 hour clock Local time 24 hour clock Local time 24 hour clock In minutes (2 hours=120 min) G minus H In minutes – J minus K Num Num Num Num Num Num Num Character Character Num Max length of 4 Max length of 4 Max length of 4 Max length of 4 Max length of 4 4 4 6 1 Max length of 4 In minutes – K minus H In minutes – L minus I In minutes – I minus H In minutes – L minus K In minutes – P minus O Local time 24 hour clock Local time 24 hour clock Num Num Max length of 4 Max length of 4 In minutes In minutes Num Num Max length of 4 Max length of 4 In minutes In minutes Num Num Num Num 4 Max length of 4 Max length of 4 1 Diverted airport code 1 Wheels-on time at diverted airport Total ground time away from gate at diverted airport Longest ground time away from gate at Character Num Num 3 4 Max length of 4 Local time 24 hour clock In minutes In minutes 1 to 5 for diversions, 9 designates a fly return canceled flight Three letter Airport code Local time 24 hour clock In minutes Num Max length of 4 In minutes Two letter IATA code Two letter IATA code Three letter Airport code Three letter Airport code Format ccyymmdd Mon = 1, Sun = 7 Local time 24 hour clock Values are A, B, C, D In minutes 2 A reporting carrier must use this form to report on-time performance data if: (1) the flight was a codeshare flight held out to the public with only one U.S. carrier designator code (that a flight is also held out under any number of foreign carrier designator codes is irrelevant to determining whether to report); (2) the reporting carrier marketed, but did not operate, the codeshare flight; (3) there was no flight substitution; and (4) the operating carrier of the flight is not a reporting carrier. -4- AK AL AM AN AO AP AQ AR AS AT AU AV AW AX AY AZ BA BB BC BD BE BF BG BH BI BJ diverted airport Wheels-off time (actual) at diverted airport Aircraft tail number Diverted airport code 2 Wheels-on time at diverted airport Total ground time away from gate at diverted airport Longest ground time away from gate at diverted airport Wheels-off time (actual) at diverted airport Aircraft tail number Diverted airport code 3 Wheels-on time at diverted airport Total ground time away from gate at diverted airport Longest ground time away from gate at diverted airport Wheels-off time (actual) at diverted airport Aircraft tail number Diverted airport code 4 Wheels-on time at diverted airport Total ground time away from gate at diverted airport Longest ground time away from gate at diverted airport Wheels-off time (actual) at diverted airport Aircraft tail number Diverted airport code 5 Wheels-on time at diverted airport Total ground time away from gate at diverted airport Longest ground time away from gate at diverted airport Wheels-off time (actual) at diverted airport Aircraft tail number Num Character Character Num Num 4 6 3 4 Max length of 4 Local time 24 hour clock Num Max length of 4 In minutes Num Character Character Num Num 4 6 3 4 Max length of 4 Local time 24 hour clock Num Max length of 4 In minutes Num Character Character Num Num 4 6 3 4 Max length of 4 Local time 24 hour clock Num Max length of 4 In minutes Num Character Character Num Num 4 6 3 4 Max length of 4 Local time 24 hour clock Num Max length of 4 In minutes 4 6 * Local time 24 hour clock Num Character * * -5- Three letter Airport code Local time 24 hour clock In minutes Three letter Airport code Local time 24 hour clock In minutes Three letter Airport code Local time 24 hour clock In minutes Three letter Airport code Local time 24 hour clock In minutes Form 2B: On-Time Performance Data for Codeshare Flights (Short)3 Field A1 B1 A2 B2 C D E F G J V Description Marketing Carrier code Marketing Carrier Flight number Operating Carrier code Operating Carrier Flight number Departure airport code Arrival airport code Date of flight operation Day of the week of flight operation Scheduled departure time as shown in Official Airline Guide (OAG) Scheduled arrival time per OAG Aircraft tail number Type Length Character Character Character Character Character Character Num Num Num 2 Max length of 4 2 Max length of 4 3 3 8 1 4 Num Character 4 6 Comments Two letter IATA code Two letter IATA code Three letter Airport code Three letter Airport code Format ccyymmdd Mon = 1, Sun = 7 Local time 24 hour clock Local time 24 hour clock 3 A reporting carrier must use this form to report on-time performance data if: (1) the flight was a codeshare flight held out to the public with only one U.S. carrier designator code (that a flight is also held out under any number of foreign carrier designator codes is irrelevant to determining whether to report); (2) the reporting carrier marketed, but did not operate, the codeshare flight; (3) there was no flight substitution; and (4) the operating carrier of the flight is also a reporting carrier. -6- Form 3A: On-Time Performance Data for Codeshare Flights (Long)4 (For Use Only By Marketing Carrier Following July 2017 OAEP Enforcement Policy When There Is A Swap) Field Description Type Length A1 B1 A2 B2 A3 B3 C D E F G5 Marketing Carrier code Marketing Carrier Flight number Scheduled Operating Carrier Code Scheduled Operating Carrier Flight Number Actual Operating Carrier Code Actual Operating Carrier Flight Number Departure airport code Arrival airport code Date of flight operation Day of the week of flight operation Scheduled departure time as shown in Official Airline Guide(OAG) Scheduled departure time as shown in CRS(selected by the Carrier) Gate departure time (actual) Scheduled arrival time per OAG Scheduled arrival time per CRS Gate arrival time (actual) Difference between OAG and CRS scheduled departure times Character Character Character Character Character Character Character Character Num Num Num 2 Max length of 4 2 Max length of 4 2 Max length of 4 3 3 8 1 4 Num 4 Local time 24 hour clock Num Num Num Num Num 4 4 4 4 Max length of 4 Difference between OAG and CRS scheduled arrival times Scheduled elapsed time per CRS Actual gate-to-gate time Departure delay time (actual minutes) Arrival delay time (actual minutes) Elapsed time difference (actual minutes) Wheels-off time (actual) Wheels-on time (actual) Aircraft tail number Cancellation code Minutes late for Delay Code E – Carrier Caused Minutes late for Delay Code F – Weather Minutes late for Delay Code G – National Aviation System (NAS) Minutes late for Delay Code H – Security Minutes late for Delay Code I – Late Arriving Flight (Initial) Num Max length of 4 Local time 24 hour clock Local time 24 hour clock Local time 24 hour clock Local time 24 hour clock In minutes (2 hours=120 min) G minus H In minutes – J minus K Num Num Num Num Num Num Num Character Character Num Max length of 4 Max length of 4 Max length of 4 Max length of 4 Max length of 4 4 4 6 1 Max length of 4 In minutes – K minus H In minutes – L minus I In minutes – I minus H In minutes – L minus K In minutes – P minus O Local time 24 hour clock Local time 24 hour clock Num Num Max length of 4 Max length of 4 In minutes In minutes Num Num Max length of 4 Max length of 4 In minutes In minutes H I J K L M N O P Q R S T U V W X Y Z AA AB Comments Two letter IATA code Two letter IATA code Two letter IATA code Three letter Airport code Three letter Airport code Format ccyymmdd Mon = 1, Sun = 7 Local time 24 hour clock Values are A,B,C, and D In minutes 4 A reporting carrier must use this form to report on-time performance data if: (1) the originally scheduled flight was a codeshare flight held out to the public with only one U.S. carrier designator code (that a flight is also held out under any number of foreign carrier designator codes is irrelevant to determining whether to report); (2) there was a flight substitution (Codeshare Swap); (3) the reporting carrier marketed the originally scheduled codeshare flight but did not operate the originally scheduled codeshare flight or the substitute codeshare flight; and (4) the substitute flight was an extra section flight or the carrier that operated the flight is not a reporting carrier. 5 For the purposes of fields G, H, J, and K, a carrier must provide information as it relates to the originally scheduled flight that was not operated and subject to the Codeshare Swap and must apply that information in calculating the other fields that are based on the information in fields G, H, J, and K (i.e. M, N, O, Q, R, S). All other fields and references to them relate to the substitute flight that was actually operated. -7- AC AD AE AF First gate departure time (actual) Total ground time away from gate Longest ground time away from gate Number of landings at diverted airports Num Num Num Num 4 Max length of 4 Max length of 4 1 AG AH AI Diverted airport code 1 Wheels-on time at diverted airport Total ground time away from gate at diverted airport Longest ground time away from gate at diverted airport Wheels-off time (actual) at diverted airport Aircraft tail number Diverted airport code 2 Wheels-on time at diverted airport Total ground time away from gate at diverted airport Longest ground time away from gate at diverted airport Wheels-off time (actual) at diverted airport Aircraft tail number Diverted airport code 3 Wheels-on time at diverted airport Total ground time away from gate at diverted airport Longest ground time away from gate at diverted airport Wheels-off time (actual) at diverted airport Aircraft tail number Diverted airport code 4 Wheels-on time at diverted airport Total ground time away from gate at diverted airport Longest ground time away from gate at diverted airport Wheels-off time (actual) at diverted airport Aircraft tail number Diverted airport code 5 Wheels-on time at diverted airport Total ground time away from gate at diverted airport Longest ground time away from gate at diverted airport Wheels-off time (actual) at diverted airport Aircraft tail number Character Num Num 3 4 Max length of 4 Local time 24 hour clock In minutes In minutes 1 to 5 for diversions, 9 designates a fly return canceled flight Three letter Airport code Local time 24 hour clock In minutes Num Max length of 4 In minutes Num Character Character Num Num 4 6 3 4 Max length of 4 Local time 24 hour clock Num Max length of 4 In minutes Num Character Character Num Num 4 6 3 4 Max length of 4 Local time 24 hour clock Num Max length of 4 In minutes Num Character Character Num Num 4 6 3 4 Max length of 4 Local time 24 hour clock Num Max length of 4 In minutes Num Character Character Num Num 4 6 3 4 Max length of 4 Local time 24 hour clock Num Max length of 4 In minutes 4 6 * Local time 24 hour clock AJ AK AL AM AN AO AP AQ AR AS AT AU AV AW AX AY AZ BA BB BC BD BE BF BG BH BI BJ Num Character * * Three letter Airport code Local time 24 hour clock In minutes Three letter Airport code Local time 24 hour clock In minutes Three letter Airport code Local time 24 hour clock In minutes Three letter Airport code Local time 24 hour clock In minutes Form 3B: On-Time Performance Data for Codeshare Flights (Short)6 (For Use Only By Marketing Carrier Following July 2017 OAEP Enforcement Policy When There Is A Swap) 6 A reporting carrier must use this form to report on-time performance data if: (1) the originally scheduled flight was a codeshare flight held out to the public with only one U.S. carrier designator code (that a flight is also held out under any number of foreign carrier designator codes is irrelevant to determining whether to report); (2) there was a flight substitution (Codeshare Swap); (3) the reporting carrier marketed the originally scheduled codeshare flight but did not operate the originally scheduled codeshare flight or the substitute codeshare flight; (4) the substitute flight was not an extra section flight; and (5) the substitute flight was operated by a reporting carrier. -8- Field Description Type Length A1 B1 A2 B2 A3 B3 C D E F G7 Marketing Carrier code Marketing Carrier Flight number Scheduled Operating Carrier code Scheduled Operating Carrier Flight number Actual Operating Carrier code Actual Operating Carrier Flight number Departure airport code Arrival airport code Date of flight operation Day of the week of flight operation Scheduled departure time as shown in Official Airline Guide (OAG) Scheduled arrival time per OAG Aircraft tail number Character Character Character Character Character Character Character Character Num Num Num 2 Max length of 4 2 Max length of 4 2 Max length of 4 3 3 8 1 4 Num Character 4 6 J V Comments Two letter IATA code Two letter IATA code Two letter IATA code Three letter Airport code Three letter Airport code Format ccyymmdd Mon = 1, Sun = 7 Local time 24 hour clock Local time 24 hour clock 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,ZZ,5678,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,,,,,,,,,,, ,,,,,,,,,,,,,, 7 For fields G and J, a carrier must provide information as it relates to the originally scheduled flight that was not operated and subject to the Codeshare Swap. All other fields relate to the substitute flight that was actually operated. -9- PART 234 – ASQP – Mishandled Baggage Report 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 10 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, OAI/BTS/OST-R, RTS-42, 1200 New Jersey Avenue, SE, Washington, D.C. 20590 REQUIREMENTS RECORD DESCRIPTION: ASQP – Mishandled Baggage Report Sample Record Format: XX,2010,03,8004000,35000 1. ASQP – Mishandled Baggage Report (MBR) Data File Data Type Length Comments Sample Data Carrier code Year of Data Character Numeric 2 4 Two letter IATA code Year (CCYY) Month of Data Number of Domestic Scheduled Passengers Enplaned Number of Mishandled Baggage Reports (MBRs) Filed with Carrier Numeric Numeric 2 Varies Month (MM) XX 2010 03 Numeric Varies Field Description 8004000 35000 Number of Domestic Scheduled Passengers Enplaned: All enplaned scheduled domestic passengers are counted, both revenue and non-revenue passengers are included in this total. Number of Mishandled Baggage Reports (MBRs) Filed with Carrier: Carriers are required to report all domestic reports of mishandled checked baggage, including delayed, lost, stolen, pilfered, and damaged baggage. Carriers must count an MBR even when the MBR does not result in a claim for compensation. What should be reported as an MBR? Any report filed by a passenger regarding mishandled baggage, whether or not immediately recorded by the carrier, must be reported to DOT. An MBR resolved within 30 minutes, or with the arrival of the next flight, is still reportable to DOT, and should not be filtered out. The Mishandled Baggage Report sent to DOT should include, for example, reports filed by a passenger even if the passenger had agreed to a voluntary separation from his/her baggage, courtesy tracer reports, baggage improperly checked by skycaps, baggage claimed by the wrong passenger, and baggage delayed because of security. Even if it was determined that the carrier was not at fault, an MBR must be counted in the carrier’s submission to DOT if the passenger filed an MBR with the carrier. Also, carriers should include informal reports taken while a search was made of the carousels. - 10 - What should not be reported as an MBR to DOT? Carriers should not include MBRs submitted for charter operations, MBRs submitted by codeshare passengers that did not actually travel on a flight operated by the reporting air carrier (also, carriers must not report to DOT any MBR involving an itinerary where a code-sharing partner provides the final segment of the transportation), MBRs submitted for carry-on baggage, and MBRs submitted by international travelers even if the international traveler had a domestic leg on his or her trip, and MBRs submitted for non-domestic operations. Domestic operations encompass operations between the 50 states of the United States, the District of Columbia, the Commonwealth of Puerto Rico, the U.S. Virgin Islands and the possessions of the United States. Carriers should also exclude MBRs submitted by passengers travelling on separate tickets on different airlines, or on a single ticket for travel on different carriers that do not have a baggage transfer agreement. - 11 -