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.

N7485BRaab Travis C · Clinton, OKBuilt 1956 · S/N 7EC-484 N7487BMiller Timothy J · Hutchinson, MNS/N 7EC-488 N7488BMorrow Larry A · Dunnellon, FLBuilt 1957 · S/N 7EC-550 N7489BLumley John W · Boynton Beach, FLBuilt 1957 · S/N 7EC-551 N7490BPeacock David W · North Bennington, VTBuilt 1957 · S/N 7EC-552 N7492BBenson Airport Association Inc · Shoreview, MNBuilt 1957 · S/N 7EC-558 N7493BAlwine Joshua L · Chewelah, WAS/N 7EC-559 N7494BBowden Terry L · Moody, TXS/N 7EC-560 N7506BDoeden Bridger J · Miles City, MTBuilt 1957 · S/N 7EC-571 N7507BSalzman Michael · Milford, NHBuilt 1957 · S/N 7EC-574 N7520BGreen William D · Fairbanks, AKBuilt 1957 · S/N 7EC-585 N7521BBarnick Ryan E · Montpelier, NDBuilt 1957 · S/N 7EC-591 N7524EWaterbury Farms · Gridley, CABuilt 1958 · S/N 7EC-669 N7525EJennings Shawn T · Chetek, WIBuilt 1958 · S/N 7EC-670 N7555ERegistration Pending · Eagle River, AKRegistration pendingBuilt 1958 · S/N 7EC-674 N7574BHuey Andrew G · Fulton, MOBuilt 1957 · S/N 7EC-613 N7577EOstrich James T · Ocala, FLBuilt 1958 · S/N 7FC-265 N7583BGodin David M · Levant, MEBuilt 1957 · S/N 7FC-86 N7588BHenderson William Gary · Lake Worth, TXS/N 7EC-617 N7592BHotvedt Kyle T · Waupaca, WIBuilt 1961 · S/N 7EC-619 N7593BCarhart Thomas M · Galesville, WIBuilt 1957 · S/N 7EC620 N7685EDougherty Jeff D · Connell, WAFirst renewal noticeS/N 7EC-664 N781DDJp Aero Holdings Inc · Carson City, NVS/N 7EC-553 N793BPlumhoff Uwe E · La Center, WAS/N 7EC-647 N80461Bremer Wilfred P · Madison, WIS/N 7EC743 N8511ERichter Von E · Climax, GABuilt 1959 · S/N 7EC-700 N8537EHoech Neal L · Sandpoint, IDBuilt 1959 · S/N 7FC-343 N8599EPengilly Sky LLC · Ellicottville, NYBuilt 1959 · S/N 7FC-365 N8739HShaw Brian W · Bemidji, MNBuilt 1960 · S/N 7EC-729 N8910RBatto Jeannie L · Madison, INBuilt 1959 · S/N 7EC-716 N8936RHilbert Robert C · Marengo, ILBuilt 1960 · S/N 7JC9 N8951RGardner John B · Arlington, INBuilt 1960 · S/N 385 N8969RRutland Aviation Service Inc · Tifton, GABuilt 1960 · S/N 7EC-728 N8970RMerrell Susan E · Midland, MIBuilt 1960 · S/N 7EC-730 N8973RDilliha Steve G · Russellville, KYBuilt 1960 · S/N 14 N8988RYoung Andrew J · Eagle River, AKBuilt 1960 · S/N 7EC-732 N9000BHanna Ryan D · Berthold, NDBuilt 1957 · S/N 7EC-623 N9005BSchorsch Cary J · Franksville, WIBuilt 1957 · S/N 7EC-630 N9022BMorris Nicholas R · Palmer, AKBuilt 1957 · S/N 7EC-634 N9035BHewitt Robert J · Ringwood, NJBuilt 1958 · S/N 7EC-636 N9047BBooker Lisa M · Coeur D Alene, IDBuilt 1958 · S/N 7EC-639 N9049FMiller Glenn E · Selma, CAS/N 7EC 404 N9068BTherriault Charles W · Auburn, NHBuilt 1958 · S/N 7EC-644 N9076BBcm Consulting Inc · Wilmington, DEBuilt 1958 · S/N 7FC-160 N9099BLazzaro Michael · Santa Clarita, CABuilt 1958 · S/N 7EC-648 N9721NGmk Aviation LLC · Brighton, MIS/N 661 N9813YBlanshan Jay Victor · Alexandria, MNBuilt 1960 · S/N 7EC-735 N9836YHaughee Jared · Warsaw, INBuilt 1960 · S/N 7EC-738 N9852YMingo Daniel J Trustee · Wasilla, AKBuilt 1960 · S/N 413 N9868BRobbins Patrick D · Yakutat, AKS/N 7EC-656

Back to Champion 7EC