Models · 27

As the data sheet lists them, with the names they’re known by.

Query with SQL

duckdb -csv -c "SELECT position, model, unofficial_name, former_holder, model_comment
  FROM 'https://openairdocs.org/data/latest/faa_type_certificate_model.parquet'
  WHERE tcds_number = 'E2WE'
  ORDER BY position"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

SELECT position, model, unofficial_name, former_holder, model_comment
FROM 'https://openairdocs.org/data/latest/faa_type_certificate_model.parquet'
WHERE tcds_number = 'E2WE'
ORDER BY position

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

Model	Also known as	Note
TPE331-25DB		Formerly Garrett, then AiResearch, then AlliedSignal
TPE331-57-B		Formerly Garrett, then AiResearch, then AlliedSignal
TPE331-43		Formerly Garrett, then AiResearch, then AlliedSignal
TPE331-25FA		Formerly Garrett, then AiResearch, then AlliedSignal
TPE331-61-A		Formerly Garrett, then AiResearch, then AlliedSignal
TPE331-47		Formerly Garrett, then AiResearch, then AlliedSignal
TPE331-55		Formerly Garrett, then AiResearch, then AlliedSignal
TPE331-51		Formerly Garrett, then AiResearch, then AlliedSignal
TPE331-25F		Formerly Garrett, then AiResearch, then AlliedSignal
TPE331-47-B		Formerly Garrett, then AiResearch, then AlliedSignal
TPE331-43-A		Formerly Garrett, then AiResearch, then AlliedSignal
TPE331-43-B		Formerly Garrett, then AiResearch, then AlliedSignal
TPE331-45		Formerly Garrett, then AiResearch
TPE331-25AA		Formerly Garrett, then AiResearch, then AlliedSignal
TPE331-25B		Formerly Garrett, then AiResearch, then AlliedSignal
TPE331-25AB		Formerly Garrett, then AiResearch, then AlliedSignal
TPE331-55-B		Formerly Garrett, then AiResearch, then AlliedSignal
TPE331-29A		Formerly Garrett, then AiResearch, then AlliedSignal
TPE331-57		Formerly Garrett, then AiResearch, then AlliedSignal
TPE331-55-A		Formerly Garrett, then AiResearch, then AlliedSignal
TPE331-47-A		Formerly Garrett, then AiResearch, then AlliedSignal
TPE331-25C		Formerly Garrett, then AiResearch, then AlliedSignal
TPE331-25E		Formerly Garrett, then AiResearch, then AlliedSignal
TPE331-25DA		Formerly Garrett, then AiResearch, then AlliedSignal
TPE331-25D		Formerly Garrett, then AiResearch, then AlliedSignal
TPE331-61		Formerly Garrett, then AiResearch, then AlliedSignal
TPE331-25A		Formerly Garrett, then AiResearch, then AlliedSignal

Back to TCDS E2WE