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.

N902FEFederal Express Corporation · Memphis, TNBuilt 1986 · S/N 208B0002 N903DPKenmore Air Harbor LLC · Kenmore, WABuilt 1999 · S/N 208B0703 N903FEFederal Express Corporation · Memphis, TNBuilt 1986 · S/N 208B0003 N904FEFederal Express Corporation · Memphis, TNS/N 208B0004 N905FEFederal Express Corporation · Memphis, TNS/N 208B0005 N906FEFederal Express Corporation · Memphis, TNBuilt 1986 · S/N 208B0006 N907FEFederal Express Corporation · Memphis, TNBuilt 1986 · S/N 208B0007 N908FEFederal Express Corporation · Memphis, TNBuilt 1986 · S/N 208B0008 N909FEFederal Express Corporation · Memphis, TNBuilt 1986 · S/N 208B0009 N90GLRedding Aero Enterprises Inc · Redding, CABuilt 1990 · S/N 208B0229 N910ECState Of Tennessee Department Of Transportation · Nashville, TNBuilt 2004 · S/N 208B1090 N910FEFederal Express Corporation · Memphis, TNBuilt 1986 · S/N 208B0010 N912FEFederal Express Corp · Memphis, TNBuilt 1986 · S/N 208B0012 N914FEFederal Express Corporation · Memphis, TNBuilt 1987 · S/N 208B0014 N916FEFederal Express Corporation · Memphis, TNBuilt 1987 · S/N 208B0016 N9187Catalina Air Transport LLC · Long Beach, CABuilt 2002 · S/N 208B0948 N918FEFederal Express Corp · Memphis, TNBuilt 1987 · S/N 208B0018 N91CLAircraft Structures International Corp · Enid, OKBuilt 1987 · S/N 208B0054 N920FEFederal Express Corp · Memphis, TNS/N 208B0020 N921FEFederal Express Corporation · Memphis, TNBuilt 1987 · S/N 208B0021 N922FEFederal Express Corporation · Memphis, TNS/N 208B0022 N923FEFederal Express Corporation · Memphis, TNBuilt 1987 · S/N 208B0023 N925FEFederal Express Corporation · Memphis, TNBuilt 1987 · S/N 208B0025 N926FEFederal Express Corporation · Memphis, TNBuilt 1987 · S/N 208B0026 N927FEFederal Express Corporation · Memphis, TNBuilt 1987 · S/N 208B0027 N928FEFederal Express Corporation · Memphis, TNBuilt 1987 · S/N 208B0028 N929FEFederal Express Corp · Memphis, TNBuilt 1987 · S/N 208B0029 N929TGPa1 208b-0371 LLC · Fort Lauderdale, FLBuilt 1993 · S/N 208B0371 N92CLAircraft Structures International Corp · Enid, OKBuilt 1989 · S/N 208B0185 N92JJPa1 208b-1074 LLC · Fort Lauderdale, FLBuilt 2004 · S/N 208B1074 N930FEFederal Express Corporation · Memphis, TNBuilt 1987 · S/N 208B0030 N9310FPa1 208b-0490 LLC · Fort Lauderdale, FLBuilt 1995 · S/N 208B0490 N931FEFederal Express Corporation · Memphis, TNBuilt 1987 · S/N 208B0031 N932CRedding Aero Enterprises Inc · Redding, CABuilt 1987 · S/N 208B0032 N932SPSouthern Airways Pacific LLC · Addison, TXBuilt 2014 · S/N 208B5177 N9331BMartinaire Aviation LLC · Addison, TXBuilt 1987 · S/N 208B0055 N934FEFederal Express Corporation · Memphis, TNBuilt 1987 · S/N 208B0034 N935FEFederal Express Corporation · Memphis, TNBuilt 1987 · S/N 208B0035 N936FEFederal Express Corp · Memphis, TNBuilt 1987 · S/N 208B0036 N937CKSchuman Carriage Company Ltd · Honolulu, HIBuilt 2005 · S/N 208B1118 N939FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0180 N940FEFederal Express Corp · Memphis, TNBuilt 1987 · S/N 208B0040 N943FEFederal Express Corporation · Memphis, TNS/N 208B0043 N9452BAirspeed Aviation LLC · Tacoma, WABuilt 1988 · S/N 208B0123 N9454BAirspeed Aviation LLC · Tacoma, WABuilt 1988 · S/N 208B0072 N9469BMartinaire Aviation LLC · Addison, TXBuilt 1988 · S/N 208B0079 N946FEFederal Express Corp · Memphis, TNBuilt 1987 · S/N 208B0048 N9471BMartinaire Aviation LLC · Addison, TXBuilt 1988 · S/N 208B0081 N947FEFederal Express Corp · Memphis, TNBuilt 1987 · S/N 208B0050 N9505BMartinaire Aviation LLC · Addison, TXBuilt 1988 · S/N 208B0085

Back to Cessna 208B