Skip to content

Registered aircraft · 1,878

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

N2886EMcnab Jacob R · Ozark, ALBuilt 1946 · S/N 7AC-6469 N2894EAv Ed Consulting LLC · Edgewater, FLBuilt 1946 · S/N 7AC-6477 N2895EPritchett Flying Service LLC · Rolla, MOS/N 7AC-6478 N2898ECenturion Aviation Ltd · Salina, KSBuilt 1946 · S/N 7AC-6481 N2904ESchutze Curt K · Knoxville, TNBuilt 1946 · S/N 7AC-6487 N2907EShuford Charles D · Orange Park, FLFirst renewal noticeBuilt 1946 · S/N 7AC-6490 N2908EBane Alan D · Columbia, ILBuilt 1946 · S/N 7AC-6491 N2910ESlayton Michael B · Grand Haven, MIBuilt 1946 · S/N 7AC-6493 N2912EPrather Carl Lynn · Gilroy, CABuilt 1946 · S/N 7AC-6495 N2914EAnderson Shad · Woods Cross, UTBuilt 1946 · S/N 7AC-6497 N2915E172-B LLC · Prairieville, LAS/N 7AC-6498 N2916ERegistered aircraftBuilt 1946 · S/N 7AC-6499 N2922EWilson Nathan Jon · Royal City, WABuilt 1946 · S/N 7AC-6505 N2929EPetro Jerry R · Williamsburg, VABuilt 1946 · S/N 7AC-6512 N2935EPaulson David E · Warroad, MNS/N 7AC-6518 N2942EMccullough Richard G · Merrill, WIBuilt 1946 · S/N 7AC-6525 N2944EGeyer Mary A · Metamora, MIBuilt 1946 · S/N 7AC-6533 N2948EWings & Wine Inc · Euclid, OHBuilt 1946 · S/N 7AC-6534 N2950ECarboni Christian J · Hennepin, ILBuilt 1946 · S/N 7AC-6536 N2955ERich Jacob T · Eatonville, WAS/N 6542 N2957EHarmon Anthony Wayne · Easley, SCBuilt 1946 · S/N 7AC-6544 N2960EStewarts Aircraft Service · Waynesville, OHBuilt 1946 · S/N 7AC-6546 N2971EGreen Samuel · Clifton Park, NYBuilt 1946 · S/N 7AC-6557 N2972EWarner Robert · Mckinney, TXBuilt 1946 · S/N 7AC-6558 N2973EWhiting Stephen D · Poway, CABuilt 1946 · S/N 7AC-6559 N2977ESeine Michael P · Wasilla, AKFirst renewal noticeBuilt 1946 · S/N 7AC-6563 N2979ERogers James R · Morriston, FLBuilt 1946 · S/N 7AC-6565 N2982EGauthier Peter J · Woodburn, ORBuilt 1946 · S/N 7AC-6568 N2985EWelna John M · Saginaw, MNS/N 7AC-6476 N2988EJones Mike G · Slaton, TXBuilt 1946 · S/N 7AC-6574 N2992ESallade William L · Coudersport, PABuilt 1946 · S/N 7AC-6579 N2998EWenk Jennifer M · Beaufort, NCBuilt 1946 · S/N 7AC-6585 N2PMDixon Morris M · Poynette, WIBuilt 1946 · S/N 7AC-2461 N3002ETaylor Judith R · Lake Forest Park, WABuilt 1946 · S/N 7AC-6588 N3005EOctagon Corp · Lewes, DEBuilt 1946 · S/N 7AC-6591 N3009EPollack Thomas H · Santa Monica, CABuilt 1946 · S/N 7AC-6595 N3011EDouble Dose LLC · Kennewick, WABuilt 1946 · S/N 7AC-6597 N3013EThompson Steve DBA · Pauls Valley, OKBuilt 1946 · S/N 7AC-6599 N3016ELutz Gregory J · East Bridgewater, MABuilt 1946 · S/N 7AC-6602 N3019EDobbelaere Rick H · Oakwood, OHS/N 7AC-6605 N3020ELacore Danny L · Flower Mound, TXBuilt 1955 · S/N 7AC-6606 N3023EGarrett Joseph · Saint Jacob, ILBuilt 1946 · S/N 7AC-6609 N3025ECody Plane Corp · Wilmington, DEBuilt 1946 · S/N 7AC-6611 N3029EConlin Michael T · Pawleys Island, SCS/N 7AC-6615 N3032EDerick John Thomas II · Newburg, PABuilt 1946 · S/N 7AC-6617 N3033E1941 Aircraft Group · Geneseo, NYBuilt 1946 · S/N 7AC-6619 N3035EHartman Michael A · Standish, MIBuilt 1946 · S/N 7AC-6621 N3039EFlory Daniel L · Elk Grove, CABuilt 1946 · S/N 7AC-6625 N3040ERegistered aircraftBuilt 1946 · S/N 7AC-6626 N3046EKnox Larry D · Parachute, COS/N 7AC-6593

Back to Aeronca 7AC