Skip to content

Registered aircraft · 72

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

N23599Vanwagnen Karen S · Jackson, MIBuilt 1939 · S/N C5599 N23907Buergel Sandra J · East Aurora, NYBuilt 1939 · S/N C-5789 N23919Agaliotis Paul E · San Martin, CAS/N C-5839 N23921Coburn Russell G · Layton, UTBuilt 1939 · S/N C-5779 N23925Johnson Scott W · Milan, MIBuilt 1939 · S/N C-6119 N23927Mccauley Christopher · Barto, PABuilt 1939 · S/N C4109 N23935Moore Prentice D · Walker, LABuilt 1939 · S/N C5939 N23961Kilponen Jeffrey G · Cedarville, MIS/N C-6109 N23971Hogan Frederick D · Hamilton, OHBuilt 1939 · S/N C6289 N23974Long Daniel S · Pendleton, ORBuilt 1939 · S/N C-6399 N23975Macveigh Craig A · New Carlisle, OHS/N C-6309 N23977Podeweltz Dana A · Merrill, WIBuilt 1939 · S/N C-6369 N23981Klarfeld Kenneth · Oregon City, ORBuilt 1939 · S/N C6379 N23985Schneider Kalan J · Intl Falls, MNBuilt 1939 · S/N C-6469 N23999Registration Pending · Seneca, SCRegistration pendingBuilt 1939 · S/N C6719 N24217Trainor Todd · Brighton, MIBuilt 1939 · S/N C6839 N26338Van Wagnen Brian · Jackson, MIBuilt 1940 · S/N C8040 N26359Strebig Stuart C · San Diego, CABuilt 1941 · S/N C-8210 N26362Charles Carroll · Ephrata, PABuilt 1940 · S/N C-8190 N26374Dexter Fred H · Live Oak, FLBuilt 1940 · S/N C8370 N6539CPetersen Curt L · Sperry, IAS/N C 4259 N908XCBowles Christian · Taylorsville, NCS/N C-3289

Back to Aeronca 65-C