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.

N9036BVan Bortel Aircraft Inc · Arlington, TXBuilt 2010 · S/N 18282258 N90391Meyer Florence Trustee · Billings, MTBuilt 2010 · S/N 18282259 N906TMRkt Productions · Bristow, VAFirst renewal noticeBuilt 2010 · S/N 18282269 N907WKNational Aircraft Leasing Corp · Manassas, VAS/N 18282197 N9086ZCy Air LLC · Springfield, MOBuilt 2011 · S/N 18282281 N908MCL2 Leasing LLC · Orem, UTS/N 18281900 N909CQVan Bortel Aircraft Inc · Arlington, TXBuilt 2005 · S/N 18281618 N90HPOklahoma Department Of Public Safety · Norman, OKBuilt 2007 · S/N 18282017 N910HPState Of Ohio · Columbus, OHBuilt 2001 · S/N 18281012 N910LFNby Productions · Bristow, VABuilt 2011 · S/N 18282284 N91160Brown Jeffrey C · Saint Augustine, FLBuilt 2011 · S/N 18282297 N912EXObr Leasing · Bristow, VABuilt 2010 · S/N 18282231 N914RLNichols Charles C · Hanford, CABuilt 2004 · S/N 18281399 N9154YNolan Daniel R · Wilmington, NCBuilt 2001 · S/N 18280971 N916WRPsl Surveys · Manassas, VAFirst renewal noticeS/N 18282262 N918MYFlying Pigs LLC · Tulsa, OKBuilt 2005 · S/N 18281512 N918TPAzure Quest LLC · Cleveland, TNBuilt 2007 · S/N 18281904 N918WMStone City Charters LLC · Anamosa, IABuilt 2008 · S/N 18282068 N91920Brodel Adam · Grass Valley, CABuilt 2007 · S/N 18281921 N920BWWilliams Rebecca J · Alto, NMBuilt 2001 · S/N 18280979 N921CTN921ct LLC · Elkton, KYS/N 18281220 N922MKNational Aircraft Leasing Corp · Greenville, DEBuilt 2009 · S/N 18282195 N923DBGrenville Andrew · Decatur Island, WABuilt 2002 · S/N 18281087 N923DMHt Holdings LLC · Oxford, MSBuilt 2004 · S/N 18281496 N925PTPuddle Jumper Aviation LLC · Saginaw, MIBuilt 2003 · S/N 18281217 N9309CVan Bortel Aircraft Inc · Arlington, TXBuilt 2011 · S/N 18282306 N935FACaylin LLC · Wilmington, DEBuilt 2007 · S/N 18281935 N939DJJaffray Management LLC · Green Cove Springs, FLBuilt 2003 · S/N 18281226 N9402DH C E Leasing LLC · Cleveland, TNBuilt 2012 · S/N 18282312 N941CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18281941 N945PDHickmott Mark T · Sunol, CABuilt 2001 · S/N 18280945 N947CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18281974 N94823Black Hills Information Security Inc · Bozeman, MTBuilt 2013 · S/N 18282363 N94825Vaughan Aviation LLC · Leesburg, VABuilt 2013 · S/N 18282324 N948CPCivil Air Patrol · Maxwell Afb, ALBuilt 2008 · S/N 18282115 N94992Mac Air Corp · Benton, KSBuilt 2013 · S/N 18282359 N950CPCivil Air Patrol · Maxwell Afb, ALBuilt 2009 · S/N 18282185 N953RRGig Aviation LLC · Harrisburg, ARBuilt 2007 · S/N 18282009 N956CFHighwind Aero LLC · Inyokern, CABuilt 2002 · S/N 18281075 N959CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18281969 N960CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18281990 N962CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18281972 N962JBNational Aircraft Leasing Corp · Greenville, DEBuilt 2009 · S/N 18282149 N962PBNational Aircraft Leasing Corp · Greenville, DEBuilt 2009 · S/N 18282159 N963CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18281973 N964WFTempietto Inc · Aptos, CABuilt 2003 · S/N 18281291 N965CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18281965 N966CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18281966 N967CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18281967 N968CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18281968

Back to Cessna 182T