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.

N655CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 18281655 N65602Ballew James H · Las Vegas, NVBuilt 2004 · S/N 18281487 N65638Mid Continent Aircraft Corp · Hayti, MOBuilt 2004 · S/N 18281467 N65664Southwest Flying Club Inc · The Woodlands, TXBuilt 2004 · S/N 18281489 N65672Jensen Thomas · Nixa, MOS/N 18281474 N656CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 18281656 N657CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 18281657 N657TPZma LLC · North Little Rock, ARBuilt 2010 · S/N 18282253 N65853Morando Donald W · Myrtle Beach, SCBuilt 2004 · S/N 18281490 N65860Edb Air Inc · Wilsonville, ORBuilt 2004 · S/N 18281491 N65862Top Flight Aviation Inc · Corona, CABuilt 2004 · S/N 18281493 N658CPArizona Air Salvage · Phoenix, AZBuilt 2005 · S/N 18281658 N658PWWheels Up Aviation LLC · Cochran, GABuilt 2008 · S/N 18282098 N65903N65903 LLC · Union Gap, WABuilt 2004 · S/N 18281501 N65904Electra Aviation LLC · Wilmington, DEBuilt 2004 · S/N 18281502 N65937Berendschot Leonardus · Huntsville, TXBuilt 2004 · S/N 18281492 N65957Skybourne LLC · Stuart, VABuilt 2004 · S/N 18281484 N65988Arkansas Industrial Manufacturing LLC · Wilmington, DEBuilt 2005 · S/N 18281513 N65991Crysler Douglas Michael · Rockford, MIBuilt 2005 · S/N 18281514 N65995Phoenix Flyers Inc · Mesa, AZBuilt 2005 · S/N 18281515 N65BLWhite Craig S · Troy, OHBuilt 2001 · S/N 18281069 N65KCBarr Air Patrol LLC · Mesquite, TXBuilt 2001 · S/N 18281015 N66070Obetz Robert S · Manheim, PABuilt 2005 · S/N 18281522 N66135Miller Robert · Pierpont, OHS/N 18281526 N66HERausch William Donald · Ontario, NYBuilt 2004 · S/N 18281482 N679CPCivil Air Patrol · Maxwell Afb, ALBuilt 2010 · S/N 18282248 N679MCVan Bortel Aircraft Inc · Arlington, TXBuilt 2005 · S/N 18281678 N682SBSundowners Inc · Fort Myers, FLBuilt 2003 · S/N 18281218 N682SPHansell Stephen E · East Windsor, NJBuilt 2008 · S/N 18282090 N685ACMullerhill Inc · Hillsboro Beach, FLBuilt 2004 · S/N 18281463 N687CPCivil Air Patrol · Maxwell Afb, ALBuilt 2011 · S/N 18282288 N687RTFvx Research · Greenville, DEBuilt 2012 · S/N 18282350 N696EAHubbard Broadcasting Inc · Saint Paul, MNBuilt 2005 · S/N 18281722 N699CBBig Skylands Aviation LLC · Succasunna, NJBuilt 2001 · S/N 18281033 N6HPState Of Ohio · Columbus, OHBuilt 2001 · S/N 18281070 N701FASkylane Flyers LLC · Fort Mill, SCBuilt 2002 · S/N 18281107 N702CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 18281702 N703CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 18281703 N706CPCivil Air Patrol · Maxwell Afb, ALS/N 18281704 N707FSky Magic Aviation Inc Trustee · Wilmington, DES/N 18281081 N709CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 18281709 N709DBPowerhouse Detox Inc · Otis, ORBuilt 2004 · S/N 18281382 N710CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 18281710 N711KFJ-Com Aviation LLC · Richland, MSBuilt 2001 · S/N 18280969 N712MSNational Aircraft Leasing · Greenville, DEBuilt 2009 · S/N 18282179 N715CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 18281712 N715DFAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 2005 · S/N 18281734 N715RCEide David B · Saint Michael, MNBuilt 2002 · S/N 18281085 N716CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 18281711 N716HPState Of Ohio · Columbus, OHBuilt 2005 · S/N 18281581

Back to Cessna 182T