Models · 21

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 = '3A16'
  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 = '3A16'
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
95		Formerly Beech Aircraft Corporation, then Raytheon Aircraft Company · Travel Air
95-B55		Formerly Beech Aircraft Corporation, then Raytheon Aircraft Company · Baron
95-C55A		Formerly Beech Aircraft Corporation, then Raytheon Aircraft Company · Baron
D55		Formerly Beech Aircraft Corporation, then Raytheon Aircraft Company · Baron
58		Formerly Beech Aircraft Corporation, then Raytheon Aircraft Company · Baron
95-A55		Formerly Beech Aircraft Corporation, then Raytheon Aircraft Company · Baron
D55A		Formerly Beech Aircraft Corporation, then Raytheon Aircraft Company · Baron
95-C55		Formerly Beech Aircraft Corporation, then Raytheon Aircraft Company · Baron
A56TC		Formerly Beech Aircraft Corporation, then Raytheon Aircraft Company · Turbo Baron
G58		Formerly Raytheon Aircraft Company, then Hawker Beechcraft Corporation
E95		Formerly Beech Aircraft Corporation, then Raytheon Aircraft Company · Travel Air
E55		Formerly Beech Aircraft Corporation, then Raytheon Aircraft Company · Baron
95-55		Formerly Beech Aircraft Corporation, then Raytheon Aircraft Company · Baron
58A		Formerly Beech Aircraft Corporation, then Raytheon Aircraft Company · Baron
D95A		Formerly Beech Aircraft Corporation, then Raytheon Aircraft Company · Travel Air
E55A		Formerly Beech Aircraft Corporation, then Raytheon Aircraft Company · Baron
95-B55B		Formerly Beech Aircraft Corporation, then Raytheon Aircraft Company · Baron (Military T-42A)
95-B55A		Formerly Beech Aircraft Corporation, then Raytheon Aircraft Company · Baron
B95		Formerly Beech Aircraft Corporation, then Raytheon Aircraft Company · Travel Air
56TC		Formerly Beech Aircraft Corporation, then Raytheon Aircraft Company · Turbo Baron
B95A		Formerly Beech Aircraft Corporation, then Raytheon Aircraft Company · Travel Air

Back to TCDS 3A16