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.

N346KMitchell Flying Club Inc · Lees Summit, MOBuilt 1997 · S/N 17280064 N348CPHaddock Tracey P · Kingstree, SCBuilt 1998 · S/N 17280348 N3504PWingsleasing LLC · Wichita, KSBuilt 2001 · S/N 17281053 N3506GDelta State University · Cleveland, MSBuilt 2001 · S/N 17281054 N35077Carreno Victor A · Guaynabo, PRBuilt 2001 · S/N 17281062 N35079Wings Over Texas Holdings LLC · Denton, TXBuilt 2001 · S/N 17281061 N3508JDhs Operations LLC · Wilmington, DEBuilt 2001 · S/N 17281060 N35092Iasco Flight Training Inc · Redding, CABuilt 2001 · S/N 17281044 N3510ACrotts Aircraft Service Inc · Dodge City, KSBuilt 2001 · S/N 17281042 N3513FBeeca Flight LLC · Oviedo, FLBuilt 2002 · S/N 17281090 N3517SG & M Aircraft Inc · Wheat Ridge, COBuilt 2001 · S/N 17281083 N3517VSt Cloud State University Aero Club Inc · Saint Cloud, MNBuilt 2001 · S/N 17281082 N35230Christiansen Aviation LLC · Wilmington, DEBuilt 2001 · S/N 17281017 N3523RAviator Air Flight School LLC · Grand Prairie, TXBuilt 2001 · S/N 17281016 N35246N35246 LLC · Stuart, FLBuilt 2001 · S/N 17281031 N35249Baker Douglas · Rye, NHBuilt 2001 · S/N 17281030 N3530JChristiansen Aviation LLC · Wilmington, DEBuilt 2001 · S/N 17281010 N35367Hinds Community College · Bolton, MSS/N 17281068 N3536GGeorge'S Aviation Services Inc · Honolulu, HIBuilt 2001 · S/N 17281048 N35387Southeastern Oklahoma State University · Durant, OKBuilt 2002 · S/N 17281100 N35408Elmendorf Aero Club · Jber, AKS/N 17281081 N3540TAvcorp Holdings Inc · Jackson, MIBuilt 2001 · S/N 17281077 N3542FJet Air Inc · Iowa City, IAS/N 17281075 N3543GAmerican Aviation Inc · Brooksville, FLBuilt 2001 · S/N 17281079 N3544BAvcorp Holdings Inc · Jackson, MIBuilt 2001 · S/N 17281071 N3544GMid-Island Air Service Inc · Ronkonkoma, NYS/N 17281072 N3547RL & R Flyers LLC · Bradenton, FLS/N 17281066 N35491L&W Leasing LLC · Smyrna, TNS/N 17281069 N354ESN354es LLC · Stuart, FLBuilt 1997 · S/N 17280047 N3557EWinged Bullies LLC · Spicewood, TXS/N 17281057 N3566ASun City Aviation LLC · Davie, FLBuilt 1997 · S/N 17280021 N356ESPremier Flight Center LLC · Hartford, CTBuilt 1997 · S/N 17280051 N357ESReeno Aviation LLC · Lewisville, NCBuilt 1997 · S/N 17280007 N358ESSoutheastern Veterinary Relief Services LLC · Orange Park, FLBuilt 1997 · S/N 17280008 N360CWCentral Washington University · Ellensburg, WABuilt 1998 · S/N 17280312 N360ESEdb Air Inc · Wilsonville, ORBuilt 1997 · S/N 17280010 N361ESGrady Paul D · Reno, NVBuilt 1997 · S/N 17280011 N362ESIasco Flight Training Inc · Redding, CABuilt 1997 · S/N 17280013 N363SAN363sa LLC · Stuart, FLS/N 17280756 N364MSSkyhawk Aviation LLC · Omaha, NEBuilt 1997 · S/N 17280015 N364SAJackson Edwin W · Tampa, FLBuilt 1999 · S/N 17280757 N365ESLakewood Investments LLC · Victorville, CABuilt 1997 · S/N 17280023 N367MAMindy Limited LLC · Muscatine, IABuilt 1998 · S/N 17280649 N368ESMindy Limited LLC · Muscatine, IABuilt 1997 · S/N 17280022 N370ESPerformance Aircraft Sales Inc · Lincoln, NEBuilt 1997 · S/N 17280029 N377ESEastern Cincinnati Aviation Inc · Batavia, OHBuilt 1997 · S/N 17280086 N37JAFlying Start Aero Services LLC · Reno, NVBuilt 1997 · S/N 17280095 N37SEPacific Northwest Aircraft Leasing Inc · Meridian, IDBuilt 2001 · S/N 17281035 N381ESFixed Wing Holding Co Inc · Pembroke Pines, FLBuilt 1997 · S/N 17280081 N386ESJet Air Inc · Iowa City, IABuilt 1997 · S/N 17280106

Back to Cessna 172R