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.

N269SAAlthof Equipment Management LLC · Jupiter, FLBuilt 2011 · S/N 18282280 N270CPCivil Air Patrol · Maxwell Afb, ALBuilt 2012 · S/N 18282352 N270FASchoettelkotte Christopher B · Friendswood, TXBuilt 2003 · S/N 18281270 N271AFBurke Aircraft Service Co LLC · Portsmouth, OHBuilt 2003 · S/N 18281188 N271DCForum Aviation LLC · Middletown, DEBuilt 2005 · S/N 18281579 N2726XSuttman Robert · Dayton, OHBuilt 2007 · S/N 18281913 N2731YGeorgia Forestry Commission · Macon, GABuilt 2003 · S/N 18281202 N273CPCivil Air Patrol · Maxwell Afb, ALBuilt 2012 · S/N 18282354 N274BBLcb Leasing · Manassas, VAFirst renewal noticeBuilt 2010 · S/N 18282270 N281AFState Of Louisiana · Baton Rouge, LABuilt 2003 · S/N 18281189 N281DKN281dk LLC · Brandywine, MDBuilt 2005 · S/N 18281719 N282ABVan Bortel Aircraft Inc · Arlington, TXBuilt 2008 · S/N 18282139 N282HDDavis Aviation LLC · Wilkesboro, NCBuilt 2005 · S/N 18281631 N288BTValiair Ltd Co Trustee · Casper, WYBuilt 2005 · S/N 18281607 N288CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18281988 N288MCTomanec Jean · Victoria, TXBuilt 2002 · S/N 18281110 N289CSChow Rogers LLC · Fort Myers, FLBuilt 2011 · S/N 18282289 N290RMCxairco LLC · Yuma, AZBuilt 2010 · S/N 18282215 N291JDDahapov LLC · Boca Raton, FLBuilt 2012 · S/N 18282322 N292CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18281992 N293CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18281993 N294CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18281994 N294CSState Of Wisconsin Department Of Administration · Madison, WIBuilt 2011 · S/N 18282294 N296CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18281995 N298DBButler John P · Hazelhurst, WIBuilt 2005 · S/N 18281595 N302AFState Of Louisiana · Baton Rouge, LABuilt 2003 · S/N 18281190 N302MPKqm Aviation · Bristow, VABuilt 2010 · S/N 18282273 N3033LDaniel Gary · Fallston, MDBuilt 2008 · S/N 18282109 N304CGVan Bortel Aircraft Inc · Arlington, TXBuilt 2005 · S/N 18281609 N305JRHarrison Aviation LLC · Salem, ORBuilt 2005 · S/N 18281692 N305RCWashington State Patrol · Olympia, WABuilt 2001 · S/N 18281001 N311JMN311jm LLC · Lake City, FLBuilt 2007 · S/N 18281891 N311SBNbr Aviation · Manassas, VAFirst renewal noticeBuilt 2010 · S/N 18282246 N313CPCivil Air Patrol · Maxwell Afb, ALBuilt 2009 · S/N 18282187 N314SAAeryn Innovations LLC · Dallas, TXBuilt 2003 · S/N 18281243 N316JHNorthern Arizona Investment Group LLC · Prescott, AZBuilt 2004 · S/N 18281345 N318SJObr Leasing · Manassas, VAFirst renewal noticeBuilt 2010 · S/N 18282251 N318WCDelta Dusters LLC · Lake Providence, LABuilt 2006 · S/N 18281829 N319KSFvx Research · Manassas, VABuilt 2010 · S/N 18282243 N320RCEastern Properties LLC · Burlington, NJBuilt 2004 · S/N 18281352 N322CSGlembot Troy M Trustee · Winchester, VABuilt 2012 · S/N 18282341 N322TEEschmann Tim · Novinger, MOBuilt 2004 · S/N 18281372 N323LPRkt Productions · Manassas, VAFirst renewal noticeBuilt 2010 · S/N 18282244 N324RPClear For Take Off LLC · Burlingame, CABuilt 2004 · S/N 18281422 N325MMBirdie Aviation LLC · Marble Hill, GABuilt 2007 · S/N 18281907 N326CFWestbank Fishing LLC · Kiln, MSBuilt 2001 · S/N 18281045 N326MCJ&D Petroleum · Tallahassee, FLS/N 18281326 N326PSPsl Surveys · Greenville, DEBuilt 2012 · S/N 18282344 N331MSAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2007 · S/N 18282021 N337DBOlson Vienette · White Bear Lake, MNBuilt 2001 · S/N 18281027

Back to Cessna 182T