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 | |