Models · 19

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 = 'A4SW'
  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 = 'A4SW'
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
S2R-R3S		Formerly Snow Aeronautical Company, North American Rockwell Corporation, Rockwell International, Ayres Corporation, Quality Aerospace, Inc., then Thrush Aircraft, Inc.
S2R-T15		Formerly Snow Aeronautical Company, North American Rockwell Corporation, Rockwell International, Ayres Corporation, Quality Aerospace, Inc., then Thrush Aircraft, Inc.
S2R-T11		Formerly Snow Aeronautical Company, North American Rockwell Corporation, Rockwell International, Ayres Corporation, Quality Aerospace, Inc., then Thrush Aircraft, Inc.
600 S-2D		Formerly Snow Aeronautical Company, North American Rockwell Corporation, Rockwell International, Ayres Corporation, Quality Aerospace, Inc., then Thrush Aircraft, Inc.
S2R-G10		Formerly Snow Aeronautical Company, North American Rockwell Corporation, Rockwell International, Ayres Corporation, Quality Aerospace, Inc., then Thrush Aircraft, Inc.
S2R-G1		Formerly Snow Aeronautical Company, North American Rockwell Corporation, Rockwell International, Ayres Corporation, Quality Aerospace, Inc., then Thrush Aircraft, Inc.
S2R-T65		Formerly Snow Aeronautical Company, North American Rockwell Corporation, Rockwell International, Ayres Corporation, Quality Aerospace, Inc., then Thrush Aircraft, Inc.
S2RHG-T65		Formerly Snow Aeronautical Company, North American Rockwell Corporation, Rockwell International, Ayres Corporation, Quality Aerospace, Inc., then Thrush Aircraft, Inc.
S2R-T34		Formerly Snow Aeronautical Company, North American Rockwell Corporation, Rockwell International, Ayres Corporation, Quality Aerospace, Inc., then Thrush Aircraft, Inc.
S2R-T660		Formerly Snow Aeronautical Company, North American Rockwell Corporation, Rockwell International, Ayres Corporation, Quality Aerospace, Inc., then Thrush Aircraft, Inc.
S2R-R1340		Formerly Snow Aeronautical Company, North American Rockwell Corporation, Rockwell International, Ayres Corporation, Quality Aerospace, Inc., then Thrush Aircraft, Inc.
S2R-G6		Formerly Snow Aeronautical Company, North American Rockwell Corporation, Rockwell International, Ayres Corporation, Quality Aerospace, Inc., then Thrush Aircraft, Inc.
S2R-H80		Formerly Thrush Aircraft, Inc.
S2R		Formerly Snow Aeronautical Company, then North American Rockwell Corporation, then Rockwell International, then Ayres Corporation, then Quality Aerospace, then Inc.
S2RHG-T34		Formerly Snow Aeronautical Company, North American Rockwell Corporation, Rockwell International, Ayres Corporation, Quality Aerospace, Inc., then Thrush Aircraft, Inc.
S2R-G5		Formerly Snow Aeronautical Company, North American Rockwell Corporation, Rockwell International, Ayres Corporation, Quality Aerospace, Inc., then Thrush Aircraft, Inc.
S2R-R1820		Formerly Snow Aeronautical Company, North American Rockwell Corporation, Rockwell International, Ayres Corporation, Quality Aerospace, Inc., then Thrush Aircraft, Inc.
S2R-T45		Formerly Snow Aeronautical Company, North American Rockwell Corporation, Rockwell International, Ayres Corporation, Quality Aerospace, Inc., then Thrush Aircraft, Inc.
S2R-510		Formerly Snow Aeronautical Company, then North American Rockwell Corporation, then Rockwell International, then Ayres Corporation, then Quality Aerospace, then Inc., then Thrush Aircraft, then Inc.

Back to TCDS A4SW