Skip to content

Registered aircraft · 22

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

N17483Kramer Dean E · Bernville, PABuilt 1937 · S/N K3 N17492Bender Ronald J · Columbus, NMS/N K-23 N17750Bednarek Janet R · Centerville, OHBuilt 1937 · S/N K-16 N17774King John D · Midland, VABuilt 1937 · S/N K-42 N17778Leblanc John D · Deland, FLS/N K-46 N17798Weck Geoffrey E · Woodstock, ILBuilt 1937 · S/N K-64 N18838Leblanc John David · Deland, FLBuilt 1945 · S/N K-104 N18844Price Christopher R · Shullsburg, WIBuilt 1937 · S/N K110 N18863Esch Joseph W Executor · Carson, WAS/N K-129 N18869Griggs Gerald Warren · Goddard, KSBuilt 1937 · S/N K-154 N18872Airpower Museum Inc · Ottumwa, IABuilt 1937 · S/N K-147 N18877Nichols Charles F Trustee · Baldwin Park, CABuilt 1937 · S/N K-141 N19301Whitehurst Joel A Jr · Los Banos, CAS/N K-169 N19314Command Aire LLC · Sitka, AKS/N K180 N19331Hentnik Robert D · Fredericksburg, TXBuilt 1937 · S/N K-199 N19338Brewer Stephen F · Hamilton, OHS/N K-206 N19347Wass Carl A · Belgrade, MTBuilt 1937 · S/N K-214 N19349Lewis Paul A · Tomball, TXBuilt 1937 · S/N K207 N19718Western Antique Aeroplane & Automobile Museum · Hood River, ORBuilt 1945 · S/N K236 N19744Dexter Fred H · Live Oak, FLBuilt 1945 · S/N K260 N21060Gores Thomas J · Franklin, WIBuilt 1938 · S/N K-335 N4626TCollum Archie · Milton, FLS/N K-298

Back to Aeronca K