Query with SQL
duckdb -csv -c "SELECT tcds_number, make, model FROM 'https://openairdocs.org/data/latest/faa_stc_model.parquet' WHERE stc_number = 'SA2350NM' 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 = 'SA2350NM' 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 |
|---|---|---|
| Scotts-Bell 47 Inc | 47G-3B-2 | 2H3 |
| Scotts-Bell 47 Inc | 47G-3B-2A | 2H3 |
| Scotts-Bell 47 Inc | 47G-4 | 2H3 |
| Scotts-Bell 47 Inc | 47G-4A | 2H3 |
| Scotts-Bell 47 Inc | 47G-5 | 2H3 |
| Scotts-Bell 47 Inc | 47G-5A | 2H3 |
| Scotts-Bell 47 Inc | 47H-1 | H-1 |
| Scotts-Bell 47 Inc | 47J | 2H1 |
| Scotts-Bell 47 Inc | 47J-2 | 2H1 |
| Scotts-Bell 47 Inc | 47J-2A | 2H1 |
| Scotts-Bell 47 Inc | 47K | 2H1 |
| Siam Hiller Holdings Inc. | UH-12E | 4H11 |
| Siam Hiller Holdings Inc. | UH-12E-L | 4H11 |
| Sierra Hotel Aero Inc. | Navion (Army L-17A) | A-782 |
| Sierra Hotel Aero Inc. | Navion A (Army L-17B and L-17C) | A-782 |
| Sierra Hotel Aero Inc. | Navion B | A-782 |
| Sierra Hotel Aero Inc. | Navion D | A-782 |
| Sierra Hotel Aero Inc. | Navion E | A-782 |
| Sierra Hotel Aero Inc. | Navion F | A-782 |
| Sierra Hotel Aero Inc. | Navion G | A-782 |
| Sierra Hotel Aero Inc. | Navion H | A-782 |
| Sikorsky Aircraft Corporation | 269A | 4H12 |
| Sikorsky Aircraft Corporation | 269A-1 | 4H12 |
| Sikorsky Aircraft Corporation | 269B | 4H12 |
| Sikorsky Aircraft Corporation | 269C | 4H12 |
| Sikorsky Aircraft Corporation | 269C-1 | 4H12 |
| Sikorsky Aircraft Corporation | 269D | 4H12 |
| Sky Enterprises Inc. | RC-3 | A-769 |
| Stearman Aircraft Company | 4-C | TC 2-155 |
| Stearman Aircraft Company | 4D | ATC 305 |
| Stearman Aircraft Company | 4E | ATC 292 |
| Stearman Aircraft Company | 6L | ATC 459 |
| Stearman Aircraft Company | C-3-B | ATC 55 |
| Stearman Aircraft Company | C3-B Special | TC 2-159 |
| Stearman Aircraft Company | C3-P | TC 2-445 |
| Stearman Aircraft Company | C3-R | ATC 251 |
| Taylorcraft 2000 LLC | 19 | 1A9 |
| Taylorcraft 2000 LLC | BC | A-696 |
| Taylorcraft 2000 LLC | BC-65 | A-696 |
| Taylorcraft 2000 LLC | BC12-65 | A-696 |
| Taylorcraft 2000 LLC | BC12-D | A-696 |
| Taylorcraft 2000 LLC | BC12-D1 | A-696 |
| Taylorcraft 2000 LLC | BC12D-4-85 | A-696 |
| Taylorcraft 2000 LLC | BC12D-85 | A-696 |
| Taylorcraft 2000 LLC | BCS | A-696 |
| Taylorcraft 2000 LLC | BCS-65 | A-696 |
| Taylorcraft 2000 LLC | BCS12-65 | A-696 |
| Taylorcraft 2000 LLC | BCS12-D | A-696 |
| Taylorcraft 2000 LLC | BCS12-D1 | A-696 |
| Taylorcraft 2000 LLC | BCS12D-4-85 | A-696 |
| Taylorcraft 2000 LLC | BCS12D-85 | A-696 |
| Taylorcraft 2000 LLC | F19 | 1A9 |
| Taylorcraft 2000 LLC | F21 | 1A9 |
| Taylorcraft 2000 LLC | F21A | 1A9 |
| Taylorcraft 2000 LLC | F21B | 1A9 |
| Taylorcraft Inc. | BF | A-699 |
| Taylorcraft Inc. | BF-60 | A-699 |
| Taylorcraft Inc. | BF-65 | A-699 |
| Taylorcraft Inc. | BF12-65 | A-699 |
| Taylorcraft Inc. | BFS | A-699 |
| Taylorcraft Inc. | BFS-60 | A-699 |
| Taylorcraft Inc. | BFS-65 | A-699 |
| Taylorcraft Inc. | BFS12-65 | A-699 |
| Taylorcraft Inc. | BL | A-700 |
| Taylorcraft Inc. | BL-65 | A-700 |
| Taylorcraft Inc. | BL12-65 | A-700 |
| Taylorcraft Inc. | BLS | A-700 |
| Taylorcraft Inc. | BLS-65 | A-700 |
| Taylorcraft Inc. | BLS12-65 | A-700 |
| The Boeing Company | AT-6 (SNJ-2) | A-2-575 |
| The Boeing Company | AT-6A (SNJ-3) | A-2-575 |
| The Boeing Company | AT-6B | A-2-575 |
| The Boeing Company | AT-6C (SNJ-4) | A-2-575 |
| The Boeing Company | AT-6D (SNJ-5) | A-2-575 |
| The Boeing Company | AT-6F (SNJ-6) | A-2-575 |
| The Enstrom Helicopter Corporation | 280 | H1CE |
| The Enstrom Helicopter Corporation | 280C | H1CE |
| The Enstrom Helicopter Corporation | 280F | H1CE |
| The Enstrom Helicopter Corporation | 280FX | H1CE |
| The Enstrom Helicopter Corporation | F-28 | H1CE |
| The Enstrom Helicopter Corporation | F-28A | H1CE |
| The Enstrom Helicopter Corporation | F-28C | H1CE |
| The Enstrom Helicopter Corporation | F-28C-2 | H1CE |
| The Enstrom Helicopter Corporation | F-28C-2R | H1CE |
| The Enstrom Helicopter Corporation | F-28F | H1CE |
| The Enstrom Helicopter Corporation | F-28F-R | H1CE |
| The Waco Aircraft Company | 125 | ATC 26 Waco |
| The Waco Aircraft Company | AGC-8 | TC 664 |
| The Waco Aircraft Company | AQC-6 | TC 598 |
| The Waco Aircraft Company | ARE | TC 714 |
| The Waco Aircraft Company | ASO | ATC 41 |
| The Waco Aircraft Company | ATO | ATC 123 |
| The Waco Aircraft Company | AVN-8 | TC 677 |
| The Waco Aircraft Company | BSO | ATC 168 |
| The Waco Aircraft Company | CJC | ATC 538 |
| The Waco Aircraft Company | CJC-S | ATC 538 |
| The Waco Aircraft Company | CRG | ATC 362 |
| The Waco Aircraft Company | CSO | ATC 240 |
| The Waco Aircraft Company | CUC | ATC 575 |
| The Waco Aircraft Company | CUC-1 | ATC 575 |