Fleets Summary
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.
To access the full sample data set on Snowflake, visit the ch-aviation profile on Snowflake Marketplace here.
| Sample File Name | Sample Description |
|---|---|
| fleets_summary_bizjets.csv | Subset for business jets |
| fleets_summary_comav.csv | Subset for commercial aviation |
| fleets_summary.csv | Sample data for commercial aviation and business jets |
| Column | Data Type | Data description | Package required | Key | Data Set | Join On |
|---|---|---|---|---|---|---|
| Operator Name | varchar(255) | Operator name | Fleets Summary | |||
| Operator ch-a Code | varchar(5) | Operator ch-aviation code (assigned by ch-aviation). Operator ch-aviation codes can be 2, 3, or 5 characters. | Fleets Summary | Foreign | Operators | Operator ch-a Code |
| Aircraft Variant | varchar(255) | Aircraft Variant designation (i.e. A321-200N) | Fleets Summary | Foreign | Aircraft Variants | variant_text |
| Active | decimal(10,0) | Number of active aircraft | Fleets Summary | |||
| Inactive | decimal(10,0) | Number of inactive aircraft | Fleets Summary | |||
| Wet-leased In | decimal(10,0) | Number of wet-leased in aircraft | Fleets Summary | |||
| Total | decimal(10,0) | Number of total aircraft | Fleets Summary | |||
| To be delivered | decimal(10,0) | Number of to be delivered aircraft | Fleets Summary |