| Field Name | Description |
|---|
|
| *OntimeArrivalPct | Percent of flights that arrive on time. For percent of on time arrivals at specific airports, click Analysis. Note: If you select Origin as a category, you get percent of flights that depart from those airports and arrive on time. | Analysis |
| *OntimeDeparturePct | Percent of flights that depart on time. For percent of on time departures at specific airports, click Analysis. Note: If you select Dest as a category, you get percent of flights that depart on time and arrive at those airports. | Analysis |
|
| Year | Year | |
| Quarter | Quarter (1-4) | Analysis |
| Month | Month | Analysis |
| DayofMonth | Day of Month | |
| DayOfWeek | Day of Week | Analysis |
| FlightDate | Flight Date (yyyymmdd) | |
|
| Reporting_Airline | 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. | Analysis |
| DOT_ID_Reporting_Airline | 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. | Analysis |
| IATA_CODE_Reporting_Airline | 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. | |
| Tail_Number | Tail Number | |
| Flight_Number_Reporting_Airline | Flight Number | |
|
| OriginAirportID | 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. | Analysis |
| OriginAirportSeqID | 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. | |
| OriginCityMarketID | 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. | Analysis |
| Origin | Origin Airport | Analysis |
| OriginCityName | Origin Airport, City Name | |
| OriginState | Origin Airport, State Code | Analysis |
| OriginStateFips | Origin Airport, State Fips | Analysis |
| OriginStateName | Origin Airport, State Name | |
| OriginWac | Origin Airport, World Area Code | Analysis |
|
| DestAirportID | 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. | Analysis |
| DestAirportSeqID | 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. | |
| DestCityMarketID | 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. | Analysis |
| Dest | Destination Airport | Analysis |
| DestCityName | Destination Airport, City Name | |
| DestState | Destination Airport, State Code | Analysis |
| DestStateFips | Destination Airport, State Fips | Analysis |
| DestStateName | Destination Airport, State Name | |
| DestWac | Destination Airport, World Area Code | Analysis |
|
| CRSDepTime | CRS Departure Time (local time: hhmm) | |
| DepTime | Actual Departure Time (local time: hhmm) | |
| DepDelay | Difference in minutes between scheduled and actual departure time. Early departures show negative numbers. | Analysis |
| DepDelayMinutes | Difference in minutes between scheduled and actual departure time. Early departures set to 0. | Analysis |
| DepDel15 | Departure Delay Indicator, 15 Minutes or More (1=Yes) | Analysis |
| DepartureDelayGroups | Departure Delay intervals, every (15 minutes from <-15 to >180) | Analysis |
| DepTimeBlk | CRS Departure Time Block, Hourly Intervals | Analysis |
| TaxiOut | Taxi Out Time, in Minutes | Analysis |
| WheelsOff | Wheels Off Time (local time: hhmm) | |
|
| WheelsOn | Wheels On Time (local time: hhmm) | |
| TaxiIn | Taxi In Time, in Minutes | Analysis |
| CRSArrTime | CRS Arrival Time (local time: hhmm) | |
| ArrTime | Actual Arrival Time (local time: hhmm) | |
| ArrDelay | Difference in minutes between scheduled and actual arrival time. Early arrivals show negative numbers. | Analysis |
| ArrDelayMinutes | Difference in minutes between scheduled and actual arrival time. Early arrivals set to 0. | Analysis |
| ArrDel15 | Arrival Delay Indicator, 15 Minutes or More (1=Yes) | Analysis |
| ArrivalDelayGroups | Arrival Delay intervals, every (15-minutes from <-15 to >180) | Analysis |
| ArrTimeBlk | CRS Arrival Time Block, Hourly Intervals | Analysis |
|
| Cancelled | Cancelled Flight Indicator (1=Yes) | Analysis |
| CancellationCode | Specifies The Reason For Cancellation | Analysis |
| Diverted | Diverted Flight Indicator (1=Yes) | Analysis |
|
| CRSElapsedTime | CRS Elapsed Time of Flight, in Minutes | Analysis |
| ActualElapsedTime | Elapsed Time of Flight, in Minutes | Analysis |
| AirTime | Flight Time, in Minutes | Analysis |
| Flights | Number of Flights | Analysis |
| Distance | Distance between airports (miles) | Analysis |
| DistanceGroup | Distance Intervals, every 250 Miles, for Flight Segment | Analysis |
|
| CarrierDelay | Carrier Delay, in Minutes | Analysis |
| WeatherDelay | Weather Delay, in Minutes | Analysis |
| NASDelay | National Air System Delay, in Minutes | Analysis |
| SecurityDelay | Security Delay, in Minutes | Analysis |
| LateAircraftDelay | Late Aircraft Delay, in Minutes | Analysis |
|
| FirstDepTime | First Gate Departure Time at Origin Airport | |
| TotalAddGTime | Total Ground Time Away from Gate for Gate Return or Cancelled Flight | Analysis |
| LongestAddGTime | Longest Time Away from Gate for Gate Return or Cancelled Flight | Analysis |
|
| DivAirportLandings | Number of Diverted Airport Landings | Analysis |
| DivReachedDest | Diverted Flight Reaching Scheduled Destination Indicator (1=Yes) | Analysis |
| DivActualElapsedTime | Elapsed Time of Diverted Flight Reaching Scheduled Destination, in Minutes. The ActualElapsedTime column remains NULL for all diverted flights. | Analysis |
| DivArrDelay | 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. | Analysis |
| DivDistance | Distance between scheduled destination and final diverted airport (miles). Value will be 0 for diverted flight reaching scheduled destination. | Analysis |
| Div1Airport | Diverted Airport Code1 | |
| Div1AirportID | Airport ID of Diverted Airport 1. Airport ID is a Unique Key for an Airport | |
| Div1AirportSeqID | Airport Sequence ID of Diverted Airport 1. Unique Key for Time Specific Information for an Airport | |
| Div1WheelsOn | Wheels On Time (local time: hhmm) at Diverted Airport Code1 | |
| Div1TotalGTime | Total Ground Time Away from Gate at Diverted Airport Code1 | |
| Div1LongestGTime | Longest Ground Time Away from Gate at Diverted Airport Code1 | |
| Div1WheelsOff | Wheels Off Time (local time: hhmm) at Diverted Airport Code1 | |
| Div1TailNum | Aircraft Tail Number for Diverted Airport Code1 | |
| Div2Airport | Diverted Airport Code2 | |
| Div2AirportID | Airport ID of Diverted Airport 2. Airport ID is a Unique Key for an Airport | |
| Div2AirportSeqID | Airport Sequence ID of Diverted Airport 2. Unique Key for Time Specific Information for an Airport | |
| Div2WheelsOn | Wheels On Time (local time: hhmm) at Diverted Airport Code2 | |
| Div2TotalGTime | Total Ground Time Away from Gate at Diverted Airport Code2 | |
| Div2LongestGTime | Longest Ground Time Away from Gate at Diverted Airport Code2 | |
| Div2WheelsOff | Wheels Off Time (local time: hhmm) at Diverted Airport Code2 | |
| Div2TailNum | Aircraft Tail Number for Diverted Airport Code2 | |
| Div3Airport | Diverted Airport Code3 | |
| Div3AirportID | Airport ID of Diverted Airport 3. Airport ID is a Unique Key for an Airport | |
| Div3AirportSeqID | Airport Sequence ID of Diverted Airport 3. Unique Key for Time Specific Information for an Airport | |
| Div3WheelsOn | Wheels On Time (local time: hhmm) at Diverted Airport Code3 | |
| Div3TotalGTime | Total Ground Time Away from Gate at Diverted Airport Code3 | |
| Div3LongestGTime | Longest Ground Time Away from Gate at Diverted Airport Code3 | |
| Div3WheelsOff | Wheels Off Time (local time: hhmm) at Diverted Airport Code3 | |
| Div3TailNum | Aircraft Tail Number for Diverted Airport Code3 | |
| Div4Airport | Diverted Airport Code4 | |
| Div4AirportID | Airport ID of Diverted Airport 4. Airport ID is a Unique Key for an Airport | |
| Div4AirportSeqID | Airport Sequence ID of Diverted Airport 4. Unique Key for Time Specific Information for an Airport | |
| Div4WheelsOn | Wheels On Time (local time: hhmm) at Diverted Airport Code4 | |
| Div4TotalGTime | Total Ground Time Away from Gate at Diverted Airport Code4 | |
