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 = '3A20' 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 = '3A20' 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 |
|---|---|---|
| B90 | Formerly Beech Aircraft Corporation, then Raytheon Aircraft Company, then Hawker Beechcraft Corporation · King Air | |
| 65-A80-8800 | Formerly Beech Aircraft Corporation, then Raytheon Aircraft Company, then Hawker Beechcraft Corporation | |
| 65-A90-2 | (RU-21B) | Formerly Beech Aircraft Corporation, then Raytheon Aircraft Company, then Hawker Beechcraft Corporation |
| 65-A90-1 | (JU-21A,) (U-21A) (RU-21A) (RU-21D) (U-21G) (RU-21H) | Formerly Beech Aircraft Corporation, then Raytheon Aircraft Company, then Hawker Beechcraft Corporation |
| 65-B80 | Formerly Beech Aircraft Corporation, then Raytheon Aircraft Company, then Hawker Beechcraft Corporation · Queen Air | |
| 65-A80 | Formerly Beech Aircraft Corporation, then Raytheon Aircraft Company, then Hawker Beechcraft Corporation | |
| 65-A90-3 | (RU-21C) | Formerly Beech Aircraft Corporation, then Raytheon Aircraft Company, then Hawker Beechcraft Corporation |
| 65 | (L-23F) | Formerly Beech Aircraft Corporation, then Raytheon Aircraft Company, then Hawker Beechcraft Corporation · Queen Air |
| A65-8200 | Formerly Beech Aircraft Corporation, then Raytheon Aircraft Company, then Hawker Beechcraft Corporation · Model 70 | |
| E90 | Formerly Beech Aircraft Corporation, then Raytheon Aircraft Company, then Hawker Beechcraft Corporation · King Air | |
| 65-88 | Formerly Beech Aircraft Corporation, then Raytheon Aircraft Company, then Hawker Beechcraft Corporation | |
| 70 | Formerly Beech Aircraft Corporation, then Raytheon Aircraft Company, then Hawker Beechcraft Corporation · Queen Air | |
| 65-A90 | Formerly Beech Aircraft Corporation, then Raytheon Aircraft Company, then Hawker Beechcraft Corporation · King Air | |
| C90A | Formerly Beech Aircraft Corporation, then Raytheon Aircraft Company, then Hawker Beechcraft Corporation · King Air Note: Raytheon states that the Model C90B should be listed as Model C90A because the model number C90B was only used as a designation on certain airplanes for marketing purposes. There are not actually any Raytheon airplanes with the model number C90B. | |
| C90GTi | Formerly Hawker Beechcraft Corporation, then Beechcraft Corporation | |
| H90 | (T-44A) | Formerly Beech Aircraft Corporation, then Raytheon Aircraft Company, then Hawker Beechcraft Corporation · King Air |
| C90GT | Formerly Raytheon Aircraft Company, then Hawker Beechcraft Corporation | |
| 65-A90-4 | (RU-21E, RU-21H) | Formerly Beech Aircraft Corporation, then Raytheon Aircraft Company, then Hawker Beechcraft Corporation |
| 65-90 | Formerly Beech Aircraft Corporation, then Raytheon Aircraft Company, then Hawker Beechcraft Corporation | |
| C90 | Formerly Beech Aircraft Corporation, then Raytheon Aircraft Company, then Hawker Beechcraft Corporation · King Air | |
| 65-80 | Formerly Beech Aircraft Corporation, then Raytheon Aircraft Company | |
| A65 | Formerly Beech Aircraft Corporation, then Raytheon Aircraft Company, then Hawker Beechcraft Corporation · Queen Air |