RITA > BTS
 
transtats logo
 
Advanced Search
Resources
Data Tools
: On-Time Performance
   Data Tables   Table Contents
Download Instructions  
Latest Available Data: February 2014
 Prezipped File % Missing Documentation Terms
Field Name  Description  Support Table 
Time Period
YearYear 
QuarterQuarter (1-4)Get Lookup Table
MonthMonthGet Lookup Table
DayofMonthDay of Month 
DayOfWeekDay of WeekGet Lookup Table
FlightDateFlight Date (yyyymmdd) 
Airline
UniqueCarrierUnique 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
AirlineIDAn 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
CarrierCode 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
TailNumTail Number 
FlightNumFlight Number 
Origin
OriginAirportIDOrigin 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
OriginAirportSeqIDOrigin 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
OriginCityMarketIDOrigin 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
OriginOrigin AirportGet Lookup Table
OriginCityNameOrigin Airport, City Name 
OriginStateOrigin Airport, State CodeGet Lookup Table
OriginStateFipsOrigin Airport, State FipsGet Lookup Table
OriginStateNameOrigin Airport, State Name 
OriginWacOrigin Airport, World Area CodeGet Lookup Table
Destination
DestAirportIDDestination 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
DestAirportSeqIDDestination 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
DestCityMarketIDDestination 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
DestDestination AirportGet Lookup Table
DestCityNameDestination Airport, City Name 
DestStateDestination Airport, State CodeGet Lookup Table
DestStateFipsDestination Airport, State FipsGet Lookup Table
DestStateNameDestination Airport, State Name 
DestWacDestination Airport, World Area CodeGet Lookup Table
Departure Performance
CRSDepTimeCRS Departure Time (local time: hhmm) 
DepTimeActual Departure Time (local time: hhmm) 
DepDelayDifference in minutes between scheduled and actual departure time. Early departures show negative numbers. 
DepDelayMinutesDifference in minutes between scheduled and actual departure time. Early departures set to 0. 
DepDel15Departure Delay Indicator, 15 Minutes or More (1=Yes)Get Lookup Table
DepartureDelayGroupsDeparture Delay intervals, every (15 minutes from <-15 to >180)Get Lookup Table
DepTimeBlkCRS Departure Time Block, Hourly IntervalsGet Lookup Table
TaxiOutTaxi Out Time, in Minutes 
WheelsOffWheels Off Time (local time: hhmm) 
Arrival Performance
WheelsOnWheels On Time (local time: hhmm) 
TaxiInTaxi In Time, in Minutes 
CRSArrTimeCRS Arrival Time (local time: hhmm) 
ArrTimeActual Arrival Time (local time: hhmm) 
ArrDelayDifference in minutes between scheduled and actual arrival time. Early arrivals show negative numbers. 
ArrDelayMinutesDifference in minutes between scheduled and actual arrival time. Early arrivals set to 0. 
ArrDel15Arrival Delay Indicator, 15 Minutes or More (1=Yes)Get Lookup Table
ArrivalDelayGroupsArrival Delay intervals, every (15-minutes from <-15 to >180)Get Lookup Table
ArrTimeBlkCRS Arrival Time Block, Hourly IntervalsGet Lookup Table
Cancellations and Diversions
CancelledCancelled Flight Indicator (1=Yes)Get Lookup Table
CancellationCodeSpecifies The Reason For CancellationGet Lookup Table
DivertedDiverted Flight Indicator (1=Yes)Get Lookup Table
Flight Summaries
CRSElapsedTimeCRS Elapsed Time of Flight, in Minutes 
ActualElapsedTimeElapsed Time of Flight, in Minutes 
AirTimeFlight Time, in Minutes 
FlightsNumber of Flights 
DistanceDistance between airports (miles) 
DistanceGroupDistance Intervals, every 250 Miles, for Flight SegmentGet Lookup Table
Cause of Delay (Data starts 6/2003)
CarrierDelayCarrier Delay, in Minutes 
WeatherDelayWeather Delay, in Minutes 
NASDelayNational Air System Delay, in Minutes 
SecurityDelaySecurity Delay, in Minutes 
LateAircraftDelayLate Aircraft Delay, in Minutes 
Gate Return Information at Origin Airport (Data starts 10/2008)
FirstDepTimeFirst Gate Departure Time at Origin Airport 
TotalAddGTimeTotal Ground Time Away from Gate for Gate Return or Cancelled Flight 
LongestAddGTimeLongest Time Away from Gate for Gate Return or Cancelled Flight 
Diverted Airport Information (Data starts 10/2008)
DivAirportLandingsNumber of Diverted Airport LandingsGet Lookup Table
DivReachedDestDiverted Flight Reaching Scheduled Destination Indicator (1=Yes)Get Lookup Table
DivActualElapsedTimeElapsed Time of Diverted Flight Reaching Scheduled Destination, in Minutes. The ActualElapsedTime column remains NULL for all diverted flights. 
DivArrDelayDifference in minutes between scheduled and actual arrival time for a diverted flight reaching scheduled destination. The ArrDelay column remains NULL for all diverted flights. 
DivDistanceDistance between scheduled destination and final diverted airport (miles). Value will be 0 for diverted flight reaching scheduled destination. 
Div1AirportDiverted Airport Code1 
Div1AirportIDAirport ID of Diverted Airport 1. Airport ID is a Unique Key for an AirportGet Lookup Table
Div1AirportSeqIDAirport Sequence ID of Diverted Airport 1. Unique Key for Time Specific Information for an AirportGet Lookup Table
Div1WheelsOnWheels On Time (local time: hhmm) at Diverted Airport Code1 
Div1TotalGTimeTotal Ground Time Away from Gate at Diverted Airport Code1 
Div1LongestGTimeLongest Ground Time Away from Gate at Diverted Airport Code1 
Div1WheelsOffWheels Off Time (local time: hhmm) at Diverted Airport Code1 
Div1TailNumAircraft Tail Number for Diverted Airport Code1 
Div2AirportDiverted Airport Code2 
Div2AirportIDAirport ID of Diverted Airport 2. Airport ID is a Unique Key for an AirportGet Lookup Table
Div2AirportSeqIDAirport Sequence ID of Diverted Airport 2. Unique Key for Time Specific Information for an AirportGet Lookup Table
Div2WheelsOnWheels On Time (local time: hhmm) at Diverted Airport Code2 
Div2TotalGTimeTotal Ground Time Away from Gate at Diverted Airport Code2 
Div2LongestGTimeLongest Ground Time Away from Gate at Diverted Airport Code2 
Div2WheelsOffWheels Off Time (local time: hhmm) at Diverted Airport Code2 
Div2TailNumAircraft Tail Number for Diverted Airport Code2 
Div3AirportDiverted Airport Code3 
Div3AirportIDAirport ID of Diverted Airport 3. Airport ID is a Unique Key for an AirportGet Lookup Table
Div3AirportSeqIDAirport Sequence ID of Diverted Airport 3. Unique Key for Time Specific Information for an AirportGet Lookup Table
Div3WheelsOnWheels On Time (local time: hhmm) at Diverted Airport Code3 
Div3TotalGTimeTotal Ground Time Away from Gate at Diverted Airport Code3 
Div3LongestGTimeLongest Ground Time Away from Gate at Diverted Airport Code3 
Div3WheelsOffWheels Off Time (local time: hhmm) at Diverted Airport Code3 
Div3TailNumAircraft Tail Number for Diverted Airport Code3 
Div4AirportDiverted Airport Code4 
Div4AirportIDAirport ID of Diverted Airport 4. Airport ID is a Unique Key for an AirportGet Lookup Table
Div4AirportSeqIDAirport Sequence ID of Diverted Airport 4. Unique Key for Time Specific Information for an AirportGet Lookup Table
Div4WheelsOnWheels On Time (local time: hhmm) at Diverted Airport Code4 
Div4TotalGTimeTotal Ground Time Away from Gate at Diverted Airport Code4 
Div4LongestGTimeLongest Ground Time Away from Gate at Diverted Airport Code4 
Div4WheelsOffWheels Off Time (local time: hhmm) at Diverted Airport Code4 
Div4TailNumAircraft Tail Number for Diverted Airport Code4 
Div5AirportDiverted Airport Code5 
Div5AirportIDAirport ID of Diverted Airport 5. Airport ID is a Unique Key for an AirportGet Lookup Table
Div5AirportSeqIDAirport Sequence ID of Diverted Airport 5. Unique Key for Time Specific Information for an AirportGet Lookup Table
Div5WheelsOnWheels On Time (local time: hhmm) at Diverted Airport Code5 
Div5TotalGTimeTotal Ground Time Away from Gate at Diverted Airport Code5 
Div5LongestGTimeLongest Ground Time Away from Gate at Diverted Airport Code5 
Div5WheelsOffWheels Off Time (local time: hhmm) at Diverted Airport Code5 
Div5TailNumAircraft Tail Number for Diverted Airport Code5 



BTS's privacy policies and procedures do not necessarily apply to external web sites.
We suggest contacting these sites directly for information on their data collection and distribution policies.