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.

N83992Mandala Michael L · Chowchilla, CABuilt 1946 · S/N 7AC-2678 N83994Rausch John C · Upland, CAS/N 7AC-2681 N83997Fuentes Hansen B · Louisville, KYBuilt 1946 · S/N 7AC2684 N84002Registered aircraftBuilt 1946 · S/N 7AC-2690 N84003Shiner Stephen M · Marshfield, WIBuilt 1946 · S/N 7AC-2691 N84004Swenson Leroy D · Le Sueur, MNBuilt 1946 · S/N 7AC-2692 N84006Mueller David C · Fremont, NEBuilt 1976 · S/N 7AC-2694 N84012Berghoff Lewis · Selmer, TNBuilt 1946 · S/N 7AC-2699 N84016Plane Trail LLC · Mccook, NEBuilt 1946 · S/N 7AC-2703 N84018Johnson Bennett · Everett, WABuilt 1946 · S/N 7AC-2705 N84020Baker Robert · Dorr, MIBuilt 1946 · S/N 7AC-2707 N84021Hart Timothy S · Apison, TNBuilt 1946 · S/N 7AC-2708 N84025Griesman Scott W · Sandy Valley, NVBuilt 1946 · S/N 7AC-2712 N84028Kranz Michael J · Castlewood, SDS/N 7AC-2715 N84029Chase Michael D · Sonora, CABuilt 1946 · S/N 7AC-2716 N84030Lester Gordon W · Corpus Christi, TXBuilt 1946 · S/N 7AC-2717 N84031Hamilton James S · Decker, MTBuilt 1946 · S/N 7AC-2718 N84033Schmitt Zachary J · Nordman, IDBuilt 1946 · S/N 7AC-2720 N84035Howell John R · Bertram, TXBuilt 1946 · S/N 7AC-2722 N84046Bowman Stephen Lee · Palm Bay, FLBuilt 1946 · S/N 7AC-2733 N84049Link James L · Raleigh, NCBuilt 1946 · S/N 7AC2736 N84053Mandala Mike L · Chowchilla, CABuilt 1946 · S/N 7AC-2740 N84056Registration Pending · Carmi, ILRegistration pendingBuilt 1946 · S/N 7AC-2743 N84069Kim Jonathan · Abilene, TXBuilt 1946 · S/N 7AC-2756 N84074Abbe Thomas E · Wasilla, AKBuilt 1946 · S/N 7AC-2761 N84075Normark Nancy · Weirsdale, FLBuilt 1946 · S/N 7AC-2762 N84080Thomas Richard E · Lafayette, TNS/N 7AC-2767 N84083Cottrell Alan L · Toano, VABuilt 1946 · S/N 7AC-2770 N84091Nantz William G · Raleigh, NCBuilt 1946 · S/N 7AC-2778 N84096Walls Sales LLC · Poplar Bluff, MOBuilt 1946 · S/N 7AC-2783 N84100270 Aero LLC · Fulton, KYBuilt 1946 · S/N 7AC-2787 N84111Boggs Aerospace LLC · Keyser, WVBuilt 1946 · S/N 7AC-2797 N84113Palmatier Robert J · Orange Park, FLBuilt 1946 · S/N 7AC-2800 N84115Stormer Isaac · Curtis, WAS/N 7AC-2802 N84121Myers Stanley A · Linn, MOBuilt 1946 · S/N 7AC-2808 N84123Cahill Herbert G · Chesapeake, VABuilt 1946 · S/N 7AC-2810 N84124Mussman Craig · Grant Park, ILS/N 7AC2811 N84126Three J Flying LLC · West Des Moines, IABuilt 1946 · S/N 7AC-2815 N84127Anderson Blake T · Locust Grove, GABuilt 1946 · S/N 7AC-2814 N84139Bakrevski Lupcho · Valparaiso, INS/N 7AC2824 N84155Grissom Michael D Jr · Henderson, NCS/N 7AC-2844 N84157Padisak Michael · Traverse City, MIS/N 7AC-2843 N84158Rinaudo James J · Gulf Shores, ALBuilt 1946 · S/N 7AC-2845 N84160Preston Robert J · Pittstown, NJBuilt 1946 · S/N 7AC-2847 N8416388 Charlies Inc · Palmyra, WIBuilt 1946 · S/N 7AC-2849 N84164Eisberg Keith W · Columbia, MOS/N 7AC-2851 N84166Prather Carl Lynn · Gilroy, CABuilt 1946 · S/N 7AC-2853 N84167Tate Edwin N · Sheridan, ORBuilt 1946 · S/N 7AC-2854 N84168Bost Roger C · Greensboro, NCBuilt 1946 · S/N 7AC-2856 N84171Gates Glen C · Lapeer, MIBuilt 1946 · S/N 7AC-2859

Back to Aeronca 7AC