Skip to content

Registered aircraft · 643

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.

N9766BRedding Aero Enterprises Inc · Redding, CABuilt 1988 · S/N 208B0112 N976EWright Air Service Inc · Fairbanks, AKBuilt 2002 · S/N 208B0976 N976FEFederal Express Corporation · Memphis, TNBuilt 1988 · S/N 208B0103 N977FEFederal Express Corporation · Memphis, TNBuilt 1988 · S/N 208B0104 N97826Atel Leasing Corp Trustee · San Francisco, CABuilt 2006 · S/N 208B1223 N979FEFederal Express Corp · Memphis, TNBuilt 1990 · S/N 208B0228 N979SVSkydive Guam Inc · Barrigada, GUBuilt 2002 · S/N 208B-0979 N97HAWright Air Service Inc · Fairbanks, AKBuilt 1997 · S/N 208B0610 N980FEFederal Express Corporation · Memphis, TNBuilt 1988 · S/N 208B0108 N980FXFederal Express Corp · Memphis, TNBuilt 1995 · S/N 208B0489 N981FEFederal Express Corporation · Memphis, TNBuilt 1988 · S/N 208B0110 N9820FPa1 208b-0410 LLC · Fort Lauderdale, FLBuilt 1994 · S/N 208B0410 N9829BSkydive Buckeye · Buckeye, AZBuilt 1988 · S/N 208B0116 N983FEFederal Express Corporation · Memphis, TNBuilt 1988 · S/N 208B0113 N984ACSpirit Air Inc · Salmon, IDBuilt 2009 · S/N 208B2081 N984FEFederal Express Corporation · Memphis, TNBuilt 1988 · S/N 208B0115 N985FEFederal Express Corporation · Memphis, TNBuilt 1988 · S/N 208B0117 N985FXFederal Express Corp · Memphis, TNBuilt 2012 · S/N 208B2369 N986FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0194 N986FXFederal Express Corp · Memphis, TNBuilt 2012 · S/N 208B2377 N986WUS Government · Washington, DCS/N 208B1086 N987FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0201 N987FXFederal Express Corp · Memphis, TNBuilt 2012 · S/N 208B2390 N987RAKeith Mutscher · Georgetown, TXBuilt 2000 · S/N 208B0870 N988FXFederal Express Corp · Memphis, TNBuilt 2012 · S/N 208B2400 N989BWRed Dragon Aviation LLC · Melbourne, FLBuilt 2004 · S/N 208B1058 N989FEFederal Express Corporation · Memphis, TNBuilt 1988 · S/N 208B0124 N989FXFederal Express Corp · Memphis, TNBuilt 2012 · S/N 208B2403 N990FXFederal Express Corp · Memphis, TNBuilt 2011 · S/N 208B2276 N991FXFederal Express Corp · Memphis, TNBuilt 2011 · S/N 208B2279 N992FEFederal Express Corporation · Memphis, TNBuilt 1988 · S/N 208B0128 N992FXFederal Express Corp · Memphis, TNBuilt 2011 · S/N 208B2288 N993FEFederal Express Corporation · Memphis, TNBuilt 1988 · S/N 208B0130 N993FXFederal Express Corp · Memphis, TNBuilt 2011 · S/N 208B2289 N994FEFederal Express Corporation · Memphis, TNBuilt 1988 · S/N 208B0132 N994FXFederal Express Corp · Memphis, TNBuilt 2011 · S/N 208B2315 N9956BMartinaire Aviation LLC · Addison, TXBuilt 1988 · S/N 208B0119 N995FEFederal Express Corporation · Memphis, TNBuilt 1988 · S/N 208B0133 N996FEFederal Express Corp · Memphis, TNBuilt 1988 · S/N 208B0135 N997FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0197 N998FEFederal Express Corporation · Memphis, TNBuilt 1988 · S/N 208B0139 N999FEFederal Express Corp · Memphis, TNBuilt 1990 · S/N 208B0231 N999WVWright Air Service Inc · Fairbanks, AKBuilt 2009 · S/N 208B2082

Back to Cessna 208B