Skip to content

Registered aircraft · 17

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 ('1384972')
  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 ('1384972')
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.

N702TWDelta Air Lnes Inc · Atlanta, GABuilt 1996 · S/N 28162 N706TWDelta Air Lines Inc · Atlanta, GABuilt 1997 · S/N 28165 N707TWDelta Air Lines Inc · Atlanta, GABuilt 1997 · S/N 27625 N709TWDelta Air Lines Inc · Atlanta, GABuilt 1997 · S/N 28168 N710TWDelta Air Lines Inc · Atlanta, GABuilt 1997 · S/N 28169 N712TWDelta Air Lines Inc · Atlanta, GABuilt 1997 · S/N 27624 N713TWDelta Air Lines Inc · Atlanta, GABuilt 1997 · S/N 28173 N726WNAersale Inc · Coral Gables, FLS/N 27623 N751ALGalactic Holdings LLC · Wilmington, DEBuilt 1997 · S/N 28167 N751CSUmb Bank Na Trustee · Salt Lake City, UTS/N 29442 N751CXCargo Aircraft Managment Inc · Wilmington, OHS/N 26273 N752CSUmb Bank Na Trustee · Salt Lake City, UTBuilt 2002 · S/N 30046 N753CSUmb Bank Na Trustee · Salt Lake City, UTS/N 26332 N754CSUmb Bank Na Trustee · Salt Lake City, UTS/N 27351 N993FDFederal Express Corp · Memphis, TNBuilt 1992 · S/N 24965 N995FDFederal Express Corp · Memphis, TNBuilt 1992 · S/N 25131 N996FDFederal Express Corp · Memphis, TNBuilt 1993 · S/N 26270

Back to Boeing 757-2Q8