Skip to content

Registered aircraft · 19

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

N327FTUmb Bank N A Trustee · Salt Lake City, UTS/N 32758 N336FTUmb Bank Na Trustee · Salt Lake City, UTS/N 33698 N566WNSouthwest Airlines Co · Dallas, TXBuilt 2002 · S/N 32753 N567WNSouthwest Airlines Co · Dallas, TXBuilt 2002 · S/N 32747 N569WNSouthwest Airlines Co · Dallas, TXBuilt 2002 · S/N 33656 N570WNSouthwest Airlines Co · Dallas, TXBuilt 2002 · S/N 33657 N754FTUmb Bank Na Trustee · Salt Lake City, UTS/N 32754 N755FTUmb Bank Na Trustee · Salt Lake City, UTS/N 32755 N756FTUmb Bank Na Trustee · Salt Lake City, UTS/N 32756 N757FTUmb Bank Na Trustee · Salt Lake City, UTS/N 32757 N760FTUmb Bank Na Trustee · Salt Lake City, UTS/N 32760 N762FTUmb Bank Na Trustee · Salt Lake City, UTS/N 32762 N7821LSouthwest Airlines Co · Dallas, TXBuilt 2003 · S/N 32748 N7823ASouthwest Airlines Co · Dallas, TXBuilt 2003 · S/N 32749 N7825ASouthwest Airlines Co · Dallas, TXBuilt 2003 · S/N 32750 N7828ASouthwest Airlines Co · Dallas, TXBuilt 2003 · S/N 33697 N7829BSouthwest Airlines Co · Dallas, TXBuilt 2003 · S/N 32751 N7831BSouthwest Airlines Co · Dallas, TXBuilt 2003 · S/N 32752 N7881AWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2008 · S/N 35084

Back to Boeing 737-7CT