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.

N3730EKoening John A · Boca Raton, FLBuilt 1947 · S/N 7AC-7021 N3732ESturdevant Robert M · Trappe, MDBuilt 1947 · S/N 7AC-7023 N3737EWulkn Brad O · Hector, MNBuilt 1947 · S/N 7AC-7028 N3738EWright Peter S · Watertown, WIBuilt 1947 · S/N 7AC-7115 N3740ELinstad Daniel E · Canby, ORBuilt 1947 · S/N 7AC-7127 N3743EWings Up LLC · Saint Augustine, FLS/N 7AC-7120 N3744EZimmermann Mark · Granbury, TXBuilt 1947 · S/N 7AC-7034 N3753EVerduin William D · Zeeland, MIS/N 7AC-7042 N3757EWood Thomas D Jr · Irvington, ALBuilt 1947 · S/N 7AC-7047 N3774EDanner Charles L · Oak Harbor, OHBuilt 1947 · S/N 7AC-7057 N3775EOrahood Douglas R · Cicero, INBuilt 1947 · S/N 7AC-7058 N37778Davidson Milton P · New Folden, MNS/N 2102 N3779EHeise Roger H · Clayton, NYBuilt 1947 · S/N 7AC7061 N3782EOlson David A · New Underwood, SDBuilt 1947 · S/N 7AC-7065 N3786EHughes J Lonny · Lake Crystal, MNBuilt 1947 · S/N 7AC-7068 N3797EHammond Michael L · Georgetown, TNBuilt 1947 · S/N 7AC-7075 N3816ESpark I Aviation LLC · Wichita, KSBuilt 1947 · S/N 7AC-7085 N3823ELanglois James F · Merrill, WIBuilt 1947 · S/N 7AC-7081 N3853EKownurko Evan C · Elmira, NYBuilt 1947 · S/N 7AC-7093 N3854EPringle Anthony A · Durham, MEBuilt 1947 · S/N 7AC-7094 N3857ERegistration Pending · Monroe, LARegistration pending, pending cancellationBuilt 1947 · S/N 7AC-7096 N3874EMelton James A · Conway, ARBuilt 1946 · S/N 7AC-7101 N3887ESchorsch Cary J · Franksville, WIBuilt 1947 · S/N 7AC-7109 N3898EBoss Gary W · Bronston, KYBuilt 1947 · S/N 7AC-7113 N38TGJohnson Tracy W · Odessa, MOBuilt 1946 · S/N 7AC-3292 N3914ETennis Stephen D · Hudson, MIBuilt 1947 · S/N 7AC-7119 N3919EMiller Glenn E · Selma, CABuilt 1947 · S/N 7AC-7121 N391PDMarteney Donald L · Sarasota, FLBuilt 1946 · S/N 7AC-5891 N39632Tumbleson Shelly L · San Antonio, TXBuilt 1946 · S/N 7AC-6147 N39642Melby Mark G · Mount Pleasant, WIBuilt 1945 · S/N 7AC-10 N3PBBendigo Paul L · Reading, PABuilt 1946 · S/N 7AC-4103 N4040AShifrin Salvatore J · Windham, CTBuilt 1947 · S/N 47-1080 N409JSJones Clayton S · Nacogdoches, TXS/N 7AC-3369 N4141EEpmeier Bruce E · Newburgh, INBuilt 1947 · S/N 7AC-7131 N4160EWanda Collins Professional Pilot Services LLC · Madisonville, TXBuilt 1947 · S/N 7AC-7135 N4205EJeppesen Brad · Caldwell, IDBuilt 1947 · S/N 7AC-7146 N4208EToman Michael · Painesville, OHBuilt 1947 · S/N 7AC-7145 N4217ENelson Melvern · Mena, ARBuilt 1947 · S/N 7AC-7149 N4223EBlue Sky Sport & Tail Wheel Inc · Mary Esther, FLBuilt 1947 · S/N 7AC-7152 N42272Langford Taylor C · York, SCS/N 7AC-2004 N4236ERegistration Pending · Bristol, CTRegistration pendingBuilt 1947 · S/N 7AC-7154 N4254EWeigel John C · Natick, MAS/N 7AC7158 N4264ECollum Aviation LLC · Milton, FLBuilt 1947 · S/N 7AC-7161 N4281E4281e LLC · Haleiwa, HIBuilt 1947 · S/N 7AC-7169 N4293TDiehl Ryan J · Columbus, OHS/N 7AC5466 N4328EDangelo Dennis L · Xenia, OHBuilt 1948 · S/N 7AC-7181 N4408EStroup Stephen L · Atwater, OHBuilt 1948 · S/N 7AC-7186 N4427EJ P Aero Holdings Inc · Carson City, NVBuilt 1948 · S/N 7AC-7188 N4430ELabby Carolina S · Livermore, CABuilt 1948 · S/N 7AC-7191 N443WBHusted Dean T · Hicksville, OHBuilt 1945 · S/N 7AC-367

Back to Aeronca 7AC