Skip to content

Registered aircraft · 175

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

N66330Yon Joseph W Jr · Pendleton, SCS/N 47-833 N66356Noble Scott W · Fort Wayne, INBuilt 1947 · S/N 7BCM-206 N66361Walker Joy S · Concord, GAS/N 7BCM-245 N66580Wyatt Mary Ellen Personal Representative · Weirsdale, FLS/N 47-847 N66581Big Bend Soaring Inc · Port Orange, FLS/N 47-943 N66582Ulmer Michael L · Nolensville, TNS/N 7BCM235 N66583Johnson Timothy D · Chapel Hill, NCBuilt 1947 · S/N 7BCM-236 N6702CDebaun Curtis A III · Terre Haute, INS/N 7BCM488 N6704CCook Jon · Valencia, CAS/N 7BCM-495 N6705CSchneider James Stephen · Olympia, WAS/N 7BCM-503 N68588Shipman Jared K · Bismarck, MOS/N 7BCM-254 N68593Dunlap Russell Morgan · Palmer, AKFirst renewal noticeBuilt 1956 · S/N 7BCM-9 N69968Henrikson Peter R · Fort Worth, TXBuilt 1952 · S/N 7BCM-466 N7096JHutfless Roger P · Davenport, WABuilt 1947 · S/N 7BCM-127 N75365Matthews John D · Land O Lakes, FLS/N 47-825 N75369Parker Jeffrey D · Chelsea, ALBuilt 1947 · S/N 47-965 N75373Prough Steve P · Des Moines, IAS/N 47-1239 N777EGSherwood Thomas R · Beverly, MABuilt 1956 · S/N 7BCM-2 N814NG7ac Aviation LLC · Fort Worth, TXBuilt 1947 · S/N 7BCM-28 N81578Wikstad Herulf L · Nevada City, CABuilt 1945 · S/N 7AC-197 N81607Price Donald N · Houston, TXBuilt 1945 · S/N 7AC-229 N81670Buckshot Aviation LLC · Greenville, MSBuilt 1945 · S/N 7AC-288 N81686Frost David R · Utopia, TXBuilt 1945 · S/N 7AC-305 N81823Mcgill Melissa M · Joliet, MTBuilt 1946 · S/N 7AC-446 N81920Crooke Michael J · Charlotte, NCS/N 7AC-545 N82061Krynik Mitchell G · Granbury, TXBuilt 1946 · S/N 7AC-687 N82106Morrison Lillian M · Port Townsend, WABuilt 1946 · S/N 7AC-732 N82150Houghton Robert E · North Ferrisburgh, VTBuilt 1946 · S/N 776 N82158Noble Wendell · Nicholasville, KYBuilt 1946 · S/N 7AC-784 N82199Syverson Michael B · Waubun, MNBuilt 1946 · S/N 7AC-827 N82572Debt Flying LLC · Holland, MIBuilt 1946 · S/N 7AC-1209 N82657Irwin Terry H · Gordonille, MOBuilt 1946 · S/N 7AC-1299 N82693Gould Allison L · Antrim, NHBuilt 1946 · S/N 7AC-1338 N82745Foley Michael W · Galt, CABuilt 1946 · S/N 7AC-1392 N82830Savage David E · American Falls, IDBuilt 1946 · S/N 7AC-1477 N82845Weigel John C · Natick, MAS/N 7AC-1495 N82LRuppert Russell E · Dover, PABuilt 1946 · S/N 7AC-1571 N83083Melvin John N · Bryan, TXBuilt 1946 · S/N 7AC-1736 N83195Howe Adam J · Shaftsbury, VTBuilt 1946 · S/N 7AC-1856 N83521Lequire Wayne A · Maryville, TNBuilt 1946 · S/N 7AC-2194 N83542Vinyard Herbert O Jr · Hammond, LABuilt 1946 · S/N 7AC-2218 N83627Flagg Robert F · Castro Valley, CABuilt 1946 · S/N 7AC-2305 N83673Everson Harold E · Granville, NDFirst renewal noticeBuilt 1946 · S/N 7AC-2351 N83927Denormandie Jacob J · South Paris, MEBuilt 1946 · S/N 7AC-2610 N83971Kepler Jason M · Wasilla, AKBuilt 1946 · S/N 7AC-2657 N84120Saylor Kasey · Searcy, ARS/N 7AC-2807 N84149Bower Kevin R · Oldenburg, INBuilt 1946 · S/N 7AC-2833 N84197Short Michael J · Independence, ORS/N 2885 N84405Kroenlein Donald G · Moweaqua, ILBuilt 1946 · S/N 7AC-3100 N84443Registration Pending · Wheatland, CARegistration pendingBuilt 1946 · S/N 7AC-3143

Back to Aeronca 7BCM