Skip to content

Registered aircraft · 141

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

N1165SStark David M · Merkel, TXS/N CA-16251 N21371Hilbert Elroy E II · Rockford, ILS/N C1808 N22478Avery Michael L · Cumberland, WIBuilt 1939 · S/N C4249 N23962Stagg Skip W · Lakewood, CABuilt 1939 · S/N 6229 N26318Finseth Lowell J · Fountain, MNBuilt 1940 · S/N 7880 N29206Bendix Airmens Association Inc · Wilmington, DEBuilt 1940 · S/N C10060 N29229Massey Wayne L · Okahumpka, FLBuilt 1940 · S/N C-10150 N29248Free Alan R · Paulding, OHBuilt 1940 · S/N CA10210 N29427Lamphar Eric Matthew · Lebanon, OHBuilt 1940 · S/N CA10220 N29433Zenor Dean C · Lake City, IABuilt 1940 · S/N CA-10310 N29445Brunhoeber Michael E · Caldwell, KSBuilt 1940 · S/N C-10300 N29497Johnson Donald W · Sharpsburg, GABuilt 1940 · S/N C10440 N31350Varrasse Raymond R · Yulee, FLBuilt 1940 · S/N C-10370 N31393Roberson Henry B · Chico, CABuilt 1940 · S/N C10550 N31413Kelly Bryan P · Clearwater, MNBuilt 1940 · S/N CA10640 N31422Klingenberg Tim C · Udall, KSBuilt 1940 · S/N CA10750 N31738Rusty Robertson · Fresno, CABuilt 1940 · S/N CA10910 N31771Martin Aviation LLC · Bargersville, INBuilt 1940 · S/N C-11080 N31797Graham Bruce M · Amarillo, TXBuilt 1940 · S/N CA-11140 N31807Gores Thomas J · Franklin, WIS/N C11220 N31854Moulder Clayton J · Jensen Beach, FLS/N CA11440 N31886Wolcott James N · Grandview, TXBuilt 1944 · S/N C-11711 N31892Dorman Richard E · Mesa, WABuilt 1941 · S/N C-11721 N31895Gores Thomas J · Franklin, WIBuilt 1941 · S/N C11671 N31899Byrne Donald L Jr · Lusby, MDBuilt 1941 · S/N CA-11981 N31903Mullins Adrian J · Cartersville, GABuilt 1941 · S/N CA-11841 N31925Woodhams Jonathon R · South Haven, MIBuilt 1941 · S/N CA12031 N31928Hammons John M · Grapeland, TXS/N CA12101 N31954Gores Thomas J · Franklin, WIBuilt 1940 · S/N CA12321 N31992Rider Rp Field · New Gloucester, MES/N C-12701 N31997Hogan Frederick D · Hamilton, OHBuilt 1941 · S/N C12741 N33705Rapp Tim J · Fairfield, MTBuilt 1941 · S/N C12831 N33708Grimes Kenneth · Charlotte, NCBuilt 1941 · S/N CA12751 N33717Beck Gary E · Richlands, NCBuilt 1941 · S/N C13021 N33718Wilson Nicholas G · Snohomish, WARegistration revokedBuilt 1941 · S/N C-12951 N33721Naeyaert Lennie M · Seymour, TXS/N C12921 N33731Bieser John P · Hartford, WIBuilt 1941 · S/N CA13251 N33738Dexter Fred H · Live Oak, FLS/N C13061 N33744Brewer Stephen F · Hamilton, OHS/N CA-13071 N33766Cain James W · Big Rapids, MIS/N C13321 N33775Dunn Ronald G · Larwill, INBuilt 1941 · S/N CA13351 N33779Mummey Gary E · Stockport, OHBuilt 1941 · S/N C13301 N33783Aeronca Aircraft History Museum · Brighton, MIBuilt 1941 · S/N CA-13531 N33784Registered aircraftS/N CA13471 N33800Crichton James W Jr · Chattanooga, TNBuilt 1941 · S/N C-13621 N33826Franklin John B Jr · Needville, TXBuilt 1941 · S/N C13691 N33844Wiley Gordon · Arbela, MOBuilt 1941 · S/N CA13921 N33851Ropp Dorothy E · Drummond Island, MIBuilt 1941 · S/N C14041 N33853Yanks Air Museum · Baldwin Park, CAS/N C13871 N33854Will Mychal C · North Las Vegas, NVS/N CA13951

Back to Aeronca 65-CA