Do you also provide an API?

ch-aviation can provide the data feeds to you directly via file transfer protocol (FTP), safe file transfer protocol (SFTP) or a shared Amazon Web Services (AWS) S3 bucket.

Which delivery formats you support?

The data is provided as Comma-separated values (.csv) flat files. Optionally we can provide them as Microsoft Excel (.xlsx) or XML (.xml)

How often does data get updated?

The ch-aviation database is updated in batches to ensure all data flows through ch-aviation’s semi-automated quality assurance process built to maximise data integrity. As a result, the data set remains relatively static in the ch-aviation production database, for most data sets for a week or month at a time. Therefore, the most efficient integration option is the transfer of flat files provided for integration into your own applications in various formats.

Start-Ups - ch-aviation

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)