Skip to content

Registered aircraft · 20

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

N10448Thompson Steven R · Pauls Valley, OKS/N 7CCM-24 N10526Giarraputo Gary L · Beaumont, TXBuilt 1956 · S/N 7CCM-42 N2095ALawrence David D · Roanoke, VABuilt 1956 · S/N 7DC-329 N2762EMaynard Brent N · Hurricane, WVBuilt 1946 · S/N 7AC-6345 N367DSPetersen Gary Trustee · Walton, NEBuilt 1946 · S/N 7AC-1331 N38691Dye Benjamin L · Union Springs, NYBuilt 1946 · S/N 7AC-2369 N4019BKapellair LLC · Wickenburg, AZS/N 7CCM-62 N4507ETaylor John · Canaan, CTBuilt 1948 · S/N 7CCM-113 N4575ECraig John S Jr · Glenburn, MEBuilt 1949 · S/N 7CCM-142 N4600EPietsch Kent D · Burlington, NDBuilt 1949 · S/N 7CCM-171 N4605EAir Dakota Flite · Hettinger, NDBuilt 1949 · S/N 7CCM-175 N4610EIllies David P · Fosston, MNBuilt 1949 · S/N 7CCM-176 N4687EMaslen Holbrook · Caldwell, IDS/N 7CCM-217 N4995Stein David E · Modesto, CABuilt 1971 · S/N 10-71 N6712CHofstetter Mike T · Saint James, MOS/N 7BCM-427 N83050Paglierani Gary B · Fresno, CABuilt 1946 · S/N 7AC-1706 N83249Trieber Steven M · Casa Grande, AZBuilt 1946 · S/N 7AC-1912 N83937Edwards David E · Mount Olive, NCBuilt 1946 · S/N 7AC-2619 N83964Tesmer Air LLC · Libertyville, ILBuilt 1946 · S/N 7AC-2650 N84393Poole David W · Indianapolis, INBuilt 1946 · S/N 7AC-3088

Back to Champion 7CCM