Aircraft Utilisation – Monthly (OEM/ADS-B based)
To access the full sample data set on Amazon Web Services manually or programmatically, the S3 bucket URLs are provided here.
To get user name and password for manual access or access key and secret key for programmatic access, contact sales@ch-aviation.com.
Column | Data Type | Data description | Key | Data Set | Join On |
---|---|---|---|---|---|
Natural ID | varchar(30) | Natural aircraft ID (combination of the ch-aviation production line code and either the line/construction or manufacturer serial number, changes for aircraft not yet delivered where l/n, c/n or msn are not yet known (assigned by ch-aviation) | Foreign | Aircraft | Natural ID |
Aircraft ID | int(11) | Unique ch-aviation created aircraft ID, remains stable throughout an aircraft’s life (assigned by ch-aviation) | Foreign | Aircraft | Aircraft ID |
Operator | varchar(255) | Operator name | |||
Opr. ch-a Code | varchar(5) | Operator ch-aviation code (assigned by ch-aviation). Operator ch-aviation codes can be 2, 3, or 5 characters. | Foreign | Operators | Operator ch-a Code |
Variant | varchar(255) | Aircraft Variant designation (i.e. A321-200N) | Foreign | Aircraft Variants | variant_text |
CN | varchar(16) | Construction/Line Number | |||
MSN | varchar(16) | Manufacturer Serial Number | |||
Registration | varchar(16) | Aircraft Registration, blank if unknown or no longer registered | |||
Month | month | Month of the hours and cycles | |||
Year | year | Year of the hours and cycles | |||
cycles | decimal(10,0) | number of monthly cycles | |||
hours | decimal(10,2) | number of monthly hours (hhh.hh) | |||
avg stage length | char(5) | average monthly stage length in hours and minutes (hh:mm) | |||
avg_daily_utilisation | char(5) | average daily utilisation in hours and minutes (hh:mm) | |||
utilisation_data_type | varchar(255) | indication whether the data is: actual historical data, estimated data, forecasted data or ADS-B data | |||
TTM cycles | int(11) | Trailing twelve months cycles | |||
TTM hours | decimal(10,2) | Trailing twelve months hours | |||
TTM avg stage length | char(5) | Trailing twelve months average stage length (hh:mm) | |||
TTM avg daily utilisation | char(5) | Trailing twelve months average daily utilisation (hh:mm) | |||
since eis cycles | int(11) | Cycles since entry into service | |||
since eis hours | decimal(10,2) | Hours since entry into service | |||
since eis avg stage length | char(5) | Avg. stage length since entry into service (hh:mm) | |||
since eis avg daily utilisation | char(5) | Avg. daily utilisation since entry into service (hh:mm) | |||
as of | date | As of date (date when utilisation data was last provided) | |||
source | varchar(255) | Source of utilisation data | |||
source ch code | varchar(3) | Operator or Manufacturer ch-aviation code (assigned by ch-aviation) | |||
data quality indicator | varchar(16) | An aircraft is whitelisted for an operator/MSN combination if it meets one of the following: Utilization Match: Spire ADS-B based cycles closely align with OEM data (within ±1–2 cycles or ±10%, depending on sample size) in the past two years. Flight Path Continuity: At least 95% of previous destinations match the next origin, with 10+ flights tracked in the past two years. Otherwise, it is blacklisted | |||
data quality index | decimal(3,2) | A score from 0 to 1 indicating completeness of flight tracking for the month: 0 = takeoff and/or landing missing; 1 = both takeoff and landing are present; values in between reflect partial data completeness. |