Skip to content

Registered aircraft · 111

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

N500WRSouthwest Airlines Co · Dallas, TXBuilt 2014 · S/N 36898 N815VLBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 39883 N8301JSouthwest Airlines Co · Dallas, TXBuilt 2012 · S/N 36980 N8302FSouthwest Airlines Co · Dallas, TXBuilt 2012 · S/N 36680 N8303RSouthwest Airlines Co · Dallas, TXBuilt 2012 · S/N 36681 N8305ESouthwest Airlines Co · Dallas, TXBuilt 2012 · S/N 36683 N8306HSouthwest Airlines Co · Dallas, TXBuilt 2012 · S/N 36983 N8307KUmb Bank N A Trustee · Salt Lake City, UTBuilt 2012 · S/N 36987 N8308KSouthwest Airlines Co · Dallas, TXBuilt 2012 · S/N 36682 N8309CSouthwest Airlines Co · Dallas, TXBuilt 2012 · S/N 36985 N8310CSouthwest Airlines Co · Dallas, TXBuilt 2012 · S/N 38807 N8311QSouthwest Airlines Co · Dallas, TXBuilt 2012 · S/N 38808 N8312CSouthwest Airlines Co · Dallas, TXBuilt 2012 · S/N 38809 N8313FSouthwest Airlines Co · Dallas, TXBuilt 2012 · S/N 38810 N8314LSouthwest Airlines Co · Dallas, TXBuilt 2012 · S/N 36990 N8315CSouthwest Airlines Co · Dallas, TXBuilt 2012 · S/N 38811 N8316HSouthwest Airlines Co · Dallas, TXBuilt 2012 · S/N 36684 N8317MUmb Bank Na Trustee · Salt Lake City, UTBuilt 2012 · S/N 36992 N8318FUmb Bank Na Trustee · Salt Lake City, UTBuilt 2012 · S/N 36685 N8319FUmb Bank Na Trustee · Salt Lake City, UTBuilt 2012 · S/N 36994 N8320JSouthwest Airlines Co · Dallas, TXBuilt 2012 · S/N 36686 N8321DSouthwest Airlines Co · Dallas, TXBuilt 2012 · S/N 36687 N8322XUmb Bank Na Trustee · Salt Lake City, UTBuilt 2012 · S/N 36997 N8323CUmb Bank Na Trustee · Salt Lake City, UTBuilt 2012 · S/N 37005 N8324AUmb Bank Na Trustee · Salt Lake City, UTBuilt 2012 · S/N 35966 N8325DUmb Bank Na Trustee · Salt Lake City, UTBuilt 2012 · S/N 37003 N8326FUmb Bank Na Trustee · Salt Lake City, UTBuilt 2012 · S/N 35969 N8327AUmb Bank Na Trustee · Salt Lake City, UTBuilt 2012 · S/N 37009 N8328AUmb Bank Na Trustee · Salt Lake City, UTBuilt 2012 · S/N 38818 N8329BUmb Bank Na Trustee · Salt Lake City, UTBuilt 2012 · S/N 37006 N8600FBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 39882 N8602FBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 38110 N8603FWilmington Trust Co Trustee · Wilmington, DEBuilt 2012 · S/N 38875 N8605EUmb Bank Na Trustee · Salt Lake City, UTBuilt 2012 · S/N 36891 N8606CUmb Bank Na Trustee · Salt Lake City, UTS/N 35964 N8607MUmb Bank Na Trustee · Salt Lake City, UTBuilt 2013 · S/N 36634 N8608NUmb Bank Na Trustee · Salt Lake City, UTBuilt 2013 · S/N 36638 N8609AUmb Bank Na Trustee · Salt Lake City, UTBuilt 2013 · S/N 36893 N8610AUmb Bank Na Trustee · Salt Lake City, UTBuilt 2013 · S/N 36635 N8611FUmb Bank Na Trustee · Salt Lake City, UTBuilt 2013 · S/N 36892 N8612KSouthwest Airlines Co · Dallas, TXBuilt 2013 · S/N 36973 N8613KSouthwest Airlines Co · Dallas, TXBuilt 2013 · S/N 36998 N8614MSouthwest Airlines Co · Dallas, TXBuilt 2013 · S/N 36908 N8619FSouthwest Airlines Co · Dallas, TXBuilt 2013 · S/N 33939 N8621ABank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 36917 N8623FSouthwest Airlines Co · Dallas, TXBuilt 2013 · S/N 36731 N8626BSouthwest Airlines Co · Dallas, TXBuilt 2014 · S/N 36894 N8628ASouthwest Airlines Co · Dallas, TXBuilt 2014 · S/N 42384 N8629ASouthwest Airlines Co · Dallas, TXBuilt 2014 · S/N 36897 N8630BSouthwest Airlines Co · Dallas, TXBuilt 2014 · S/N 42521

Back to Boeing 737-8H4