Start-Ups
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 |
---|---|---|---|---|---|
Operator Name | varchar(255) | Operator name | |||
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. | Primary/Foreign | Operators | Operator ch-a Code |
Start-Up Info | varchar(255) | Start-up information free text | |||
IATA | varchar(2) | Operator IATA two-character code | |||
Country | varchar(255) | Country name | |||
Country ISO | char(2) | ISO 3166-1 Alpha-2 country code | Foreign | Countries | Country ISO |
Type | varchar(255) | Description of operator's primary business model (Scheduled Carrier, Virtual Carrier, Division, Cargo Carrier, Business/Private Carrier, Government, Manufacturer, Supplier) | |||
Type Code | char(1) | Operator type code: S - Scheduled Carrier, V - Virtual Carrier, D - Division, C - Cargo Carrier, B - Business/Private Carrier, G - Government, M - Manufacturer, U - Supplier | |||
Website | varchar(255) | Website URL | |||
Planned Start-Up | varchar(255) | Planned start-up quarter (formatted yyyy/qq) | |||
Start-Up added | date | Date the start-up was added to the ch-aviation database | |||
Start-Up last updated | date | Date the start-up status was last updated | |||
Majority government owned | varchar(3) | Indicator if start-up is majority government owned | |||
Investor | varchar(255) | Investor names | |||
known investor in airlines | varchar(3) | Indicator if start-up has investor with an airline experience | |||
known investor in aviation | varchar(3) | Indicator if start-up has investor with aviation experience | |||
Planned fleet size | smallint(5) | Planned fleet size | |||
incorporation number/ VAT number | text | Incorporation number or VAT number | |||
Incorporation_source | text | Source of Incorporation number or VAT number | |||
Application_date_AOC | vachar(10) | AOC application date or month (formatted as YYYY/MM) | |||
AOC application in process? | varchar(3) | Indicator if AOC application is in progress | |||
AOC application source | text | Source of AOC application | |||
AOC number | varchar(255) | AOC number if AOC has been awarded | |||
AOC number source | text | AOC number source | |||
Start up aircraft variants | varchar(255) | Planned aircraft variants (if already known) | |||
Start up aircraft families | varchar(255) | Planned aircraft families (if already known) |