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.

N127KMAero Mobil Inc · Wilmington, DEBuilt 1938 · S/N C-1288 N21091Barthule Jacob E · Roundup, MTS/N C-1068 N21301Borsheim Scott R · Deerwood, MNBuilt 1938 · S/N C1058 N21304Ries Richard A · Irving, TXBuilt 1938 · S/N C-1098 N21340West Larry L Trustee · Tumtum, WABuilt 1938 · S/N C-1468 N21354Dexter Fred H · Live Oak, FLS/N C-1598 N21364Mccance Lee A · Morenci, MIBuilt 1938 · S/N C-1698 N21365Caulkins Howell V · Chico, CABuilt 1938 · S/N C-1788 N21366Blanco Rafael Gomez · Lakewood, CAS/N C-1718 N21377Carrier David A · Traverse City, MIBuilt 1938 · S/N C-1948 N21378Reinke Paul A · Elkhart, IABuilt 1938 · S/N C-1878 N21397Smith Peter C · Maplesville, ALS/N C-2058 N22105Session Tristan L · Higden, ARBuilt 1938 · S/N C-2128 N22108Schrab Geoffrey M · Reeseville, WIBuilt 1938 · S/N C-2148 N22116Ishawooa Air LLC · Cody, WYBuilt 1938 · S/N C2208 N22137Macveigh Craig A · New Carlisle, OHS/N F-2389 N22164Faust Anthony S · Rhome, TXBuilt 1939 · S/N C-2589 N22169Bischoff Roy H III · Flower Mound, TXS/N C2719 N22171Boone Jim R · Farmington, CABuilt 1939 · S/N C-2739 N22173Spirit Of Haughton Inc · Shreveport, LABuilt 1939 · S/N C2759 N22181Gilbert Benjamin Jackson Jr · Hernando, FLBuilt 1939 · S/N C2859 N22317Garcia Geoff M · Tecumseh, OKBuilt 1939 · S/N C-3229 N22319Riser Bruce L · Kenosha, WIBuilt 1939 · S/N C-3209 N22321Cooker Brian M · Gold Hill, NCBuilt 1939 · S/N C-3239 N22359Diedrich Lawrence F · Edgemont, ARBuilt 1939 · S/N C-3619 N22366Thoene Jerry K · Caldwell, IDS/N C3659 N22378Williams Densel · Jackson, MIBuilt 1939 · S/N C-3509 N22380Givens Christopher A · Frankfort, OHBuilt 1939 · S/N C-3799 N22383Lang Richard H · Knoxville, TNS/N C3839 N22384Trainor Todd · Brighton, MIBuilt 1939 · S/N C-3849 N22386Aeronca Aircraft History Museum · Brighton, MIS/N C-3859 N22388Quantic Air LLC · Shady Shores, TXBuilt 1939 · S/N C-3879 N22389National Aeronca Association · Middletown, OHS/N L-3889 N22476Bowles Chris · Taylorsville, NCS/N C-4279 N22492York Stanley A · Leetonia, OHBuilt 1939 · S/N C-4409 N22497Mckinney John C · Susquehanna, PABuilt 1939 · S/N C4519 N23507Yenser Thomas A · Kutztown, PABuilt 1939 · S/N C-4559 N23513Birkhold Craig A · Napoleon, OHBuilt 1939 · S/N C-4619 N23518Cooker Brian M · Gold Hill, NCBuilt 1939 · S/N 4999 N23532Campbell David S · Madras, ORBuilt 1939 · S/N C4779 N23537Van Wagnen Brian J · Jackson, MIBuilt 1939 · S/N C4809 N23546Macveigh Craig A · New Carlisle, OHS/N C-4939 N23548Rogers Samuel · Le Roy, KSBuilt 1939 · S/N C-5039 N23549Reagin Brian E · Newton Grove, NCBuilt 1939 · S/N C-4949 N23554Butler Jeffrey A · Gansevoort, NYBuilt 1939 · S/N C5089 N23559O'Connor Stanley R · Knightdale, NCBuilt 1939 · S/N C-5159 N23562Ricci Moretti Luigi U · Swarthmore, PABuilt 1939 · S/N C5389 N23567Parrish James N · Great Barrington, MABuilt 1939 · S/N C-5269 N23572Wroe Daniel C · Denton, MDBuilt 1939 · S/N C-5299 N23586Van Wagnen Brian · Jackson, MIBuilt 1939 · S/N C-5509

Back to Aeronca 65-C