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.

N5312KDelta State University · Cleveland, MSBuilt 2003 · S/N 17281143 N53143Delta State University · Cleveland, MSBuilt 2003 · S/N 17281145 N5314RDelta State University · Cleveland, MSBuilt 2003 · S/N 17281144 N5318GBoard Of Trustees Of Southern Illinois University · Murphysboro, ILBuilt 2003 · S/N 17281155 N531LGMills Daniel L · Manchester, MIBuilt 1997 · S/N 17280056 N5327VSouthern Illinois University · Murphysboro, ILBuilt 2003 · S/N 17281151 N532HFJet Air Inc · Iowa City, IABuilt 2000 · S/N 17280836 N5330UBoard Of Trustees Of Southern Illinois University · Murphysboro, ILFirst renewal noticeBuilt 2003 · S/N 17281152 N53340N53340 LLC · Boynton Beach, FLBuilt 2003 · S/N 17281160 N5334UBoard Of Trustees Of Southern Illinois University · Murphysboro, ILBuilt 2003 · S/N 17281156 N5335GBoard Of Trustees Of Southern Illinois University · Murphysboro, ILBuilt 2003 · S/N 17281158 N53372Clover Park Technical College · Lakewood, WABuilt 2003 · S/N 17281170 N53417Eastern Cincinnati Aviation Inc · Batavia, OHBuilt 2003 · S/N 17281162 N5342QBoard Of Trustees Of Southern Illinois University · Murphysboro, ILBuilt 2003 · S/N 17281153 N534DDVan Gasse Randall M · Norway, MIBuilt 1998 · S/N 17280323 N534HFSun Aircraft Management LLC · Ormond Beach, FLBuilt 2000 · S/N 17280832 N5353RSouthern Illinois University · Murphysboro, ILBuilt 2003 · S/N 17281157 N5355FFlight School Of Gwinnett Inc · Lawrenceville, GABuilt 2003 · S/N 17281166 N5355WN5355w Partners LLC · Lehi, UTBuilt 2003 · S/N 17281167 N535HFPars Avn Corp · Wilmington, DEBuilt 2000 · S/N 17280926 N5363ZClover Park Technical College · Lakewood, WABuilt 2003 · S/N 17281173 N536HFVan Anda Aviation LLC · Apopka, FLBuilt 2000 · S/N 17280954 N537HFSilver Express Co · Miami, FLBuilt 2000 · S/N 17280891 N538HFSun Aircraft Management LLC · Ormond Beach, FLBuilt 2000 · S/N 17280873 N541ESouthern Illinois University · Murphysboro, ILBuilt 2011 · S/N 17281593 N546ASouthern Illinois University · Murphysboro, ILBuilt 2011 · S/N 17281594 N547ESouthern Illinois University · Murphysboro, ILBuilt 2011 · S/N 17281596 N548ASouthern Illinois University · Murphysboro, ILBuilt 2011 · S/N 17281597 N549ASouthern Illinois University · Murphysboro, ILBuilt 2011 · S/N 17281598 N54JASan Carlos Flight Center Inc · San Carlos, CABuilt 1998 · S/N 17280607 N555FNFlying Neutrons LLC · Lebanon, OHBuilt 2001 · S/N 17280999 N574BWBridge State University · Bridgewater, MABuilt 2000 · S/N 17280948 N576BWBridgewater State University · North Dartmouth, MAS/N 17280494 N578BWBridgewater State University · Bridgewater, MABuilt 1998 · S/N 17280522 N579BWBridgewater State University · Bridgewater, MABuilt 2000 · S/N 17280944 N57FASilver Express Co DBA · Miami, FLBuilt 1997 · S/N 17280225 N5929TFlight School Of Gwinnett Inc · Lawrenceville, GABuilt 2002 · S/N 17281105 N596CSVan Anda Aviation LLC · Apopka, FLBuilt 1997 · S/N 17280050 N59LJL & J Aviation Inc · Atwater, CABuilt 2001 · S/N 17281043 N6023SChristiansen Aviation LLC · Wilmington, DEBuilt 2006 · S/N 17281337 N606DBBode Aviation Inc · Albuquerque, NMBuilt 2002 · S/N 17281141 N606TCWings Over Texas Holdings LLC · Denton, TXBuilt 1997 · S/N 17280152 N613ADhs Operations LLC · Wilmington, DEBuilt 1997 · S/N 17280248 N61958Hff Leasing LLC · San Diego, CABuilt 2008 · S/N 17281541 N61959Scandinavian Aviation Academy Inc · El Cajon, CABuilt 2008 · S/N 17281542 N6217NXing Kong Aviation Service LLC · Atwater, CAS/N 17281544 N6235TCrystal Air Inc · Chattanooga, TNBuilt 2008 · S/N 17281515 N62726Xing Kong Aviation Service LLC · Atwater, CAS/N 17281529 N627CTCoast Flight Training And Management Inc · San Diego, CABuilt 2006 · S/N 17281336 N62AWDirty Side Down Aviation LLC · Georgetown, TXBuilt 1998 · S/N 17280504

Back to Cessna 172R