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.

N20481Lesage Robert E · Puyallup, WABuilt 1973 · S/N 17261324 N20484North Central Aircraft Sales · Tioga, NDBuilt 1973 · S/N 17261327 N20486Humbert Delmar Alan · Briones, CABuilt 1973 · S/N 17261329 N20487Point To Point Air LLC · Arlington, WAS/N 17261330 N20488Aurora 17 Holdings LLC · Aurora, ORBuilt 1973 · S/N 17261331 N20490Aarow Aircraft Leasing LLC · Mcminnville, ORS/N 17261333 N20494Aviation Group Jmj Inc · Callahan, FLS/N 17261337 N20496Hess Garrett J · Fullerton, CABuilt 1973 · S/N 17261339 N204CMMorgan Kenneth J · Norridgewock, MEFirst renewal noticeBuilt 1975 · S/N 17265224 N204SRSunrise Aero Inc · Ocala, FLS/N 17262822 N20500Duflo Jeffrey T · Lowville, NYBuilt 1973 · S/N 17261343 N20503Vyatkin Denis · Sacramento, CABuilt 1973 · S/N 17261346 N20504Yoanna Flight School Inc · Fort Myers, FLNon-citizen corporation, flight hours not reportedS/N 17261347 N20512Fly Guys LLC · Cross Lanes, WVBuilt 1973 · S/N 17261350 N20516Arndt Scott D · Pearland, TXBuilt 1973 · S/N 17261354 N20520Treats Aviation Inc · Enumclaw, WABuilt 1973 · S/N 17261358 N20521N20521 LLC · Wilmington, DEBuilt 1973 · S/N 17261359 N20526Chester Steven G · Aurora, COBuilt 1973 · S/N 17261363 N20528Vfr Aviation LLC · Clayton, NYBuilt 1973 · S/N 17261365 N20531Fuller David C · Vinton, TXBuilt 1973 · S/N 17261368 N20532Superhawk Inc · Marcell, MNS/N 17261369 N20533Big Sky Aviation LLC · El Campo, TXBuilt 1973 · S/N 17261370 N20541University Of Alaska Anchorage · Anchorage, AKS/N 17261378 N20542Roberge Patrick R · Columbus, OHBuilt 1973 · S/N 17261379 N20543Sierra Delta Aircraft LLC · Kalispell, MTBuilt 1973 · S/N 17261380 N20544Walla Walla University · College Place, WABuilt 1973 · S/N 17261381 N20552Robertson William J · Athens, TNBuilt 1973 · S/N 17261387 N20553Green Jeffrey L · Herrick, ILBuilt 1973 · S/N 17261388 N20554Danekas Inc · Colville, WABuilt 1973 · S/N 17261389 N20555Buiqui Aerospace Corp · Kissimmee, FLBuilt 1973 · S/N 17261390 N20559Wings Over Texas Holdings LLC · Denton, TXBuilt 1973 · S/N 17261393 N20560Kirkeby Dean A · Clark, SDBuilt 1973 · S/N 17261394 N20565Waters Aero Marine Inc · South Thomaston, MEBuilt 1973 · S/N 17261398 N20567Msl Services Inc · Michiana Shores, INBuilt 1973 · S/N 17261400 N2056EFeauto Aviation LLC · Saint Cloud, FLBuilt 1973 · S/N 17261399 N20571Carver Clarence K · Lutz, FLBuilt 1973 · S/N 17261404 N20575Desanti Arthur Wallace · Ramona, CABuilt 1973 · S/N 17261407 N20589Brown Jennifer L · Vancouver, WABuilt 1973 · S/N 17261421 N20590Treadwell Donald E · San Angelo, TXBuilt 1973 · S/N 17261422 N20591Vogt Roger D · Visalia, CABuilt 1973 · S/N 17261423 N20592Iowa Lakes Community College · Estherville, IABuilt 1973 · S/N 17261424 N20593Nieto Marcelo F · Mastic, NYBuilt 1973 · S/N 17261425 N20600Occupational Health Services · Green Bay, WIBuilt 1973 · S/N 17261432 N20601Gilfert James M · Sunbury, PABuilt 1973 · S/N 17261433 N20604Leffler Paul E · Churubusco, INBuilt 1973 · S/N 17261434 N20606Vander Roest Raymond · Scotts, MIBuilt 1973 · S/N 17261436 N20612Bentley Drive LLC · Anchorage, AKBuilt 1973 · S/N 17261440 N20613Taber Carl L · Trumansburg, NYBuilt 1973 · S/N 17261441 N20616Mcconnell Group LLC · Edwardsville, ILBuilt 1973 · S/N 17261442 N20618Aerospatial LLC · Selah, WAS/N 17261443

Back to Cessna 172M