RITA | BTS | Transtats

Field Name	Description	% Missing	Support Table
Time Period
Year	Year	<0.005
Quarter	Quarter (1-4)	<0.005	Get Lookup Table
Month	Month	<0.005	Get Lookup Table
DayofMonth	Day of Month	<0.005
DayOfWeek	Day of Week	<0.005	Get Lookup Table
FlightDate	Flight Date (yyyymmdd)	<0.005
Airline
UniqueCarrier	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.	<0.005	Get Lookup Table
AirlineID	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.	<0.005	Get Lookup Table
Carrier	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.	<0.005	Get Lookup Table
TailNum	Tail Number	29.21
FlightNum	Flight Number	<0.005
Origin
Origin	Origin Airport	<0.005	Get Lookup Table
OriginCityName	Origin Airport, City Name	<0.005
OriginState	Origin Airport, State Code	<0.005	Get Lookup Table
OriginStateFips	Origin Airport, State Fips	<0.005	Get Lookup Table
OriginStateName	Origin Airport, State Name	<0.005
OriginWac	Origin Airport, World Area Code	<0.005	Get Lookup Table
Destination
Dest	Destination Airport	<0.005	Get Lookup Table
DestCityName	Destination Airport, City Name	<0.005
DestState	Destination Airport, State Code	<0.005	Get Lookup Table
DestStateFips	Destination Airport, State Fips	<0.005	Get Lookup Table
DestStateName	Destination Airport, State Name	<0.005
DestWac	Destination Airport, World Area Code	<0.005	Get Lookup Table
Departure Performance
CRSDepTime	CRS Departure Time (local time: hhmm)	<0.005
DepTime	Actual Departure Time (local time: hhmm)	1.83
DepDelay	Difference in minutes between scheduled and actual departure time. Early departures show negative numbers.	1.83
DepDelayMinutes	Difference in minutes between scheduled and actual departure time. Early departures set to 0.	1.83
DepDel15	Departure Delay Indicator, 15 Minutes or More (1=Yes)	1.83	Get Lookup Table
DepartureDelayGroups	Departure Delay intervals, every (15 minutes from <-15 to >180)	1.83	Get Lookup Table
DepTimeBlk	CRS Departure Time Block, Hourly Intervals	<0.005	Get Lookup Table
TaxiOut	Taxi Out Time, in Minutes	30.28
WheelsOff	Wheels Off Time (local time: hhmm)	30.28
Arrival Performance
WheelsOn	Wheels On Time (local time: hhmm)	30.44
TaxiIn	Taxi In Time, in Minutes	30.43
CRSArrTime	CRS Arrival Time (local time: hhmm)	<0.005
ArrTime	Actual Arrival Time (local time: hhmm)	2.06
ArrDelay	Difference in minutes between scheduled and actual arrival time. Early arrivals show negative numbers.	2.07
ArrDelayMinutes	Difference in minutes between scheduled and actual arrival time. Early arrivals set to 0.	2.07
ArrDel15	Arrival Delay Indicator, 15 Minutes or More (1=Yes)	2.07	Get Lookup Table
ArrivalDelayGroups	Arrival Delay intervals, every (15-minutes from <-15 to >180)	2.07	Get Lookup Table
ArrTimeBlk	CRS Arrival Time Block, Hourly Intervals	<0.005	Get Lookup Table
Cancellations and Diversions
Cancelled	Cancelled Flight Indicator (1=Yes)	<0.005	Get Lookup Table
CancellationCode	Specifies The Reason For Cancellation	99.37	Get Lookup Table
Diverted	Diverted Flight Indicator (1=Yes)	<0.005	Get Lookup Table
Flight Summaries
CRSElapsedTime	CRS Elapsed Time of Flight, in Minutes	<0.005
ActualElapsedTime	Elapsed Time of Flight, in Minutes	2.07
AirTime	Flight Time, in Minutes	30.44
Flights	Number of Flights	<0.005
Distance	Distance between airports (miles)	<0.005
DistanceGroup	Distance Intervals, every 250 Miles, for Flight Segment	<0.005	Get Lookup Table
Cause of Delay (Data starts 6/2003)
CarrierDelay	Carrier Delay, in Minutes	92.61
WeatherDelay	Weather Delay, in Minutes	92.61
NASDelay	NAS Delay, in Minutes	92.61
SecurityDelay	Security Delay, in Minutes	92.61
LateAircraftDelay	Late Aircraft Delay, in Minutes	92.61
Gate Return Information at Origin Airport (Data starts 10/2008)
FirstDepTime	First Gate Departure Time at Origin Airport	>99.99
TotalAddGTime	Total Ground Time Away from Gate for Gate Return or Cancelled Flight	>99.99
LongestAddGTime	Longest Time Away from Gate for Gate Return or Cancelled Flight	>99.99
Diverted Airport Information (Data starts 10/2008)
DivAirportLandings	Number of Diverted Airport Landings	94.17	Get Lookup Table
DivReachedDest	Diverted Flight Reaching Scheduled Destination Indicator (1=Yes)	>99.99	Get Lookup Table
DivActualElapsedTime	Elapsed Time of Diverted Flight Reaching Scheduled Destination, in Minutes. The ActualElapsedTime column remains NULL for all diverted flights.	>99.99
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.	>99.99
DivDistance	Distance between scheduled destination and final diverted airport (miles). Value will be 0 for diverted flight reaching scheduled destination.	>99.99
Div1Airport	Diverted Airport Code1	>99.99
Div1WheelsOn	Wheels On Time (local time: hhmm) at Diverted Airport Code1	>99.99
Div1TotalGTime	Total Ground Time Away from Gate at Diverted Airport Code1	>99.99
Div1LongestGTime	Longest Ground Time Away from Gate at Diverted Airport Code1	>99.99
Div1WheelsOff	Wheels Off Time (local time: hhmm) at Diverted Airport Code1	>99.99
Div1TailNum	Aircraft Tail Number for Diverted Airport Code1	>99.99
Div2Airport	Diverted Airport Code2	>99.99
Div2WheelsOn	Wheels On Time (local time: hhmm) at Diverted Airport Code2	>99.99
Div2TotalGTime	Total Ground Time Away from Gate at Diverted Airport Code2	>99.99
Div2LongestGTime	Longest Ground Time Away from Gate at Diverted Airport Code2	>99.99
Div2WheelsOff	Wheels Off Time (local time: hhmm) at Diverted Airport Code2	>99.99
Div2TailNum	Aircraft Tail Number for Diverted Airport Code2	>99.99
Div3Airport	Diverted Airport Code3	>99.99
Div3WheelsOn	Wheels On Time (local time: hhmm) at Diverted Airport Code3	>99.99
Div3TotalGTime	Total Ground Time Away from Gate at Diverted Airport Code3	>99.99
Div3LongestGTime	Longest Ground Time Away from Gate at Diverted Airport Code3	>99.99
Div3WheelsOff	Wheels Off Time (local time: hhmm) at Diverted Airport Code3	>99.99
Div3TailNum	Aircraft Tail Number for Diverted Airport Code3	>99.99
Div4Airport	Diverted Airport Code4	>99.99
Div4WheelsOn	Wheels On Time (local time: hhmm) at Diverted Airport Code4	>99.99
Div4TotalGTime	Total Ground Time Away from Gate at Diverted Airport Code4	>99.99
Div4LongestGTime	Longest Ground Time Away from Gate at Diverted Airport Code4	>99.99
Div4WheelsOff	Wheels Off Time (local time: hhmm) at Diverted Airport Code4	>99.99
Div4TailNum	Aircraft Tail Number for Diverted Airport Code4	>99.99
Div5Airport	Diverted Airport Code5	>99.99
Div5WheelsOn	Wheels On Time (local time: hhmm) at Diverted Airport Code5	>99.99
Div5TotalGTime	Total Ground Time Away from Gate at Diverted Airport Code5	>99.99
Div5LongestGTime	Longest Ground Time Away from Gate at Diverted Airport Code5	>99.99
Div5WheelsOff	Wheels Off Time (local time: hhmm) at Diverted Airport Code5	>99.99
Div5TailNum	Aircraft Tail Number for Diverted Airport Code5	>99.99