Aircraft Utilisation – Daily (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 | |||
Date | date | date (YYYY-MM-DD) | |||
cycles | int(8) | number of daily cycles | |||
hours | decimal(23,2) | number of daily hours (hhh.hh) | |||
avg stage length | char(5) | average daily stage length in hours and minutes (hh:mm) | |||
utilisation_data_type | varchar(255) | type of utilisation data | |||
As of | date | As of date (date when utilisation data was last provided) (YYYY-MM-DD) | |||
Source | varchar(255) | Source of utilisation data | |||
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 day: 0 = takeoff and/or landing missing; 1 = both takeoff and landing are present; values in between reflect partial data completeness. |