transtats logo
 
Advanced Search
Resources
Data Tools
Air Carriers : T-100 Domestic Segment (U.S. Carriers)
   Data Tables   Table Contents
Download Instructions  
Latest Available Data: September 2014
Select all fields   % Missing in table Documentation Terms
Field Name  Description  Support Table 
Summaries
DepScheduledDepartures Scheduled 
DepPerformedDepartures Performed 
PayloadAvailable Payload (pounds) 
SeatsAvailable Seats 
PassengersNon-Stop Segment Passengers Transported 
FreightNon-Stop Segment Freight Transported (pounds) 
MailNon-Stop Segment Mail Transported (pounds) 
DistanceDistance between airports (miles) 
RampTimeRamp to Ramp Time (minutes) 
AirTimeAirborne Time (minutes) 
Carrier
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
UniqueCarrierNameUnique Carrier Name. When the same name has been used by multiple carriers, a numeric suffix is used for earlier users, for example, Air Caribbean, Air Caribbean (1). 
UniqCarrierEntityUnique Entity for a Carrier's Operation Region.Get Lookup Table
CarrierRegionCarrier's Operation Region. Carriers Report Data by Operation RegionGet 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
CarrierNameCarrier Name 
CarrierGroupCarrier Group Code. Used in Legacy AnalysisGet Lookup Table
CarrierGroupNewCarrier Group NewGet Lookup Table
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 City 
OriginStateOrigin State CodeGet Lookup Table
OriginStateFipsOrigin State FIPS (U.S. Federal Information Processing Standard Codes)Get 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 City 
DestStateDestination State CodeGet Lookup Table
DestStateFipsDestination State FIPS (U.S. Federal Information Processing Standard Codes)Get Lookup Table
DestStateNameDestination Airport, State Name 
DestWacDestination Airport, World Area CodeGet Lookup Table
Aircraft
AircraftGroupAircraft GroupGet Lookup Table
AircraftTypeAircraft TypeGet Lookup Table
AircraftConfigAircraft ConfigurationGet Lookup Table
Time Period
YearYear 
QuarterQuarterGet Lookup Table
MonthMonthGet Lookup Table
Other
DistanceGroupDistance Intervals, every 500 Miles, for Flight SegmentGet Lookup Table
ClassService ClassGet Lookup Table