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.

N828SGSky High Aviation Of Ga LLC · Doraville, GABuilt 2012 · S/N 18282325 N829CPCivil Air Patrol · Maxwell Afb, ALBuilt 2003 · S/N 18281263 N829FACareer Flight Training And Aircraft Rental Holding · Naples, FLBuilt 2002 · S/N 18281129 N82FLVan Bortel Aircraft Inc · Arlington, TXBuilt 2001 · S/N 18281007 N82LECollier County Sheriffs Office · Naples, FLBuilt 2004 · S/N 18281377 N82YCBerry Kevin J · Renfrew, PABuilt 2008 · S/N 18282081 N830CPCivil Air Patrol · Maxwell Afb, ALBuilt 2004 · S/N 18281300 N832CPCivil Air Patrol · Maxwell Afb, ALBuilt 2004 · S/N 18281301 N832TCFour Pines LLC · Grand Rapids, MNBuilt 2003 · S/N 18281269 N833CPCivil Air Patrol · Maxwell Afb, ALBuilt 2004 · S/N 18281302 N833SATimmcke Alan E · Tampa, FLBuilt 2002 · S/N 18281133 N834CPCivil Air Patrol · Maxwell Afb, ALBuilt 2004 · S/N 18281303 N835CPCivil Air Patrol · Maxwell Afb, ALBuilt 2004 · S/N 18281304 N836CPCivil Air Patrol · Maxwell Afb, ALBuilt 2004 · S/N 18281305 N840LPMys Aviation LLC · Rockford, ILBuilt 2004 · S/N 18281483 N848CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281851 N849CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281852 N853CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281853 N854CPCivil Air Patrol · Maxwell Afb, ALBuilt 2009 · S/N 18282202 N854DZHohnadel R Michael · Harlingen, TXBuilt 2002 · S/N 18281150 N861SFAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2004 · S/N 18281438 N864CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281854 N865CWSouthern Aviation · Anchorage, AKFirst renewal noticeBuilt 2005 · S/N 18281537 N865TCQuinault Aviation LLC · Priest River, IDS/N 18282276 N868TCDlg Enterprises LLC · Iota, LABuilt 2002 · S/N 18281168 N870PLake Elysian Sky Holdings LLC · Janesville, MNS/N 18281135 N873CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281872 N875CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281871 N878CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281868 N879CPCivil Air Patrol · Maxwell Afb, ALS/N 18282183 N879WMPsl Surveys · Bristow, VABuilt 2010 · S/N 18282216 N880CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281870 N882CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281862 N882LBArizona Flyers Club Inc · Tucson, AZBuilt 2001 · S/N 18280958 N883CPCivil Air Patrol · Maxwell Afb, ALBuilt 2009 · S/N 18282200 N8845KVan Bortel Aircraft Inc · Arlington, TXBuilt 2012 · S/N 18282332 N884CPCivil Air Patrol · Maxwell Afb, ALBuilt 2008 · S/N 18282084 N887CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281867 N888DEWeyls Daniel Christopher · Medina, OHBuilt 2010 · S/N 18282228 N890MBVan Bortel Aircraft Inc · Arlington, TXBuilt 2013 · S/N 18282365 N892BVGd Aviation Inc · Belleair, FLBuilt 2004 · S/N 18281329 N893CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281863 N894CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281864 N897SMDomich Jeffrey E · Petaluma, CABuilt 2011 · S/N 18282309 N899CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281866 N8WHGarrett Ag Equipment Ltd · Danbury, TXBuilt 2004 · S/N 18281499 N9005RBeneat John · Georgetown, TXBuilt 2010 · S/N 18282224 N9008HTextron Aviation Employees Flying Club Inc · Wichita, KSBuilt 2011 · S/N 18282227 N901RMBusey Technology Company LLC · Vienna, VAS/N 18282285 N9022HTurner Kent B · Addison, TXBuilt 2010 · S/N 18282254

Back to Cessna 182T