Query with SQL
duckdb -csv -c "SELECT tcds_number, make, model FROM 'https://openairdocs.org/data/latest/faa_stc_model.parquet' WHERE stc_number = 'SA02360AK' ORDER BY make, model"
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 tcds_number, make, model FROM 'https://openairdocs.org/data/latest/faa_stc_model.parquet' WHERE stc_number = 'SA02360AK' ORDER BY make, model
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.
| Make | Model | Data sheet |
|---|---|---|
| Aviat Aircraft Inc | A-1 | A22NM |
| Aviat Aircraft Inc | A-1A | A22NM |
| Aviat Aircraft Inc | A-1B | A22NM |
| Aviat Aircraft Inc | A-1C-180 | A22NM |
| Aviat Aircraft Inc | A-1C-200 | A22NM |
| Cessna Aircraft Company | 170 | A-799 |
| Cessna Aircraft Company | 170A | A-799 |
| Cessna Aircraft Company | 170B | A-799 |
| Cessna Aircraft Company | 180 | 5A6 |
| Cessna Aircraft Company | 180A | 5A6 |
| Cessna Aircraft Company | 180B | 5A6 |
| Cessna Aircraft Company | 180C | 5A6 |
| Cessna Aircraft Company | 180D | 5A6 |
| Cessna Aircraft Company | 180E | 5A6 |
| Cessna Aircraft Company | 180F | 5A6 |
| Cessna Aircraft Company | 180G | 5A6 |
| Cessna Aircraft Company | 180H | 5A6 |
| Cessna Aircraft Company | 180J | 5A6 |
| Cessna Aircraft Company | 180K | 5A6 |
| Cub Crafters Inc. | CC18-180 | A00006SE |
| Cub Crafters Inc. | CC18-180A | A00006SE |
| FS 2003 Corp. | PA-12 | A-780 |
| Piper Aircraft Inc. | PA-18-125 (Army L-21A) | 1A2 |
| Piper Aircraft Inc. | PA-18-135 | 1A2 |
| Piper Aircraft Inc. | PA-18-150 | 1A2 |
| Piper Aircraft Inc. | PA-18A-135 | 1A2 |
| Piper Aircraft Inc. | PA-18A-150 | 1A2 |
| Super 18 LLC | Super 18 | A00003AK |