Skip to content

Registered aircraft · 28

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

N29498Lockbaum Jim G · Oconomowoc, WIS/N L10390 N31369Walburn John M · Mansfield, OHBuilt 1940 · S/N LB10480 N313LAGores Thomas J · Franklin, WIS/N LB-10520 N31488Brewer Stephen F · Hamilton, OHBuilt 1940 · S/N L10960 N31845Walls Sales LLC · Poplar Bluff, MOBuilt 1940 · S/N L-11380 N31851Sellix Eric R · Lehighton, PABuilt 1940 · S/N L11450 N31866Trevino Jesus · Boyd, WIS/N L11551 N31918Registration Pending · Lamar, ARRegistration pendingBuilt 1941 · S/N LB11971 N31931Evans Cameron Steven · Union Grove, WIBuilt 1941 · S/N L-12091 N31963Shepard Logan K · Sultan, WAS/N L12461 N31986Murray Christopher S · Chandler, AZBuilt 1941 · S/N LB-12641 N33704Jones Clyde B · Crab Orchard, KYS/N L12771 N33710Aeronca Aircraft History Museum · Brighton, MIBuilt 1941 · S/N LB12901 N33711Macveigh Craig A · New Carlisle, OHS/N LB12891 N33713Mccauley John · Pasco, WABuilt 1941 · S/N LB12911 N33719Wagner Daniel L · Howe, INBuilt 1941 · S/N L12991 N33790Ercegovac Charles J · Merrill, WIBuilt 1941 · S/N L13541 N33821Brunks Paul D · Peachtree City, GABuilt 1955 · S/N LB13631 N34488Grachev Timofey · Hammond, WIS/N L-14721 N34496Ricco Umberto · Chicago, ILS/N L-14881 N34497Harrison Vernon D · Crawford, TXS/N L-14841 N34504Simons Douglas L · Eagle, MIBuilt 1941 · S/N L-14971 N34522Batten Stanley · Arlington, MNBuilt 1941 · S/N LB14821 N34545Hatz Allan J · Neillsville, WIS/N L15391 N36503Yanks Air Museum · Baldwin Park, CAS/N L-15581 N36617Edgren John H · Oskaloosa, IABuilt 1941 · S/N LB16931 N36692Wade Mark C · Bonham, TXBuilt 1942 · S/N L17501 N38152Lucas Lester L · Napa, CAS/N LB11420

Back to Aeronca 65-LB