Skip to content

Registered aircraft · 683

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

N448AFBeale Air Force Base Aero Club · Beale Afb, CABuilt 1998 · S/N 17280448 N448ERAtp Aircraft 4 LLC · Wilmington, DEBuilt 1998 · S/N 17280610 N453CMUniversity Of Central Missouri · Warrensburg, MOBuilt 2000 · S/N 17280845 N454CMUniversity Of Central Missouri · Warrensburg, MOBuilt 2000 · S/N 17280846 N455EPDove Aviation 455ep LLC · Stuart, FLBuilt 1998 · S/N 17280664 N456ERSoaring 2 Success LLC · Cary, ILBuilt 1998 · S/N 17280667 N456MBDhs Operations LLC · Wilmington, DEBuilt 1997 · S/N 17280033 N457CMIasco Flight Training Inc · Redding, CABuilt 2000 · S/N 17280849 N458CMUniversity Of Central Missouri · Warrensburg, MOBuilt 2000 · S/N 17280850 N459CMIasco Flight Training Inc · Redding, CABuilt 2000 · S/N 17280851 N461CMUniversity Of Central Missouri · Warrensburg, MOBuilt 2000 · S/N 17280853 N463CMUniversity Of Central Missouri · Warrensburg, MOBuilt 2000 · S/N 17280855 N464CMUniversity Of Central Missouri · Warrensburg, MOBuilt 2000 · S/N 17280856 N465CAAtp Aircraft 4 LLC · Wilmington, DEBuilt 1998 · S/N 17280465 N465CMUniversity Of Central Missouri · Warrensburg, MOBuilt 2000 · S/N 17280857 N466CMUniversity Of Central Missouri · Warrensburg, MOBuilt 2000 · S/N 17280858 N467CMIasco Flight Training Inc · Redding, CABuilt 2000 · S/N 17280859 N468CMUniversity Of Central Missouri · Warrensburg, MOBuilt 2000 · S/N 17280860 N470KMAv Chase LLC · Kirtland, OHBuilt 1998 · S/N 17280614 N470UNew Horizon Aviation Inc · Warwick, RIBuilt 1998 · S/N 17280415 N471MRAdvanced Aviation Group LLC · Frederick, MDS/N 17281078 N474EPSunshine Holding LLC · Danbury, CTBuilt 1998 · S/N 17280616 N476SPChristiansen Aviation LLC · Wilmington, DEBuilt 1998 · S/N 17280621 N47AFL & J Aviation Inc · Atwater, CABuilt 2001 · S/N 17281041 N47GFGlobal Flight Support And Sales Inc · Tampa, FLBuilt 1997 · S/N 17280161 N480ERFlying Off Leash Aviation LLC · Daniel Island, SCBuilt 1998 · S/N 17280624 N486ERUw Flying Club Inc · Sun Prairie, WIBuilt 1998 · S/N 17280672 N493RMRaritan Valley Flying School · Princeton, NJBuilt 1999 · S/N 17280784 N497ERPlane Three Ltd · Wilmington, DEBuilt 1998 · S/N 17280673 N500GPEhg Flight LLC · Venice, CABuilt 1998 · S/N 17280500 N5059CLewis University · Romeoville, ILS/N 17281122 N509ATPollard Weldon Luke · Ardmore, OKBuilt 1998 · S/N 17280554 N50SUOhio State University · Columbus, OHBuilt 1998 · S/N 17280440 N512CTCoast Flight Training And Management Inc · San Diego, CABuilt 2005 · S/N 17281264 N5165MAl & Zal Corp · Gaylord, MIBuilt 2002 · S/N 17281092 N516CSMccullough Construction Inc · South Jordan, UTBuilt 1998 · S/N 17280428 N5178SG & M Aircraft Inc · Wheat Ridge, COBuilt 2002 · S/N 17281097 N5178USoutheastern Oklahoma State University · Durant, OKBuilt 2002 · S/N 17281098 N5178YSoutheastern Oklahoma State University · Durant, OKS/N 17281099 N51800Southeastern Oklahoma State University · Durant, OKBuilt 2002 · S/N 17281101 N5181ASoutheastern Oklahoma State University · Durant, OKBuilt 2002 · S/N 17281102 N5181BSoutheastern Oklahoma State University · Durant, OKBuilt 2002 · S/N 17281103 N51827B D Aviation LLC · Sauget, ILBuilt 2002 · S/N 17281108 N5182AIasco Flight Training Inc · Redding, CABuilt 2002 · S/N 17281106 N5190RIasco Flight Training Inc · Redding, CABuilt 2002 · S/N 17281111 N52057Redstone Arsenal Flying Activity · Redstone Arsenal, ALBuilt 2002 · S/N 17281116 N521KSKs Flying Club Inc · Manhattan, KSBuilt 1999 · S/N 17280519 N522QFFlight Training Aircraft LLC · Wilmington, DEBuilt 1997 · S/N 17280216 N5294WSonneborn Arthur Aaron · East Leroy, MIBuilt 2003 · S/N 17281186 N53020Iasco Flight Training Inc · Redding, CABuilt 2002 · S/N 17281136

Back to Cessna 172R