ASPM Data Download: Cancelled Flights

From ASPMHelp
Jump to: navigation, search

The Cancelled Flights report of Data Download is designed to provide an estimation of flight cancellations. Prior to receipt and processing of ASQP data, cancelled flights are derived based on flight plan cancellation messages from TFMS, typically filed within an hour of the expected departure of a flight. After receipt of ASQP, cancellations for ASQP carriers are updated based on carrier-reported cancellations and causes. ASQP pertains to domestic flights by the largest passenger airlines. A cancellation in ASQP is defined as “a flight operation that was not operated, but was listed in a carrier’s computer reservation system within seven calendar days of the scheduled departure." No additional information is available for non-ASQP carriers, and the cancellations for those flights remain estimates based on the cancelled flight plans and should be used for for the purpose of internal analysis only.

For information about how to create a Cancelled Flights report, see the ASPM Data Download Manual.

Field definitions are available in ASPM Data Download: Definitions of Variables.

APM Cancelled.jpg


The Cancelled Flights report contains the following variables:

  • FAACarrier. The code identifying the air carrier.
  • FLTNO. The number identifying the flight as assigned by the air carrier. Values: 1 - 9999.
  • Dep_LocID. The code identifying the last reported departure location (e.g. location may be a fix or a landing facility).
  • Arr_LocID. The code identifying the last reported arrival destination (e.g. destination may be a fix or a landing facility).
  • Dep_YYYYMM. The year and month in which the flight was scheduled to depart, using local clock time at a particular location. Year & Month (YYYYMM = 199912).
  • Dep_Day. The day of the month in which the flight was scheduled to depart, using local clock time at a particular location. Values: 1 - 31.
  • Arr_YYYYMM. The year and month in which the flight was scheduled to arrive, using local clock time at a particular location. Year & Month (YYYYMM = 199912).
  • Arr_Day. The day of the month in which the flight was scheduled to arrive, using local clock time at a particular location. Values: 1 - 31.
  • DeSchSEC. The scheduled departure time as listed in the Official Airline Guide (OAG).
  • DeSchDT. The scheduled departure date as listed in the Official Airline Guide (OAG), using local clock time at a particular location. Format: MM/DD/YYYY (MM/DD/YYYY = 12/01/1999).
  • DeSchTM. The scheduled departure time as listed in the Official Airline Guide (OAG), using local clock time at a particular location. Format: HH:MM (HH:MM = 13:45).
  • ArrSchSEC. The scheduled arrival time as listed in the Official Airline Guide (OAG).
  • ArrSchDT. The scheduled arrival date as listed in the Official Airline Guide (OAG), using local clock time at a particular location. Format: MM/DD/YYYY (MM/DD/YYYY = 12/01/1999).
  • ArrSchTM. The scheduled arrival time as listed in the Official Airline Guide (OAG), using local clock time at a particular location. Format: HH:MM (HH:MM = 13:45).
  • Equip. Type of an aircraft as provided by the person who filed the Flight Plan. Combination of up to 4 alphabetic and numeric characters (e.g., B737, MD80, BE02).
  • Equip_Class. The broad category of the aircraft’s engine from the most recent ETMS Time or Route message. Permissible Values: P = piston; J = jet; T=turbo; - = unknown; ‘’ = missing.
  • Add_Flag. A code to indicate that the record should be added into the total number of derived cancelled flights. Values: 1 = Add into the total number of derived cancelled flights; 0 = Do not add into the total number of derived cancelled flights.
  • Rec_Type. A code that indicates the data source. Permissible Values: A = ASQP; R = ETMS.
  • CancCode. A code that indicates the carrier- reported cause for the cancellation. Permissible Values: A = Carrier; B = Weather; C = National Aviation System; D = Security; ‘’ = Blank.
  • MaxCause. When the CANCCODE is “C”, this code indicates whether a National Aviation System (NAS) issue was found in the Operations Network (OPSNET). Permissible Values: 0 = Blank; 1 = Weather; 2 = Volume; 3 = Equipment; 4 = Runway; 5 = Other; 6 = No Match; 7 = No Match; 8 = No Match; 9 = No Match; 10 = No Match; 11 = No Match.


Notes:

  1. UTC Seconds: Values in this format are UTC (Coordinated Universal Time) seconds since January 1, 1980.
  2. Time Format = HH:MM: Values in this format are expressed in terms of a 24-hour clock, with ranges of 00 to 24 hours and 00 to 59 minutes.
  3. Adjustments for time zone or daylight savings time are included in the calculation.
  4. The carrier-reported cause for the cancellation is only available for a record that is from ASQP. Records from TFMS will have a blank carrier-reported cause.


For information about other available reports in the Data Download module, see the Display section.

Retrieved from "https://aspmhelp.faa.gov/index.php?title=ASPM_Data_Download:_Cancelled_Flights&oldid=6323"