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.

N2369EHayton James B · Sedro Woolley, WABuilt 1946 · S/N 7AC-5946 N2372EHulboy Jeffrey K · Churubusco, INBuilt 1946 · S/N 7AC-5949 N2379ESchoonmaker Michael D · Alder Creek, NYBuilt 1946 · S/N 7AC-5956 N2384EMcconnaughhay Anthony B · Jacksonville, ARBuilt 1946 · S/N 7AC-5963 N2385EAdkins Jonathan T · Belvidere, ILBuilt 1946 · S/N 7AC-5964 N2387ERogers Gary L · Enid, OKBuilt 1946 · S/N 7AC-5966 N2388ESell Mark R · Woodbury, PABuilt 1946 · S/N 7AC-5967 N2394ELaird Charles L IV · Adelanto, CABuilt 1946 · S/N 7AC-5973 N2403EDawkins William T · Huntington Beach, CABuilt 1946 · S/N 7AC-5982 N2404EDunkley Bret Y · Kotzebue, AKS/N 7AC-5983 N2406EClark Edward P · Modesto, ILBuilt 1946 · S/N 7AC-5985 N2408EVirgin Stacey · Palmer, AKBuilt 1946 · S/N 7AC-5987 N2411ER H Lindsay & Assoc Inc · Canby, ORBuilt 1946 · S/N 7AC-5990 N2416ENoack Emily B · Oshkosh, WIBuilt 1946 · S/N 7AC-5995 N2419EBranco Martin G · Wright City, MOBuilt 1946 · S/N 7AC-5998 N2420ECabelka David M · Wausau, WIBuilt 1946 · S/N 7AC-5999 N2425ECutsforth Gary L · Palmer, AKBuilt 1946 · S/N 7AC-6004 N2426EEngland Don A · Casa Grande, AZBuilt 1946 · S/N 7AC2481 N2434ERoop Robert S · Shreveport, LABuilt 1946 · S/N 7AC-6013 N2435EHaecker Howard Ivan · Canyon Lake, TXBuilt 1946 · S/N 7AC-6014 N2436ELubonovic Thomas M · New Carlisle, OHBuilt 1946 · S/N 7AC-6015 N243KJeffryes Richard B · Creswell, ORFirst renewal noticeBuilt 1946 · S/N 7AC 2710 N2440EOsteen A Keith · Brevard, NCBuilt 1946 · S/N 7AC-6019 N2451ENowakowski Donald K Trustee · Gilbert, SCBuilt 1946 · S/N 7AC-6031 N2452EDugan Ronald C · Rogers City, MIBuilt 1946 · S/N 7AC-6029 N2459EStopa Gregg · Middletown, NYBuilt 1946 · S/N 7AC-6037 N2463EGustafson David H · Kingwood, TXBuilt 1954 · S/N 7AC-6042 N2472ELow & Slow LLC · Warner Robins, GABuilt 1946 · S/N 7AC-6051 N2478EMalloy Kevin J · Mullica Hill, NJBuilt 1946 · S/N 7AC-6057 N2479EFrog Pond Aviation LLC · Sherman, TXBuilt 1946 · S/N 7AC-6058 N2481EBurtch Charles R · Phoenix, NYBuilt 1946 · S/N 7AC-6059 N2482EWischt Paul J Jr · Medina, OHBuilt 1946 · S/N 7AC-6061 N2483EStewart Emerson C Jr · Waynesville, OHBuilt 1946 · S/N 7AC-6062 N2484ETbf Llp · Bismarck, NDBuilt 1946 · S/N 7AC-6063 N2485EHar Glo Farms Inc · Anamosa, IABuilt 1946 · S/N 7AC-6064 N2486EHopwood I D · Centre, ALBuilt 1946 · S/N 7AC-6065 N2488EWhorton Garrettson W · Halstead, KSBuilt 1946 · S/N 7AC-6070 N2491EAero Applications Inc · Burley, IDBuilt 1946 · S/N 7AC-6073 N2492ETomlinson John J · Kent, WABuilt 1946 · S/N 7AC-6074 N2495EPetro Jerry R · Williamsburg, VAFirst renewal noticeS/N 7AC6077 N2498EBarnhart Bruce · Gladys, VABuilt 1946 · S/N 7AC-6080 N2503EHigginson Carl R · Merrimack, NHBuilt 1946 · S/N 7AC-6085 N2504ECapra Salvatore O · Lakeland, FLBuilt 1946 · S/N 7AC-6086 N2505ETibbetts Larry E · Lee, NHBuilt 1946 · S/N 7AC-6087 N2507EArave William L · Fresno, CARegistration revokedBuilt 1946 · S/N 7AC-6089 N2518ESankey Ira D · Sheridan, WYFirst renewal noticeBuilt 1946 · S/N 7AC-6101 N251CLLott Alan B · Columbia, SCBuilt 1946 · S/N 7AC-4693 N2520EBerke Jarett · Hanover, NHBuilt 1946 · S/N 7AC-6102 N2525ERegistration Pending · Duluth, MNRegistration pendingBuilt 1946 · S/N 7AC-1566 N2526EGrotewohl Chris · Roeland Park, KSBuilt 1946 · S/N 7AC-6108

Back to Aeronca 7AC