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.

N10525C&L Aviation LLC · London, WIBuilt 1948 · S/N 48-464 N1088ESmith Mark E · Lakeville, NYS/N 7AC-4641 N1111TSchlup John R · Booneville, ARBuilt 1946 · S/N 7AC-3919 N1141EGuttormson Gene A · Georgetown, MNBuilt 1946 · S/N 7AC-4697 N1233EWieman Dianne L · Marion, TXBuilt 1946 · S/N 7AC-4791 N1522FMatray Blake E · Fairbanks, AKS/N 7AC-1071 N1559EThornton Brothers Inc · Lincoln, MEBuilt 1946 · S/N 7AC-5122 N1562EStenson Ryan M · Newton, NHS/N 7AC-5125 N1865EWhite Duane A · Wappingers Falls, NYBuilt 1946 · S/N 7AC-5432 N2053EFerwerda Beech LLC · Fremont, NHBuilt 1946 · S/N 7AC-5623 N2324EBrown Craig D · Stanton, MIBuilt 1946 · S/N 7AC5901 N2512BStikeleather Caro Anne · Arlington, VAS/N 7CCM-98 N2513BKimble Allen J · Plano, TXS/N 7CCM-82 N2527BRegistration Pending · Wasilla, AKRegistration pendingS/N 48-507 N2558BLandstrom Derek C · Thomaston, GAS/N 7CCM-34 N2559BHelderman Justin W · Newton, NCBuilt 1948 · S/N 7CCM-90 N2562CDerrick Jeffery R · New Richmond, WIS/N 7CCM-75 N2669EScrews Harlan D · Vernon, TXBuilt 1948 · S/N 7CCM-111 N2848EBeckhoff Allen C · Greybull, WYBuilt 1946 · S/N 7AC-6431 N2959EWillson Gary N · Duvall, WAS/N 7AC-6545 N308EDStevens Mike · Duluth, MNBuilt 1946 · S/N 7AC2952 N3106EMiddleline Aviation Inc · Ballston Spa, NYBuilt 1946 · S/N 7AC-6705 N3109EDexter Fred H · Live Oak, FLBuilt 1946 · S/N 7AC-6706 N33PRude David L · Raleigh, NCBuilt 1946 · S/N 7AC-2801 N3690ELowe David M · Sacramento, KYBuilt 1947 · S/N 7AC-6996 N37618Eide Larry D · Minot, NDBuilt 1948 · S/N 7DC-150 N38SMTieder Sheldon D · Rhinebeck, NYBuilt 1946 · S/N 7AC-931 N4299EViggiano Louis Jr · San Antonio, TXBuilt 1948 · S/N 7DC-113 N4373ETomczak Darrie-Jo L · So Int'L Falls, MNBuilt 1948 · S/N 7DC-32 N4435EWindjue Bryan · Jamestown, NDS/N 7DC-69 N4446EGreer James E · Summit Point, WVBuilt 1948 · S/N 7CCM-103 N4451EMock David H III · Burleson, TXS/N 7CCM-105 N4531EJohnson Donald B · Lino Lakes, MNBuilt 1948 · S/N 7CCM-118 N4559EPansier Donald J · Green Bay, WIBuilt 1949 · S/N 7CCM-126 N4563EPowelson Mark · Pataskala, OHS/N 7CCM-129 N4568EHightower Jerry C · Boyd, TXBuilt 1949 · S/N 7CCM-134 N4569EStanger Joseph R · Willow, AKBuilt 1949 · S/N 7CCM-136 N4571EGreen William D · Fairbanks, AKBuilt 1949 · S/N 7CCM-137 N4573ECheatum Jamie K · Salina, KSBuilt 1949 · S/N 7CCM-139 N4574ECarlisle Kevin · Sheridan, INBuilt 1947 · S/N 7CCM-140 N4583ECheatham Glenn W J · Hot Springs, SDBuilt 1949 · S/N 7CCM-152 N4586EAinslie James A · Richfield Springs, NYBuilt 1949 · S/N 7CCM-158 N4597EGormon Michael L · Colville, WABuilt 1949 · S/N 7CCM-166 N4602EBring Jesse L · Galesburg, NDBuilt 1949 · S/N 7CCM-172 N4608ECovey Keith L · San Angelo, TXBuilt 1949 · S/N 7CCM-181 N4609EFinseth Lowell J · Fountain, MNBuilt 1949 · S/N 7CCM-179 N4624EDickens David B · Americus, GAS/N 7CCM-193 N4629ESmith Kevin J · Littlefield, TXS/N 7CCM-196 N4630EBokma Alan S · East Wenatchee, WABuilt 1949 · S/N 7CCM-197 N4634EGhafouri Carly · Murrieta, CABuilt 1949 · S/N 7CCM-200

Back to Aeronca 7CCM