Skip to content

Registered aircraft · 264

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 ('2076617', '2076621')
  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 ('2076617', '2076621')
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.

N100TPTes Aviation LLC · Southbury, CTBuilt 2012 · S/N 510-0418 N101FUAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 2009 · S/N 510-0207 N102DSMaria Squared Aviation LLC · Saint Louis, MOBuilt 2008 · S/N 510-0095 N105JBravo Aviation LLC · Belmond, IABuilt 2009 · S/N 510-0277 N111JMLantzman Holdings LLC · San Diego, CABuilt 2011 · S/N 510-0383 N116MCJoc Aviation LLC · Nashville, TNBuilt 2009 · S/N 510-0266 N120FTAtlas Chartering Services Inc · Laguna Hills, CABuilt 2010 · S/N 510-0322 N12RMAviana Mustang LLC · Edmond, OKBuilt 2009 · S/N 510-0226 N133TFColumbia Wv Aviation LLC · Wilmington, DEBuilt 2009 · S/N 510-0191 N146ARJet Stream LLC · San Carlos, CABuilt 2012 · S/N 510-0413 N155MMLakeshore Pets LLC · Cleveland, NCBuilt 2014 · S/N 510-0452 N163TCDodson International Parts Inc · Rantoul, KSBuilt 2007 · S/N 510-0039 N168TYCoast Walk Aviation LLC · La Jolla, CABuilt 2010 · S/N 510-0297 N171AACorsair Two LLC · Hillsboro, ORBuilt 2012 · S/N 510-0412 N171UTImport Auto Mex Lc · Laredo, TXBuilt 2013 · S/N 510-0434 N1744ZSkidmo Aviation LLC · Missoula, MTBuilt 2011 · S/N 510-0345 N178SFWings Jet Flight Training LLC · Los Angeles, CABuilt 2008 · S/N 510-0128 N17RPGzs Aviation LLC · Dover, DEBuilt 2008 · S/N 510-0133 N17TRMustang510rf LLC · Kalispell, MTBuilt 2009 · S/N 510-0220 N186M186m LLC · Henderson, NVBuilt 2007 · S/N 510-0020 N1888Flying Pigs Aviation LLC · Los Altos, CABuilt 2008 · S/N 510-0107 N1956AAubuchon James F Jr · Mckinney, TXBuilt 2010 · S/N 510-0305 N199MLColumbia Asset Trust Corp Trustee · Wichita, KSBuilt 2007 · S/N 510-0002 N19RPN19rp LLC · Wilmington, DEBuilt 2014 · S/N 510-0449 N1RGKar2 Inc · Sevierville, TNBuilt 2008 · S/N 510-0079 N1RSHotel Sierra Group LLC · Kittery, MEBuilt 2008 · S/N 510-0105 N1THPony Investments LLC · Colorado Springs, COBuilt 2008 · S/N 510-0076 N1VV565 Vv Ltd · Union Hill, ILBuilt 2007 · S/N 510-0013 N2069QAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 2008 · S/N 510-0137 N210PMAlpha Bravo LLC · Knoxville, TNBuilt 2010 · S/N 510-0301 N223PWCypress Healthcare LLC · Deer Lodge, MTBuilt 2010 · S/N 510-0314 N22EMPruett'S Food Inc · Broken Bow, OKBuilt 2007 · S/N 510-0047 N230PWJbs Inc · Wilmington, DEBuilt 2009 · S/N 510-0200 N234PHirschfeld David · Choteau, MTBuilt 2014 · S/N 510-0450 N246REWing Investments Fl LLC · Naples, FLBuilt 2010 · S/N 510-0295 N247DRUno Aviation LLC · El Paso, TXBuilt 2009 · S/N 510-0177 N247WSLynx Petroleum Consultants Inc · Hobbs, NMS/N 510-0204 N248LGCaribbean Flight Group LLC · Clearwater, FLBuilt 2011 · S/N 510-0311 N25KNTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2008 · S/N 510-0112 N26SQFreedom Air Flights LLC · Mohave Valley, AZBuilt 2007 · S/N 510-0031 N271CS105 Alas LLC · Del Mar, CABuilt 2009 · S/N 510-0158 N27369Textron Aviation Inc · Wichita, KSBuilt 2005 · S/N 712 N280AZRegistered aircraftBuilt 2008 · S/N 510-0061 N282DA282da Amc LLC · Haviland, KSBuilt 2010 · S/N 510-0333 N287LACarlito Air LLC · Sarasota, FLBuilt 2010 · S/N 510-0287 N293MMMk Leasing LLC · Scottsdale, AZBuilt 2010 · S/N 510-0293 N295PJTes Turbine LLC · Creve Coeur, MOBuilt 2011 · S/N 510-0372 N2CMBt Squared LLC · Amarillo, TXBuilt 2008 · S/N 510-0080 N2WGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2015 · S/N 510-0459 N300VRLm Aerospace Corp · Aventura, FLBuilt 2007 · S/N 510-0044

Back to Cessna 510