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.

Airframe MRO Providers and Customers - ch-aviation

Airframe MRO Providers and Customers

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	Package required	Key	Data Set	Join On
Airframe MRO Name	varchar(255)	Name of the MRO provider	Commercial Aviation Airframe MRO Data
Airframe MRO ch-a Code	varchar(5)	MRO provider ch-aviation code (2-5 characters)	Commercial Aviation Airframe MRO Data	Foreign	Entities	Entity ch-a Code
Legal Name	varchar(255)	MRO Provider legal name	Commercial Aviation Airframe MRO Data
Base Location	varchar(255)	Airport Display Name (combination of City Name and Airport Name)	Commercial Aviation Airframe MRO Data
Base Location ch-a Code	varchar(6)	Airport ch-aviation code (not a stable ID, IATA code if available, otherwise ICAO, otherwise alternative code)	Commercial Aviation Airframe MRO Data	Foreign	Airports	Airport ch-a Code
Base Location IATA	char(3)	Airport three character IATA code	Commercial Aviation Airframe MRO Data
Base Location ICAO	char(4)	Airport four character ICAO code	Commercial Aviation Airframe MRO Data
Base Continent	varchar(255)	Continent name	Commercial Aviation Airframe MRO Data
Base Subdivision	varchar(255)	State name	Commercial Aviation Airframe MRO Data
Base Subdivision ch-a Code	varchar(255)	ISO 3166-2 Alpha-2 subdivision code (used for states)	Commercial Aviation Airframe MRO Data	Foreign	States	State ISO
Base Metro Group	varchar(255)	Metro Group name	Commercial Aviation Airframe MRO Data
Base Metro Group IATA	char(3)	Metro Group three character IATA code	Commercial Aviation Airframe MRO Data	Foreign	Metro Groups	Metro_Group
Base Country	varchar(255)	Country name	Commercial Aviation Airframe MRO Data
Base Country ISO	char(2)	ISO 3166-1 Alpha-2 country code	Commercial Aviation Airframe MRO Data	Foreign	Countries	Country ISO
Maintenance Type	varchar(255)	Type of the MRO event (Base, Completion, Conversion, Delivery, Induction, Lease Return, Line + A, Modifications, Paint, Part-Out, Production, Repairs, Storage, Transition)	Commercial Aviation Airframe MRO Data
Operator Customer	varchar(255)	Operator customer name	Commercial Aviation Airframe MRO Data
Operator Customer ch-a Code	varchar(255)	Operator customer ch-aviation code (assigned by ch-aviation). Operator ch-aviation codes can be 2, 3, or 5 characters.	Commercial Aviation Airframe MRO Data	Foreign	Operators	Operator ch-a Code
Status	varchar(255)	MRO provider status	Commercial Aviation Airframe MRO Data
Website	varchar(255)	Website URL	Commercial Aviation Airframe MRO Data
Stock Ticker	varchar(255)	Stock market ticker URL	Commercial Aviation Airframe MRO Data
Launch Year	int(4)	Year the MRO provider was launched	Commercial Aviation Airframe MRO Data
Termination Year	int(4)	Year the MRO provider stopped operations	Commercial Aviation Airframe MRO Data