Skip to content

Registered aircraft · 969

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 ('2072703', '2072707', '2072705')
  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 ('2072703', '2072707', '2072705')
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.

N51782Ranger Lumber Corp · Springfield, MABuilt 2002 · S/N 18281096 N51784Winingar Thomas M · Brock, TXBuilt 2002 · S/N 18281097 N51785Photos Unlimited · Rancho Cordova, CABuilt 2002 · S/N 18281098 N51816Barr Air Patrol LLC · Mesquite, TXBuilt 2002 · S/N 18281120 N5181VWarden Stephen M · Sugar Land, TXBuilt 2002 · S/N 18281102 N5184GSicking Ryan · Gainesville, TXBuilt 2002 · S/N 18281104 N5184PBarr Air Patrol LLC · Mesquite, TXBuilt 2002 · S/N 18281105 N5187AHada Benjamin · Andrews, TXBuilt 2002 · S/N 18281111 N5188LMascari Nicholas M · Mundelein, ILBuilt 2002 · S/N 18281112 N5188TCohen Edward R · Loomis, CABuilt 2002 · S/N 18281113 N5191FArapahoe Aero Aircraft Sales LLC · Englewood, COBuilt 2002 · S/N 18281115 N5196PEsbenshade Wilmer R · New Holland, PABuilt 2002 · S/N 18281125 N5198JMichigan Dept Of Natural Resources · Roscommon, MIBuilt 2009 · S/N 18282147 N5198QValiair Lc Trustee · Casper, WYBuilt 2010 · S/N 18282210 N5200ABarr Air Patrol LLC · Mesquite, TXBuilt 2002 · S/N 18281128 N52072Wicked Wings Aviation LLC · Dover, DEBuilt 2002 · S/N 18281137 N5208S5fs Aviation LLC · Lewes, DEBuilt 2002 · S/N 18281138 N520EPMiles In The Sky LLC · Springfield, MOBuilt 2010 · S/N 18282274 N520FSCloud One Flying Club Inc · Kansas City, MOS/N 18281091 N520WBVan Bortel Aircraft Inc · Arlington, TXBuilt 2008 · S/N 18282049 N5210QFortress Group LLC · Thompsons Station, TNBuilt 2002 · S/N 18281140 N5218YMcintire Aviation LLC · Middletown, DEBuilt 2002 · S/N 18281147 N521AFChhh LLC · Raleigh, NCBuilt 2003 · S/N 18281194 N521DBBowling Donald W · Greensburg, INBuilt 2006 · S/N 18281823 N521TKCato Air LLC · Wilmington, DEBuilt 2005 · S/N 18281673 N5220AMarshall Chadwick J · Fort Walton Beach, FLBuilt 2002 · S/N 18281149 N5225LFirst Aero LLC · Edmonds, WABuilt 2002 · S/N 18281151 N5225REnright Darren · Lakeville, MNBuilt 2002 · S/N 18281152 N5227SDcrss LLC · Marcy, NYBuilt 2009 · S/N 18282155 N522AFState Of Louisiana · Baton Rouge, LABuilt 2003 · S/N 18281195 N5239YDumitrache Christina Marie · Mankato, MNBuilt 2009 · S/N 18282169 N5254ABuffy Aero LLC · Suwanee, GABuilt 2002 · S/N 18281157 N5257ASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2009 · S/N 18282181 N52694Sullivan Michael E Trustee · Granite Bay, CABuilt 2002 · S/N 18281161 N5273FPsc Leasing LLC · Nokesville, VABuilt 2009 · S/N 18282193 N5273KColumbia Fire & Safety LLC · Wilmington, DEBuilt 2002 · S/N 18281162 N52753Omark Aviation LLC · Naples, FLBuilt 2002 · S/N 18281164 N52757Brady Aviation Ltd Co · Friendswood, TXBuilt 2002 · S/N 18281165 N528KCBukhart Don · Blakely Island, WABuilt 2002 · S/N 18281109 N528LEZeus Aviation LLC · Carlisle, OHBuilt 2008 · S/N 18282046 N528MJAircraft Owners & Pilots Association · Frederick, MDBuilt 2001 · S/N 18280991 N528PVMelin Mark Alan · Newport, NCBuilt 2007 · S/N 18282035 N52HAAssociated Packaging Inc · Gallatin, TNS/N 18282226 N5302XFnb Flying Club LLC · Gallatin, TNS/N 18281175 N53076Rjr Aviation LLC · Ridge, NYS/N 18281179 N53214Westbank Fishing LLC · Kiln, MSS/N 18281171 N5329SAlabama Forestry Commission · Montgomery, ALBuilt 2003 · S/N 18281198 N53310Lucente Michael A · Fort Myers, FLBuilt 2003 · S/N 18281199 N5340XAgvest LLC · Abingdon, VABuilt 2003 · S/N 18281207 N5345UMidwest Avtech Inc · South Barrington, ILS/N 18281210

Back to Cessna 182T