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.

N4397ELesh Greg A · Atwood, COBuilt 1948 · S/N 7DC52 N4434EHines Thomas J · Amsterdam, NYBuilt 1948 · S/N 7DC-68 N4452EZaragoza Justin A · Jacksonville, FLBuilt 1948 · S/N 7DC-84 N4453EMbsp Enterprises Inc · Wilmington, DEBuilt 1948 · S/N 7DC-85 N4460EHarwood Mark D · Cossayuna, NYBuilt 1948 · S/N 7DC-87 N4462EDagg Geoffrey · Wenatchee, WAS/N 7DC-88 N4479ETampa Bay Flying Club LLC · Palmetto, FLBuilt 1948 · S/N 7DC101 N4481EChambers David N · Cullman, ALBuilt 1948 · S/N 7DC-103 N4485EManly Dodson W · Fruitland Park, FLBuilt 1948 · S/N 7DC-105 N4487ESmith Ronald D · Anderson, INBuilt 1948 · S/N 7DC-72 N4493EFnf Aviation LLC · Kalamazoo, MIBuilt 1948 · S/N 7DC-108 N4498EMyers Joe A · Rush Springs, OKBuilt 1948 · S/N 7DC-116 N4504EHall Nathan M · Shepherd, MTBuilt 1948 · S/N 7DC-121 N4513EMigis James P · Shady Shores, TXBuilt 1948 · S/N 7DC-124 N4514EThomas Kevin L · Presho, SDS/N 7DC-125 N4515ELewis Charles D · Lincoln, NEBuilt 1948 · S/N 7DC-126 N4516EHenderson Beverly A · Sharon Springs, KSS/N 7DC-127 N4520EDean Hank · Texarkana, ARS/N 7DC-128 N4526EMcgill Alvin R · Joliet, MTBuilt 1948 · S/N 7DC-134 N4529ELong Tuggin D · Smithville, MOBuilt 1948 · S/N 7DC-136 N4532EFloura David P · Blackduck, MNS/N 7DC-138 N4533ETurner Rolf R · Sauk Rapids, MNS/N 7DC-139 N4536ELa Rue Carl A · Cambridge, OHBuilt 1948 · S/N 7DC-140 N4537EKyle Lara K · Clear Lake, IABuilt 1948 · S/N 7DC-141 N4548EAgaliotis Paul E · San Martin, CABuilt 1948 · S/N 7DC-147 N4567EWilliams Daniel H · Blue Springs, MOBuilt 1949 · S/N 7CCM-133 N4578EBlight Andrew J · Endwell, NYBuilt 1949 · S/N 7CCM-148 N4591ERichards S G · North Palm Beach, FLBuilt 1949 · S/N 7DC-156 N4627ENickels Steve A · Fort Peck, MTS/N 7DC-161 N4654EMakely Abraham M · Culpeper, VAS/N 7DC-167 N4711XKirby John D · San Diego, CABuilt 1947 · S/N 7AC-7038 N487DCFleming Michael P · Newberg, ORBuilt 1947 · S/N 7DC 146 N658WHHousley William M · Jasper, ALS/N 7DC-191 N8060XChance Malcolm · Folsom, CAS/N 7DC-132 N81475Helicorp LLC · Chesterfield, MOBuilt 1945 · S/N 7AC-93 N81617Ose Leroy B · Thief River Falls, MNS/N 7AC-240 N817DCEverwind Aviation LLC · Kalispell, MTBuilt 1948 · S/N 7DC81 N81803Champ 81803 LLC · Clinton, MOBuilt 1945 · S/N 7AC-426 N81927Elliott Joel C · Pacoima, CABuilt 1946 · S/N 7AC-552 N82252Adams Jimmy P · Statesboro, GAFirst renewal noticeBuilt 1946 · S/N 7AC-880 N82355Jaderborg Eric E · Lonoke, ARBuilt 1946 · S/N 7AC-987 N82609Screws Harlan D · Vernon, TXBuilt 1946 · S/N 7AC-1249 N82653Riggin Flight Service Inc · Madison, SDBuilt 1946 · S/N 7AC-1295 N83056Segura Richard J III · Henderson, TXBuilt 1946 · S/N 7AC-1712 N83066Dierker James L · Tulsa, OKBuilt 1947 · S/N 7AC-1722 N83124Gullett Samuel H · Lafayette, LABuilt 1946 · S/N 7DC-1782 N83391Abbe Thomas E · Wasilla, AKBuilt 1946 · S/N 7AC2058 N83450Fish John F · Fayetteville, GABuilt 1946 · S/N 7AC-2117 N83468Skyhawk Aero LLC · Montevideo, MNS/N 7AC-2137 N83515Chirtea John · Milton, DEBuilt 1946 · S/N 7AC-2186

Back to Aeronca 7DC