Field Name | Description | Support Table |
Summaries |
| Year | |
Time Period |
| Quarter (1-4) | Get Lookup Table |
| Month | Get Lookup Table |
| Day of Month | |
| Day of Week | Get Lookup Table |
| Flight Date (yyyymmdd) | |
Airline |
| Unique Marketing Carrier Code. When the same code has been used by multiple carriers, a numeric suffix is used for earlier users, for example, PA, PA(1), PA(2). Use this field for analysis across a range of years. | Get Lookup Table |
| Reporting Carrier Operated or Branded Code Share Partners | Get Lookup Table |
| An identification number assigned by US DOT to identify a unique airline (carrier). A unique airline (carrier) is defined as one holding and reporting under the same DOT certificate regardless of its Code, Name, or holding company/corporation. | Get Lookup Table |
| Code assigned by IATA and commonly used to identify a carrier. As the same code may have been assigned to different carriers over time, the code is not always unique. For analysis, use the Unique Carrier Code. | Get Lookup Table |
| Flight Number | |
| Unique Scheduled Operating Carrier Code. When the same code has been used by multiple carriers, a numeric suffix is used for earlier users,for example, PA, PA(1), PA(2). Use this field for analysis across a range of years. | Get Lookup Table |
| An identification number assigned by US DOT to identify a unique airline (carrier). A unique airline (carrier) is defined as one holding and reporting under the same DOT certificate regardless of its Code, Name, or holding company/corporation. | Get Lookup Table |
| Code assigned by IATA and commonly used to identify a carrier. As the same code may have been assigned to different carriers over time, the code is not always unique. For analysis, use the Unique Carrier Code. | Get Lookup Table |
| Flight Number | |
| Unique Carrier Code. When the same code has been used by multiple carriers, a numeric suffix is used for earlier users, for example, PA, PA(1), PA(2). Use this field for analysis across a range of years. | Get Lookup Table |
| An identification number assigned by US DOT to identify a unique airline (carrier). A unique airline (carrier) is defined as one holding and reporting under the same DOT certificate regardless of its Code, Name, or holding company/corporation. | Get Lookup Table |
| Code assigned by IATA and commonly used to identify a carrier. As the same code may have been assigned to different carriers over time, the code is not always unique. For analysis, use the Unique Carrier Code. | Get Lookup Table |
| Tail Number | |
| Flight Number | |
Origin |
| Origin Airport, Airport ID. An identification number assigned by US DOT to identify a unique airport. Use this field for airport analysis across a range of years because an airport can change its airport code and airport codes can be reused. | Get Lookup Table |
| Origin Airport, Airport Sequence ID. An identification number assigned by US DOT to identify a unique airport at a given point of time. Airport attributes, such as airport name or coordinates, may change over time. | Get Lookup Table |
| Origin Airport, City Market ID. City Market ID is an identification number assigned by US DOT to identify a city market. Use this field to consolidate airports serving the same city market. | Get Lookup Table |
| Origin Airport | Get Lookup Table |
| Origin Airport, City Name | |
| Origin Airport, State Code | Get Lookup Table |
| Origin Airport, State Fips | Get Lookup Table |
| Origin Airport, State Name | |
| Origin Airport, World Area Code | Get Lookup Table |
Destination |
| Destination Airport, Airport ID. An identification number assigned by US DOT to identify a unique airport. Use this field for airport analysis across a range of years because an airport can change its airport code and airport codes can be reused. | Get Lookup Table |
| Destination Airport, Airport Sequence ID. An identification number assigned by US DOT to identify a unique airport at a given point of time. Airport attributes, such as airport name or coordinates, may change over time. | Get Lookup Table |
| Destination Airport, City Market ID. City Market ID is an identification number assigned by US DOT to identify a city market. Use this field to consolidate airports serving the same city market. | Get Lookup Table |
| Destination Airport | Get Lookup Table |
| Destination Airport, City Name | |
| Destination Airport, State Code | Get Lookup Table |
| Destination Airport, State Fips | Get Lookup Table |
| Destination Airport, State Name | |
| Destination Airport, World Area Code | Get Lookup Table |
Departure Performance |
| CRS Departure Time (local time: hhmm) | |
| Actual Departure Time (local time: hhmm) | |
| Difference in minutes between scheduled and actual departure time. Early departures show negative numbers. | |
| Difference in minutes between scheduled and actual departure time. Early departures set to 0. | |
| Departure Delay Indicator, 15 Minutes or More (1=Yes) | Get Lookup Table |
| Departure Delay intervals, every (15 minutes from <-15 to >180) | Get Lookup Table |
| CRS Departure Time Block, Hourly Intervals | Get Lookup Table |
| Taxi Out Time, in Minutes | |
| Wheels Off Time (local time: hhmm) | |
Arrival Performance |
| Wheels On Time (local time: hhmm) | |
| Taxi In Time, in Minutes | |
| CRS Arrival Time (local time: hhmm) | |
| Actual Arrival Time (local time: hhmm) | |
| Difference in minutes between scheduled and actual arrival time. Early arrivals show negative numbers. | |
| Difference in minutes between scheduled and actual arrival time. Early arrivals set to 0. | |
| Arrival Delay Indicator, 15 Minutes or More (1=Yes) | Get Lookup Table |
| Arrival Delay intervals, every (15-minutes from <-15 to >180) | Get Lookup Table |
| CRS Arrival Time Block, Hourly Intervals | Get Lookup Table |
Cancellations and Diversions |
| Cancelled Flight Indicator (1=Yes) | Get Lookup Table |
| Specifies The Reason For Cancellation | Get Lookup Table |
| Diverted Flight Indicator (1=Yes) | Get Lookup Table |
| Duplicate flag marked Y if the flight is swapped based on Form-3A data | Get Lookup Table |
Flight Summaries |
| CRS Elapsed Time of Flight, in Minutes | |
| Elapsed Time of Flight, in Minutes | |
| Flight Time, in Minutes | |
| Number of Flights | |
| Distance between airports (miles) | |
| Distance Intervals, every 250 Miles, for Flight Segment | Get Lookup Table |
Cause of Delay (Data starts 6/2003) |
| Carrier Delay, in Minutes | |
| Weather Delay, in Minutes | |
| National Air System Delay, in Minutes | |
| Security Delay, in Minutes | |
| Late Aircraft Delay, in Minutes | |
Gate Return Information at Origin Airport (Data starts 10/2008) |
| First Gate Departure Time at Origin Airport | |
| Total Ground Time Away from Gate for Gate Return or Cancelled Flight | |
| Longest Time Away from Gate for Gate Return or Cancelled Flight | |
Diverted Airport Information (Data starts 10/2008) |
| Number of Diverted Airport Landings | Get Lookup Table |
| Diverted Flight Reaching Scheduled Destination Indicator (1=Yes) | Get Lookup Table |
| Elapsed Time of Diverted Flight Reaching Scheduled Destination, in Minutes. The ActualElapsedTime column remains NULL for all diverted flights. | |
| Difference in minutes between scheduled and actual arrival time for a diverted flight reaching scheduled destination. The ArrDelay column remains NULL for all diverted flights. | |
| Distance between scheduled destination and final diverted airport (miles). Value will be 0 for diverted flight reaching scheduled destination. | |
| Diverted Airport Code1 | |
| Airport ID of Diverted Airport 1. Airport ID is a Unique Key for an Airport | Get Lookup Table |
| Airport Sequence ID of Diverted Airport 1. Unique Key for Time Specific Information for an Airport | Get Lookup Table |
| Wheels On Time (local time: hhmm) at Diverted Airport Code1 | |
| Total Ground Time Away from Gate at Diverted Airport Code1 | |
| Longest Ground Time Away from Gate at Diverted Airport Code1 | |
| Wheels Off Time (local time: hhmm) at Diverted Airport Code1 | |
| Aircraft Tail Number for Diverted Airport Code1 | |
| Diverted Airport Code2 | |
| Airport ID of Diverted Airport 2. Airport ID is a Unique Key for an Airport | Get Lookup Table |
| Airport Sequence ID of Diverted Airport 2. Unique Key for Time Specific Information for an Airport | Get Lookup Table |
| Wheels On Time (local time: hhmm) at Diverted Airport Code2 | |
| Total Ground Time Away from Gate at Diverted Airport Code2 | |
| Longest Ground Time Away from Gate at Diverted Airport Code2 | |
| Wheels Off Time (local time: hhmm) at Diverted Airport Code2 | |
| Aircraft Tail Number for Diverted Airport Code2 | |
| Diverted Airport Code3 | |
| Airport ID of Diverted Airport 3. Airport ID is a Unique Key for an Airport | Get Lookup Table |
| Airport Sequence ID of Diverted Airport 3. Unique Key for Time Specific Information for an Airport | Get Lookup Table |
| Wheels On Time (local time: hhmm) at Diverted Airport Code3 | |
| Total Ground Time Away from Gate at Diverted Airport Code3 | |
| Longest Ground Time Away from Gate at Diverted Airport Code3 | |
| Wheels Off Time (local time: hhmm) at Diverted Airport Code3 | |
| Aircraft Tail Number for Diverted Airport Code3 | |
| Diverted Airport Code4 | |
| Airport ID of Diverted Airport 4. Airport ID is a Unique Key for an Airport | Get Lookup Table |
| Airport Sequence ID of Diverted Airport 4. Unique Key for Time Specific Information for an Airport | Get Lookup Table |
| Wheels On Time (local time: hhmm) at Diverted Airport Code4 | |
| Total Ground Time Away from Gate at Diverted Airport Code4 | |
| Longest Ground Time Away from Gate at Diverted Airport Code4 | |
| Wheels Off Time (local time: hhmm) at Diverted Airport Code4 | |
| Aircraft Tail Number for Diverted Airport Code4 | |
| Diverted Airport Code5 | |
| Airport ID of Diverted Airport 5. Airport ID is a Unique Key for an Airport | Get Lookup Table |
| Airport Sequence ID of Diverted Airport 5. Unique Key for Time Specific Information for an Airport | Get Lookup Table |
| Wheels On Time (local time: hhmm) at Diverted Airport Code5 | |
| Total Ground Time Away from Gate at Diverted Airport Code5 | |
| Longest Ground Time Away from Gate at Diverted Airport Code5 | |
| Wheels Off Time (local time: hhmm) at Diverted Airport Code5 | |
| Aircraft Tail Number for Diverted Airport Code5 | |