Skip to content

Registered aircraft · 157

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

N4698ECook Bruce F · Circleville, OHBuilt 1950 · S/N 7EC-45 N4701EMacveigh Craig A · New Carlisle, OHS/N 7EC-50 N4708EEngesath David H · Duluth, MNBuilt 1950 · S/N 7EC-55 N4728EJohnson Gregory T · Stanley, NDBuilt 1951 · S/N 7EC86 N4738EDetert Bradley · Valparaiso, INBuilt 1950 · S/N 7EC-83 N4837EPfeffer William T · Amboy, MNBuilt 1959 · S/N 7EC-687 N4853ESummerfield Douglas T · Mason City, IABuilt 1959 · S/N 305 N4858ENantz William G · Raleigh, NCBuilt 1959 · S/N 7EC-691 N4865EWorld On Our Time LLC · Lewes, DEBuilt 1959 · S/N 7EC-695 N557ECAirborne One LLC · Kalispell, MTS/N 7EC-345 N567ECStaudacher Mark W · Bay City, MIBuilt 1956 · S/N 7EC-483 N56LHSchunk Luke C · Lake Tomahawk, WIBuilt 1956 · S/N 7EC390 N607ECEverts Air Service Inc · Sarasota, FLBuilt 1959 · S/N 7EC-713 N61980Guerin Bryant J · West Ossipee, NHS/N 7EC-703 N627ECGormon Michael L · Colville, WAS/N 7EC 767 N63394Perkins Robert A · New Richmond, WIS/N 694 N70824Heidebrink James M · Bloomington, ILBuilt 1959 · S/N 7EC-377 N715SSS & N Aviation Inc · Wilmington, DEBuilt 1956 · S/N 7EC380 N7400BHartmann Jeffrey N · Chico, CABuilt 1956 · S/N 7EC-430 N7401BSherman David B · Readfield, MEBuilt 1956 · S/N 7EC-431 N7402BRoberts Christopher J · Andover, KSBuilt 1956 · S/N 7EC-432 N7405BDennis Rick L · Poughkeepsie, NYBuilt 1956 · S/N 7EC-437 N7406BKraft Tyrone H · Timber Lake, SDS/N 7EC-438 N7412BGonzales Donald M · Columbia Station, OHBuilt 1956 · S/N 7EC-444 N7417BNelsonmiguel E · Lake Stevens, WAS/N 7EC-451 N7420BFreeman James L · Decatur, GABuilt 1956 · S/N 7EC-454 N7421BBrowns Valley Aviation LLC · Utica, KYBuilt 1956 · S/N 7EC-455 N7423BSiglin Shaw D · Wellsboro, PABuilt 1956 · S/N 7EC-461 N7425BGreen William D · Fairbanks, AKBuilt 1956 · S/N 7EC-463 N7426BOdlozil Henry W Sr · Ennis, TXBuilt 1956 · S/N 7EC-464 N7427BBouton Glenn A · Kasilof, AKBuilt 1956 · S/N 7EC-465 N7428BGrasshopper L-16 LLC · Greeley, COS/N 7EC-466 N7430BBugbee Frank S Jr · Schwenksville, PABuilt 1956 · S/N 7EC-468 N7432BSmith David C · Malott, WABuilt 1956 · S/N 7EC-470 N7433BRegistration Pending · Beebe, ARRegistration pendingBuilt 1956 · S/N 7EC-471 N7436BLooper Kyle · Las Vegas, NVBuilt 1956 · S/N 7EC-474 N7438BLampe Jared Joseph · Turner, MIS/N 7EC477 N7439BWoyte John F · Eagle River, AKS/N 7EC-478 N7440BGoethel Eric D · Hampton, NHBuilt 1956 · S/N 7EC-485 N7447BCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1956 · S/N 7EC-496 N7451BBone Mitchell T · Calhoun, GABuilt 1956 · S/N 7EC-500 N7452BOesper Peter F · Taos, NMBuilt 1956 · S/N 7EC501 N7455BRichards Troy L · Saint Jo, TXBuilt 1956 · S/N 7EC-504 N7459BSchulert Philip J · Lebanon, TNFirst renewal noticeBuilt 1956 · S/N 7EC-508 N7462BKrumbine David A · Lebanon, PABuilt 1956 · S/N 7EC-520 N7472BAero-Mobil Inc · Wilmington, DEBuilt 1956 · S/N 7EC-530 N7474BBeausoleil Randy L · Livingston, TXS/N 7EC-532 N7477BHuey Gale R · Celeste, TXS/N 7EC-535 N7478BHenderson James L · Gordon, TXBuilt 1956 · S/N 7EC-536 N7481BElstner Peter T · Prineville, ORBuilt 1957 · S/N 7EC-547

Back to Champion 7EC