Skip to content

Registered aircraft · 644

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 ('2073701', '2073700', '2073705')
  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 ('2073701', '2073700', '2073705')
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.

N753KPKalinin Partners LLC · Juneau, AKBuilt 2007 · S/N 208B1275 N754FXFederal Express Corporation · Memphis, TNBuilt 1996 · S/N 208B0526 N754KPKalinin Partners LLC · Juneau, AKBuilt 2007 · S/N 208B1264 N755FXFederal Express Corporation · Memphis, TNBuilt 1996 · S/N 208B0529 N755KPKalinin Partners LLC · Juneau, AKBuilt 1999 · S/N 208B0759 N756FXFederal Express Corporation · Memphis, TNBuilt 1996 · S/N 208B0532 N7580BMec International Trading LLC · Daytona Beach, FLBuilt 1987 · S/N 208B0051 N7581FDesert Sand Aircraft Leasing Co Inc · Rosharon, TXBuilt 1994 · S/N 208B0389 N761FEFederal Express Corporation · Memphis, TNBuilt 1991 · S/N 208B0254 N762FEFederal Express Corp · Memphis, TNBuilt 1991 · S/N 208B0255 N763FEFederal Express Corporation · Memphis, TNBuilt 1991 · S/N 208B0256 N765FEFederal Express Corporation · Memphis, TNBuilt 1991 · S/N 208B0259 N767FEFederal Express Corp · Memphis, TNBuilt 1991 · S/N 208B0262 N768FEFederal Express Corp · Memphis, TNBuilt 1991 · S/N 208B0263 N770FEFederal Express Corporation · Memphis, TNBuilt 1991 · S/N 208B0265 N771FEFederal Express Corp · Memphis, TNBuilt 1991 · S/N 208B0267 N772FEFederal Express Corp · Memphis, TNBuilt 1991 · S/N 208B0268 N773FEFederal Express Corporation · Memphis, TNBuilt 1991 · S/N 208B0269 N774ATN774at LLC · Leesburg, VABuilt 2008 · S/N 208B2012 N774DLSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1992 · S/N 208B0324 N774FEFederal Express Corporation · Memphis, TNBuilt 1991 · S/N 208B0271 N774SPSamaritans Purse · Boone, NCBuilt 2013 · S/N 208B5030 N775FEFederal Express Corporation · Memphis, TNBuilt 1991 · S/N 208B0272 N778FEFederal Express Corporation · Memphis, TNBuilt 1991 · S/N 208B0275 N779FEFederal Express Corp · Memphis, TNBuilt 1991 · S/N 208B0276 N780FEFederal Express Corp · Memphis, TNBuilt 1991 · S/N 208B0277 N781FEFederal Express Corp · Memphis, TNBuilt 1991 · S/N 208B0278 N782FEFederal Express Corp · Memphis, TNBuilt 1991 · S/N 208B0280 N783FEFederal Express Corp · Memphis, TNBuilt 1991 · S/N 208B0281 N784FEFederal Express Corp · Memphis, TNBuilt 1991 · S/N 208B0282 N785FEFederal Express Corp · Memphis, TNBuilt 1991 · S/N 208B0283 N785WWAce Aviation LLC · Phoenix, AZBuilt 1999 · S/N 208B0792 N786FEFederal Express Corp · Memphis, TNBuilt 1991 · S/N 208B0284 N786WWWestwind Aviation Inc · Phoenix, AZBuilt 2004 · S/N 208B1099 N787FEFederal Express Corp · Memphis, TNBuilt 1991 · S/N 208B0285 N788FEFederal Express Corp · Memphis, TNBuilt 1991 · S/N 208B0286 N789FEFederal Express Corp · Memphis, TNBuilt 1991 · S/N 208B0287 N78SAMartinaire Aviation LLC · Addison, TXBuilt 1995 · S/N 208B0467 N790FEFederal Express Corporation · Memphis, TNBuilt 1991 · S/N 208B0288 N792FEFederal Express Corp · Memphis, TNBuilt 1991 · S/N 208B0290 N794FEFederal Express Corp · Memphis, TNBuilt 1991 · S/N 208B0292 N795FEFederal Express Corp · Memphis, TNBuilt 1991 · S/N 208B0293 N798FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0174 N801FLDesert Sand Aircraft Leasing Co Inc · Rosharon, TXBuilt 2000 · S/N 208B-0809 N802AAMartinaire Aviation LLC · Addison, TXBuilt 2000 · S/N 208B0873 N803FN803f Inc · Addison, TXBuilt 2005 · S/N 208B-1112 N804FEFederal Express Corporation · Memphis, TNS/N 208B0039 N804THPa1 208b-0421 LLC · Fort Lauderdale, FLBuilt 1994 · S/N 208B0421 N805ELKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 2002 · S/N 208B0998 N805THAvion Capital Corp · Anchorage, AKBuilt 1997 · S/N 208B0609

Back to Cessna 208B