Skip to content

Registered aircraft · 3,572

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

N21732Air Puerto Rico Corp · Aguadilla, PRBuilt 1974 · S/N 17263997 N21741Boniek Martin J · Glennallen, AKBuilt 1974 · S/N 17263998 N21743Childers Brian L · Edgemont, SDBuilt 1975 · S/N 17263999 N21745Bellingham Aviation Services LLC · Bellingham, WABuilt 1974 · S/N 17264000 N21747N21747 Lc · Wichita, KSBuilt 1974 · S/N 17264002 N21754Sale Reported · Kalispell, MTSale reportedBuilt 1974 · S/N 17264005 N21757Olson Terry L · Rapid City, SDBuilt 1974 · S/N 17264007 N21764Blue Sky Flyers Inc · Evans, COBuilt 1974 · S/N 17264010 N21769Overseas Aviation Inc · Wilmington, DEBuilt 1974 · S/N 17264013 N21774Miller William A · Wallkill, NYS/N 17264016 N21785Dibiaso Thomas F · Mount Laurel, NJBuilt 1974 · S/N 17264018 N21791Colson Kevin A · Andover, KSBuilt 1974 · S/N 17264021 N21799Brownell John P Jr · Prattville, ALBuilt 1974 · S/N 17264025 N21804Sharpe Alexander F · Camarillo, CABuilt 1974 · S/N 17264026 N21809Eckerson Dean H · Benicia, CABuilt 1974 · S/N 17264028 N21819Middlesex Aviation Partners LLC · Bellingham, MABuilt 1974 · S/N 17264029 N21840Erickson Arnold F · Devils Tower, WYBuilt 1974 · S/N 17264031 N21841Erlinger Ronald W · Wickenburg, AZBuilt 1974 · S/N 17264032 N21878Lie Chris E · Kotzebue, AKBuilt 1974 · S/N 17264038 N21887Gilheany Robert V · Hicksville, NYBuilt 1974 · S/N 17264039 N21893Western Territory Flyers LLC · Fairfax, CABuilt 1974 · S/N 17264040 N218PPSumrell James E III · Bumpass, VABuilt 1976 · S/N 172-67520 N218RARozo Jhon B · Orlando, FLBuilt 1975 · S/N 17265450 N21950Cousins Mark T · Portland, ORS/N 17264046 N21956Lake Elmo Flyers LLC · Vadnais Heights, MNBuilt 1974 · S/N 17264048 N22034Robertson David L · Ray, MIBuilt 1974 · S/N 17264052 N22080Sale Reported · Las Vegas, NVSale reportedS/N 17264053 N220NYCa Aviation 172 LLC · Santa Barbara, CABuilt 1974 · S/N 17263763 N22101Propwash Aviation LLC · Midland, MIBuilt 1974 · S/N 17264055 N221KLMather Don · Sandusky, OHBuilt 1973 · S/N 17261348 N221MFWings Over Texas Holdings LLC · Denton, TXBuilt 1976 · S/N 17267380 N221SMMccain Stephen M · Columbia, MSBuilt 1976 · S/N 17267274 N22205Venaleck Joan · Concord Township, OHBuilt 1974 · S/N 17264058 N22230Paulsen Bryant A · Lynden, WABuilt 1974 · S/N 17264059 N22271Ps N22271 LLC · Green Bay, WIBuilt 1974 · S/N 17264061 N222BVBb Air LLC · Chesapeake, VABuilt 1975 · S/N 17264997 N22395Morrison Donald D · Santa Clarita, CABuilt 1974 · S/N 17264063 N22429Johnson Dustin W · Puyallup, WABuilt 1974 · S/N 17264064 N22479Robinson Paul C · San Francisco, CABuilt 1974 · S/N 17264066 N22598Dimler Travis M · Alpine, TXBuilt 1974 · S/N 17264071 N225MHMissall Zoe S · Ontario, NYBuilt 1974 · S/N 17263156 N22689Ridge View Aviation LLC · Napanoch, NYBuilt 1974 · S/N 17264073 N226CAChoice Aviation LLC · Hamilton, MTBuilt 1976 · S/N 17266762 N226JAXin Han Aviation LLC · Atwater, CABuilt 1976 · S/N 17266688 N2274PAvaero LLC · Worthington, OHBuilt 1973 · S/N 17261637 N22752Flying Tigers Flight School Ltd · Houston, TXBuilt 1974 · S/N 17264075 N22754Gomez Abigail S · Carlsbad, CABuilt 1974 · S/N 17264076 N228WBSnell Jeffrey D · Inver Grove, MNBuilt 1974 · S/N 17263032 N22905Yokota Flight Training Center · Apo, APBuilt 1974 · S/N 17264078 N22964Straight Flight Aviation LLC · Goliad, TXS/N 17264079

Back to Cessna 172M