Skip to content

Registered aircraft · 91

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

N4635EUchimoto Daniel Y · Fayetteville, WVBuilt 1949 · S/N 7CCM-202 N4642ESeleg Jonathan · Rosebud, MTBuilt 1949 · S/N 7CCM-208 N4643EScheff David A · Marcell, MNBuilt 1949 · S/N 7CCM-209 N4703ERittberger Dustin A · Fairburn, SDBuilt 1950 · S/N 7CCM-219 N4723EAddington James T · Denton, TXBuilt 1950 · S/N 7CCM-224 N4733EBecker Mark · Bismarck, NDS/N 7CCM-226 N4741EDemars Dale Anthony · Remer, MNBuilt 1951 · S/N 7CCM-225 N5556JLust Troy A · Humeston, IABuilt 1948 · S/N 7CCM-201 N6020VWiethoff Kent · Fairfax, MNBuilt 1946 · S/N 7AC-1125 N6039VDykstra Wayne · Pipestone, MNS/N 47-940 N6058CWeaver Douglas L · Kasilof, AKBuilt 1947 · S/N 7BCM-416 N6085VObrien Stephen F · Manley, AKBuilt 1948 · S/N 7CCM-36 N6420CSloan Donald W · Dover, DES/N 7BCM-499 N6436CUnsicker Thomas D · Chimacum, WAS/N 7CCM-72 N654JSSass James Louis Jr · Abilene, TXBuilt 1948 · S/N 7CCM-76 N65891Cone John M · Conyers, GAS/N 7CCM-16 N6710CNeto Robert A · Greenwood, FLBuilt 1948 · S/N 7CCM-69 N6714CHolsclaw Ralph J · Woodland, CABuilt 1960 · S/N 7CCM-64 N71DGDorrance Stephen H · Livingston, MTS/N 7AC2540 N81577Juhl Wilbur D · Roundup, MTBuilt 1945 · S/N 7AC-196 N81714Linenberger Darrell W · Berryton, KSBuilt 1945 · S/N 7AC-333 N81875Suits Thomas L · Tulsa, OKS/N 7AC-498 N82265Pike Marsha L · Reno, NVBuilt 1946 · S/N 7AC-893 N82485Strom Kerry · Portal, NDBuilt 1946 · S/N 7AC-1122 N825225 Pm Inc · Nampa, IDBuilt 1946 · S/N 7AC-1159 N83088Merrell Robert H · Farmington, NHBuilt 1946 · S/N 7AC-1743 N83129Murray Richard H · Celina, OHBuilt 1946 · S/N 1787 N83387Goodwin Richard L · Northfield, MNBuilt 1946 · S/N 7AC-2054 N83414Higgins Bennett P · Brewer, MEBuilt 1946 · S/N 7AC-2082 N83711Cameron Thomas J · Stanchfield, MNBuilt 1946 · S/N 7AC-2389 N83883Snell Gary A · Dresden, MEBuilt 1946 · S/N 7AC-2564 N83919Harris Martin J · Ocklawaha, FLBuilt 1946 · S/N 7AC-2600 N84059Lsa Flight LLC · Louisville, KYBuilt 1946 · S/N 7AC-2746 N84244Campbell Stephen C · Millinocket, MEBuilt 1946 · S/N 7AC-2936 N84669James Dennis · Pleasant Grove, CAS/N 3380 N84773Meidahl Stephen O · Clinton, MEBuilt 1946 · S/N 7AC-3487 N85065Wade Timothy K · Roanoke, TXBuilt 1946 · S/N 7AC-3792 N85091Brutlag Paul D · Wendell, MNBuilt 1946 · S/N 3833 N85173Ellis Jayson A · Benson, NCBuilt 1946 · S/N 7AC-3905 N85533Schutze Curt K · Knoxville, TNBuilt 1946 · S/N 7AC-4273 N9881Conaway Byron Richard · Savannah, TNS/N 7CCM-79

Back to Aeronca 7CCM