Skip to content

Registered aircraft · 21

Aircraft of this model in the FAA registry, by N-number.

Query with SQL

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN ('9600835')
  ORDER BY n_number"

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 n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN ('9600835')
ORDER BY n_number

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.

N17453Eggert Thomas F · Woodbury, MNBuilt 1937 · S/N 4554 N17462Pederson William K Jr · Hillsboro, ORBuilt 1937 · S/N 4604 N17464Consolidated Aero LLC · Gibsonville, NCS/N 4605 N17466Stroup David J · Alliance, OHBuilt 1937 · S/N 4609 N17471Gold Cap LLC · Bremerton, WABuilt 1937 · S/N 4614 N17472Newport/Signal Air Inc · Signal Hill, CABuilt 1937 · S/N 4612 N17473Warwick Gregory W · North Conway, NHBuilt 1937 · S/N 4611 N17474Harter Mark S · Belleville, ILBuilt 1937 · S/N 4613 N17713San Diego Air & Space Museum Inc · San Diego, CABuilt 1937 · S/N 4625 N17716Soare Sean C · Poplar Grove, ILBuilt 1937 · S/N 4623 N17734Fawcett Walter L Jr · Wolfeboro, NHBuilt 1937 · S/N 4636 N17736Harders Todd M · Cairo, NEBuilt 1937 · S/N 4665 N17737Hoffman Allen D Sr · Cheboygan, MIBuilt 1937 · S/N 4666 N1937Nichols Charles F Trustee · Baldwin Park, CABuilt 1937 · S/N 4631 N19371Stroup David J · Alliance, OHBuilt 1938 · S/N 5211 N19373Niemyjski Trevor G · Union Grove, WIBuilt 1938 · S/N 5204 N19386Petro Jerry R · Williamsburg, VABuilt 1939 · S/N 5212 N2629Fulton Stephen D · Kirkland, WAS/N 5233 N2896DPort Townsend Aero Museum · Port Townsend, WABuilt 1938 · S/N 4692 N29370Mclean Diane A · Weirsdale, FLBuilt 1940 · S/N 5228 N65201Ferguson Carrie L · Palo Alto, CABuilt 1937 · S/N 4621

Back to Waco YKS-7