Skip to content

Registered aircraft · 23

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 ('5650202')
  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 ('5650202')
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.

N15784Combat Air Museum Inc · Topeka, KSBuilt 1935 · S/N 1 N250TWTaylor Brian E · Cassopolis, MIBuilt 1940 · S/N 25 N26458Tindall Frank H Jr · Allentown, NJBuilt 1940 · S/N 11 N26467Thibodeau Thomas J · Honea Path, SCBuilt 1940 · S/N 20 N26469Barg Michael D · Honea Path, SCBuilt 1940 · S/N 22 N26473Jasper Ralph Lane · Biloxi, MSBuilt 1940 · S/N 26 N26475Mid Atlantic Air Museum · Reading, PABuilt 1940 · S/N 28 N26483Morozowsky John S · Zanesville, OHBuilt 1941 · S/N 36 N26485Grangruth Rory A · Wadena, MNBuilt 1941 · S/N 38 N26489Schildberg Gregory M · Casey, IABuilt 1941 · S/N 42 N26491Darden Elizabeth · Morrisville, VTBuilt 1941 · S/N 68 N34304Sheeree Corp · Wilmington, DES/N 49 N34310Freeman Heritage Collection LLC · Kingsbury, TXBuilt 1941 · S/N 53 N34311Martin Dennis E · Oconto, WIS/N 55 N34325Gap Mountain Development LLC · Jaffrey, NHBuilt 1942 · S/N 70 N34326West Larry L Trustee · Tumtum, WABuilt 1942 · S/N 71 N34327Hays Gary R · Chino Valley, AZS/N 72 N34330Bradford III Properties LLC · Huntersville, NCBuilt 1942 · S/N 75 N34331Wright Thomas L · Clyde, OHBuilt 1942 · S/N 76 N34332Hunt Tyson Bregistered · Saratoga Springs, NYS/N 77 N34333Grangruth Rory A · Wadena, MNBuilt 1941 · S/N 78 N34342Schaller Lee W · New Athens, ILBuilt 1943 · S/N 87 N34345Gomez Phil · Henniker, NHS/N 89

Back to Meyers OTW