Overview: Form41 Reports

U.S. DOT Form 41 data is used to analyze aircraft and employee productivity, operational performance and other significant operational statistics.

The Form 41 Customizer report is used to display a custom set of the Form 41 accounts of your own choosing. You can include any account from Form 41 Schedules B-1, P-6, P-7, P-10, P-12, P-52, T-1, T-2, and also aggregated T-100 figures. The Form 41 Customizer lets you create two different types of reports: if you select a set of accounts, and choose not to build any ratios, the Form 41 Customizer returns a report which joins all of the selected accounts into one output table. On the other hand, if you select a set of accounts and also choose one or more Ratio Denominators, then the Form 41 Customizer returns the joined account table, but in addition, it returns a table for each Ratio Denominator with a row for each account which was selected divided by that Denominator.

Use the report to see figures for a specific quarter or for a series of consecutive quarters in time series or summed together. Results can be filtered into one or more of the Entity regions or an overall System Total can be shown. If accounts with equipment-specific figures are selected then results can also be focused in on a specific equipment type. Otherwise, results are shown for the total for all aircraft flown.

When using this report, on the Main Inputs screen, please enter one or more carriers in the Airline code(s) field and/or select one of the groupings or carriers for which data is available from the choose airline(s) field. Specify a quarter and year and optionally include the number of quarters of data you wish to have summed together or displayed in time series (Annual or Quarterly). You may also choose whether to focus on a particular Entity, and if you have selected accounts with equipment-specific information, then you may choose one particular equipment type to focus on.

Click the "Choose Accounts to Report" button to go to the "Choose Accounts to Report" screen. On this screen, you select the Form 41 accounts this report will include from the menus on the left. Once an account has been selected, a box for that account will show up in the preview pane on the right. If you wish to remove an account from the report's output, simply click on its box in the preview pane, and the account will be removed. You may not re-order accounts in the preview pane. You must select at least one account on this screen in order to run the report.

If you wish to have the Form 41 Customizer create a report which divides the chosen accounts by other Form 41 accounts, then click the "Build Ratios" button to go to the "Build Ratios" screen. On this screen, you can choose up to 5 Ratio Denominator fields from the menus on the left and the report will return a Ratio Table for each chosen Denominator. Click on any field in the preview box to remove that field from the report's output. You do not have to choose any Ratio Denominators. However, when one or more Ratio Denominators is selected, a separate table is displayed for each Ratio Denominator showing the ratio of each Reported Account divided by that Denominator.

Form41 Equipment Reports: 

Statistics (T1, T2, T-100)

The Form 41 Equipment Statistics report displays statistical data such as revenue ton miles, available ton miles, and aircraft hours flown based on the operations of each aircraft equipment type for any of 280 major U.S. carriers. This information comes from the US DOT's Form 41, Schedules T-1, T-2, and aggregated T-100 data. Use the report to see statistics for a specific quarter, for a series of years or quarters, or for consecutive quarters summed together. Results can be filtered into one or more of the Entity regions, or an overall System Total can be shown. Results can also be focused in on a specific equipment type or shown for each unique aircraft equipment type flown along with a total for all aircraft flown (if "-ALL-" is chosen in the Equipment code menu).

When using this report enter one or more carriers in the Airline code(s) field, and/or select one of the groupings or carriers for which data is available from the choose airline(s) field. Specify an initial quarter and year, the number of quarters of data you wish to query, and whether you wish to view results in a quarterly or yearly time series, or summed. Choose one particular equipment type or all equipment types and whether to focus a particular Entity.

Expenses (P52)

The Form 41 Equipment Expenses report displays financial and equipment expenses (reported in thousands of U.S. dollars) based on the operations of each aircraft equipment type for any of 80 major U.S. carriers. This information comes from the US DOT's Form 41, Schedule P-52. Use the report to see expenses for a specific quarter, for a series of years or quarters, or for consecutive quarters summed together. Results can be filtered into one or more of the Entity regions, or an overall System Total can be shown. Results can also be focused in on a specific equipment type or shown for each unique aircraft equipment type flown along with a total for all aircraft flown (if "-ALL-" is chosen in the Equipment code menu).

When you using this report enter one or more carriers in the Airline code(s) field, and/or select one of the groupings or carriers for which data is available from the choose airline(s) field. Specify an initial quarter and year, the number of quarters of data you wish to query, and whether you wish to view results in a quarterly or yearly time series, or summed. Choose one particular equipment type or all equipment types and whether to focus a particular Entity.

Form41 Total Reports:

Summary:

The Form 41 Performance Measurement report displays values for key airline performance criteria such as load factor, yield, RASM, and CASM based on operations for any of 230 major U.S. carriers. Use the report to see performance metrics for a specific quarter, for a series of years or quarters, or for consecutive quarters summed together. Results can be filtered into one or more of the Entity regions, or an overall System Total can be shown.

When using this report enter one or more carriers in the Airline code(s) field, and/or select one of the groupings or carriers for which data is available from the choose airline(s) field. Specify an initial quarter and year, the number of quarters of data you wish to query, and whether you wish to view results in a quarterly or yearly time series, or summed. Also choose whether to focus a particular carrier Entity.

Profit and Loss (P6, P7, P12):

The Form 41 Profit and Loss report displays overall financial results (reported in thousands of U.S. dollars) based on operations for any of 130 major U.S. carriers. This information comes from the US DOT's Form 41, Schedules P-12, P-6, and P-7. Use the report to see profits and losses for a specific quarter, for a series of years or quarters, or for consecutive quarters summed together. Results can be filtered into one or more of the Entity regions, or an overall System Total can be shown. Three different types of reports can be generated: an overall Profit and Loss report based on the P-12 data, and two different cost detail reports based on P-6 or P-7 data, which show all operating expenses in greater detail.

When using this report enter one or more carriers in the Airline code(s) field, and/or select one of the groupings or carriers for which data is available from the choose airline(s) field. Specify an initial quarter and year, the number of quarters of data you wish to query, and whether you wish to view results in a quarterly or yearly time series, or summed. Choose one of the three possible report types to view and whether to focus a particular Entity.

 Balance Sheet (B1):

The Form 41 Balance Sheet report displays a quarterly balance sheet (reported in thousands of U.S. dollars) for any of 130 major U.S. carriers. This information comes from the US DOT's Form 41, Schedule B-1. Use the report to see a balance sheet for a specific quarter, for a series of quarters, or for a multi-quarter average.

When using this report enter one or more carriers in the Airline code(s) field, and/or select one of the groupings or carriers for which data is available from the choose airline(s) field. Specify an initial quarter and year, the number of quarters of data you wish to query, and whether you wish to view results in time series, or averaged together.

Statistics (T2):

The Form 41 Statistics report displays overall statistical data such as revenue ton miles, available ton miles, and aircraft hours flown based on operations for any of 280 major U.S. carriers. This information comes from the US DOT's Form 41, Schedule T-2. Use the report to see statistics for a specific quarter, for a series of years or quarters, or for consecutive quarters summed together. Results can be filtered into one or more of the Entity regions, or an overall System Total can be shown.

When using this report enter one or more carriers in the Airline code(s) field, and/or select one of the groupings or carriers for which data is available from the choose airline(s) field. Specify an initial quarter and year, the number of quarters of data you wish to query, and whether you wish to view results in a quarterly or yearly time series, or summed. Also choose whether to focus a particular carrier Entity.

Airport Traffic Totals (T3):

The Form 41 Airport Traffic Totals report displays information from The US DOT Form 41, Schedule T-3, which shows statistics for each Origin airport served by any of 280 major U.S. Operating Airlines. It reports data including Scheduled Departures [Account 520], Total Departures Performed [Account 510], Total Passengers [Account 110], Total Tons of Freight [Account 217], and Total Tons of Mail [Account 219]. You can view information for All service performed or restrict the report to only display information for Scheduled Service or Non-Scheduled Service. Use the report to see data for a specific quarter, for a series of quarters, or for consecutive quarters summed together.

When using this report enter one or more carriers in the Airline code(s) field, and/or select one of the groupings or carriers for which data is available from the choose airline(s) field. Specify one or more Origin airports, or an origin region, an initial quarter and year, the number of quarters of data you wish to query, and whether you wish to view results in a quarterly time series, or summed. Optionally choose whether to restrict the results to showing only one Service Class.

Annual Employee Stats (P10):

The Form 41 Employee Statistics report displays the number of people employed by any of 90 major U.S. carriers, broken down according to job function. This information comes from the US DOT's Annual Form 41, Schedule P-10 survey. Use the report to see how employment breaks down for a carrier for a specific year, for a series of years, or for consecutive years averaged together. Results can be filtered into one or more of the Entity regions, or an overall System Total can be shown.

When using this report enter one or more carriers in the Airline code(s) field, and/or select one of the groupings or carriers for which data is available from the choose airline(s) field. Specify an initial year, the number of years of data you wish to query, and whether you wish to view results in a yearly time series or averaged. You may also choose to focus on a particular Entity, or view each entity together or combined.