Skip to content

Registered aircraft · 121

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

N1025ERatzin Brendan · Pahrump, NVBuilt 1946 · S/N 7AC-4576 N1026ELampros James C · Salem, ORBuilt 1946 · S/N 7AC-4577 N10314Sweitzers Fencing Co · Felton, PABuilt 1946 · S/N 7AC-5798 N10508Loffert George U Jr · Killeen, TXS/N 7DC-502 N1116Lauer Michael J · Kerrville, TXBuilt 1947 · S/N 7BCM-282 N1121Dexter Fred H · Live Oak, FLBuilt 1947 · S/N 47-1267 N1133ESpear Marie C · Salem, WIBuilt 1946 · S/N 7AC-4690 N1208EMorgan Carl D · Wheeling, MOBuilt 1946 · S/N 7AC-4765 N1281EGlanz William L · Central, AKBuilt 1946 · S/N 7AC-4841 N1406EJeffries Joy L · Louisville, KYBuilt 1946 · S/N 7AC-4968 N14499Cox Alex E · Watson, ARBuilt 1948 · S/N 7DC42 N1528EBeasley Silas W · Spokane, WABuilt 1946 · S/N 7AC-5091 N1600EZens Armon Francis · Redfield, SDBuilt 1946 · S/N 7AC-5165 N1668EDehn-Reynolds Mary M · Searsport, MEBuilt 1946 · S/N 7AC-5234 N1739EWilson Bobby R · Kathleen, GABuilt 1946 · S/N 7AC-5306 N1834EHurley G Jay · Shepherdstown, WVBuilt 1946 · S/N 7AC-5401 N2052EHarmon David S · Buxton, MES/N 7AC-5622 N2171EShelton Jeffrey A · Columbus, INBuilt 1946 · S/N 7AC-5742 N2278EBrock Harvey J · Hawthorne, FLBuilt 1946 · S/N 5852 N2304EHeitz John · Manvel, TXBuilt 1946 · S/N 7AC-5878 N2383ELord Edward J · North Conway, NHBuilt 1946 · S/N 7AC-5962 N2612EHolman Russell H · Duluth, MNBuilt 1946 · S/N 7AC-6194 N2673EMarino Timothy J · Cortland, OHBuilt 1946 · S/N 7DC-4499 N2736ENicholls Paul R · Lowell, MIBuilt 1946 · S/N 7AC-6317 N2768EPadgett Kenneth W · Cortland, OHBuilt 1946 · S/N 7DC-6351 N2826EBennett Randy A · Hickman, CABuilt 1946 · S/N 7AC-6409 N2878EHumphrey Daryle C · Graford, TXS/N 7DC-6461 N2991EPlayter Bud W · Greenville, MIBuilt 1946 · S/N 7AC-6578 N3091ECw & D Investment Inc · Riverview, FLBuilt 1946 · S/N 7AC-6680 N3094EJowett David J · Odessa, MOBuilt 1946 · S/N 7AC-6683 N3213ERedmon Ronald D · Crestwood, KYS/N 7AC-6747 N33JTTuchscherer James D · Waterloo, IABuilt 1946 · S/N 6291 N3415EMerkle Larry · Clarence Center, NYBuilt 1947 · S/N 7AC-6823 N3798BPintamo Michael J · Longmont, COS/N 7DC-50 N3923AMason William R · Putnam, CTBuilt 1947 · S/N 47-1214 N3928PAtkinson William Gary · Canton, NYBuilt 1947 · S/N 7DC-38 N4009BOoi Lucy M · Catlett, VAS/N 7BCM-380 N4018BAven Michael R · Yorba Linda, CAS/N 7BCM-337 N42344Beck Doug · Bloomington, MNBuilt 1945 · S/N 7AC-409 N4305EKlos Jeff · Plevna, MTBuilt 1947 · S/N 7BCM-369 N4316ELandry Roger W · Alstead, NHBuilt 1948 · S/N 7DC-26 N4348EBarts Flying Service Inc · Storm Lake, IABuilt 1948 · S/N 7DC-9 N4349ECook David A · Castleton, NYBuilt 1948 · S/N 7DC-10 N4351EDetroit Lakes Aviation Inc · Detroit Lakes, MNS/N 7DC-12 N4352EJohnson Gary I · Minot, NDS/N 7DC-13 N4357ESmith William H · Moultrie, GABuilt 1948 · S/N 7DC-18 N4360EAnderson John E · Shell, WYS/N 7DC-21 N4362EFloura David P · Blackduck, MNBuilt 1948 · S/N 7DC-23 N4375EN4375e LLC · Erie, COBuilt 1948 · S/N 7DC-35 N4396EBudziszewski Mike S · Strandquist, MNBuilt 1948 · S/N 7DC-51

Back to Aeronca 7DC