Sample Aviation Data

The Aviation Type/Model/Series Report (ATMSR) Universe contains cost and non-cost elements for Aircraft Type/Model/Series by Fiscal Year. The ATMSR has been improved and split into two separate databases-one that covers 1986 to 1996 and one that covers 1997 to the present. A principal goal of this split is to enable substantially more detail and consistency in the 1997-present database by re-collecting source data for significant a number of ATMSR data elements and by applying consistent processing rules to all data. Based on the availability of raw data, the improvements that were made for the FY2000 ATMSR were applied to the other 1997 to present data years in support of the objective of data detail and consistency.

The FY97-Present ATMSR reports data on 98 distinct T/M/S that can be consolidated into 35 representative Type/Models. Data is reported separately for aircraft assigned to operating squadrons and those assigned to Fleet Replenishment Squadrons (FRS). Any level of data can be analyzed to the Major Claimant level. The Major Claimants reported in the ATMSR are Commander in Chief U.S. Atlantic Fleet (LANFLT), Commander in Chief US Pacific Fleet (PACFLT), Chief of Naval Reserve (RESERVE), and Chief of Naval Education and Training (CNET). Commander in Chief US Naval Forces Europe (CINCUSNAVEUR) is no longer identified as a distinct Major Claimant in the ATMSR, rather costs for aviation operations for aircraft assigned to that command are now included within the LANFLT Major Claimancy. The ATMSR does not report data on aircraft assigned to the Commander Naval Air System Command (NAVAIR) Claimancy. The RTD&E environment in which NAVAIR claimancy aircraft operate would result in operating cost data that would not be consistent with the data from the operating forces.

The ATMSR structure consists of 383 data elements, some of which are roll-up entires of subordinate elements. The specific breakdown of these entries is: 355 cost elements, of which 95 are roll-up entries, and 28 non-cost elements that include 12 roll-up entries. These elements are assembled and reported at distinct levels: Organization Level (1.0 series of cost elements), Intermediate Level (2.0 series), and Depot Level (3.0 series). Additional categories of costs include Training Support (4.0 series), Recurring Investment Costs (5.0 Series), Other Functions (6.0 series), and Contractor Logistics Support (7.0 series). The ATMSR also provides several non-cost metrics against which cost elements can be evaluated (A series). These non-cost metrics include Aircraft Number, Annual Flying Hours, Average Age Year End, Total Flight Hours in Life Year End, and Barrels of Fuel Consumed.

Depot level data (3.0 series) now reports current year costs or current year obligations in all of its component data elements. In past years, the Organic Depot Repair data for aircraft and engines reported the value of cost completions occurring during the Fiscal Year. This change places all depot level repair cost data on the same current year cost category as the other ATMSR cost elements. With this modification of the manner in which Organic Depot Repair is reported, the data elements intended to report the number of units repaired at the depot level is no longer an active element in the ATMSR.

Note that Flying Hour Cost data is contained in Organization Level (1.0 series) report elements for operational aircraft and in Training Support (4.0 series) for Fleet Replacement Squadron (FRS) aircraft. Total costs for a specific T/M/S can be derived through combining its costs from these two data reporting series.

view a sample (MS Excel Document)

Back to Sample Data