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
: Schedule P-7
   Database Profile   Data Tables   Table Profile
Latest Available Data: September 2023All Rows Shown
Field NameDescription
Direct Operating Expense - Aircraft Operating Expense
AirOpExpense00020 - Total Aircraft Operating Expense (Direct Operating Expense) (000)Analysis
Indirect Operating Expense - Passenger Service Expense
FlAttExpense00050 - Flight Attendant (000)Analysis
FoodExpense00060 - Food (000)Analysis
OthInFlExpense00070 - Other Inflight (000)Analysis
PaxSvcExpense00080 - Total Passenger Service Expense (000)Analysis
Indirect Operating Expense - Aircraft Servicing Expense
LineSvcExpense00100 - Line Servicing (000)Analysis
ControlExpense00110 - Control (000)Analysis
LandingFees00120 - Landing Fees (000)Analysis
AirSvcExpense00130 - Total Aircraft Servicing Expense (000)Analysis
Indirect Operating Expense - Traffic Servicing Expense
TrafficExpPax00150 - Directly Assignable To Passenger (000)Analysis
TrafficExpCargo00160 - Directly Assignable To Baggage And Cargo (000)Analysis
TrafficExpOth00170 - Not Directly Assignable (000)Analysis
TrafficExpense00180 - Total Traffic Servicing Expense (000)Analysis
Indirect Operating Expense - Reservation And Sales Expense
ResExpPax00200 - Directly Assignable To Passenger (000)Analysis
ResExpCargo00210 - Directly Assignable To Cargo (000)Analysis
ResExpOth00220 - Not Directly Assignable (000)Analysis
ResExpense00230 - Total Reservation And Sales Expense (000)Analysis
Indirect Operating Expense - Advertising And Publicity Expense
AdExpPax00250 - Directly Assignable To Passenger (000)Analysis
AdExpCargo00260 - Directly Assignable To Cargo (000)Analysis
AdExpInst00270 - Institutional Advertising (000)Analysis
AdExpense00280 - Total Advertising And Publicity Expense (000)Analysis
Indirect Operating Expense - General And Administrative Expense
AdminExpense00290 - General And Administrative Expense (000)Analysis
Indirect Operating Expense - Depreciation Expense - Maintenance Equipment
DeprExpMaint00340 - Depreciation Expense - Maintenance Equipment (000)Analysis
Indirect Operating Expense - Amortization - Other Than Flight Equipment
Amortization00350 - Amortization (Other Than Flight Equipment) (000)Analysis
Transport Related Expense
TransportExp00370 - Transport Related Expense (000)Analysis
Total Operating Expense
TotalOpExpense00380 - Total Operating Expense (000)Analysis
Other
MaintPropEquip00310 - Maintenance-Ground Property And Equipment (000)Analysis
DeprPropEquip00320 - Depreciation-Ground Property And Equipment (000)Analysis
MaintDepr00330 - Total Maintenance And Depreciation - Ground (000)Analysis
SvcSalesOpExp00360 - Total Servicing, Sales And General Operating Expenses (000)Analysis
Carrier Information
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
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
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). 
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 
UniqCarrierEntityUnique Entity for a Carrier's Operation Region.Analysis
CarrierRegionCarrier's Operation Region. Carriers Report Data by Operation RegionAnalysis
CarrierGroupNewCarrier Group NewAnalysis
CarrierGroupCarrier Group Code. Used in Legacy AnalysisAnalysis
Time Period Information
YearYear 
QuarterQuarter (1-4)Analysis
All Rows Shown