USA Banner

Official US Government Icon

Official websites use .gov
A .gov website belongs to an official government organization in the United States.

Secure Site Icon

Secure .gov websites use HTTPS
A lock ( ) or https:// means you’ve safely connected to the .gov website. Share sensitive information only on official, secure websites.

Site Notification

Site Notification

U.S. Department of TransportationU.S. Department of Transportation IconUnited States Department of TransportationUnited States Department of Transportation
BTS> TranStats
transtats logo
 
Advanced Search
Resources
Data Tools
: T-100 Segment (US Carriers Only)
   Database Profile   Data Tables   Table Profile
Latest Available Data: December 2023All Rows Shown
Field NameDescription
Summaries
DepScheduledDepartures ScheduledAnalysis
DepPerformedDepartures PerformedAnalysis
PayloadPayload, in PoundsAnalysis
SeatsAvailable SeatsAnalysis
PassengersNon-Stop Segment Passengers TransportedAnalysis
FreightNon-Stop Segment Freight Transported (pounds)Analysis
MailNon-Stop Segment Mail Transported (pounds)Analysis
DistanceDistance between airports (miles) 
*LoadFactorLoad Factor: Ratio of Passenger Miles to Available Seat MilesAnalysis
RampToRampRamp-to-Ramp Time, in MinutesAnalysis
AirTimeAir Time, in MinutesAnalysis
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.Analysis
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.Analysis
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.Analysis
CarrierRegionCarrier's Operation Region. Carriers Report Data by Operation RegionAnalysis
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. 
CarrierNameCarrier Name 
CarrierGroupCarrier Group Code. Used in Legacy AnalysisAnalysis
CarrierGroupNewCarrier Group NewAnalysis
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.Analysis
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. 
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.Analysis
OriginOrigin Airport CodeAnalysis
OriginCityNameOrigin Airport, City Name 
OriginStateOrigin Airport, StateAnalysis
OriginStateFipsOrigin Airport, State FIPS Code (U.S. Federal Information Processing Standard Codes)Analysis
OriginStateNameOrigin Airport, State Name 
OriginCountryOrigin Airport, CountryAnalysis
OriginCountryNameOrigin Airport, Country Name 
OriginWacOrigin Airport, World Area CodeAnalysis
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.Analysis
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. 
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.Analysis
DestDestination Airport CodeAnalysis
DestCityNameDest Airport, City Name 
DestStateDestination Airport, StateAnalysis
DestStateFipsDestination Airport, State FIPS Code (U.S. Federal Information Processing Standard Codes)Analysis
DestStateNameDestination Airport, State Name 
DestCountryDestination Airport, CountryAnalysis
DestCountryNameDestination Airport, Country Name 
DestWacDestination Airport, World Area CodeAnalysis
Aircraft
AircraftGroupAircraft GroupAnalysis
AircraftTypeAircraft TypeAnalysis
AircraftConfigAircraft ConfigurationAnalysis
Time Period
YearYear 
QuarterQuarter (1-4)Analysis
MonthMonthAnalysis
Other
DistanceGroupDistance Intervals, every 500 Miles, for Flight SegmentAnalysis
ClassService ClassAnalysis
DataSourceSource of Data (D=Domestic ,I=International)Analysis
All Rows Shown