Skip to content

Registered aircraft · 854

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:80-22-12-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-22-12-R2') ORDER BY n_number

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:80-22-12-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-22-12-R2')
  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, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:80-22-12-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-22-12-R2')
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.

N553ASAlaska Airlines Inc · Seattle, WABuilt 2006 · S/N 34594 N554WTAerownership North American Services Inc Trustee · Dover, DES/N 28554 N556ASAlaska Airlines Inc · Seattle, WABuilt 2006 · S/N 35175 N557ASAlaska Airlines Inc · Seattle, WABuilt 2006 · S/N 35176 N558ASAlaska Airlines Inc · Seattle, WABuilt 2006 · S/N 35177 N559ASAlaska Airlines Inc · Seattle, WABuilt 2006 · S/N 35178 N560ASAlaska Airlines Inc · Seatac, WABuilt 2006 · S/N 35179 N562ASBank Of Utah Trustee · Salt Lake City, UTBuilt 2006 · S/N 35091 N563ASAlaska Airlines Inc · Seatac, WABuilt 2006 · S/N 35180 N563WNWilmington Trust Co Trustee · Wilmington, DEBuilt 2002 · S/N 34296 N564ASBank Of Utah Trustee · Salt Lake City, UTBuilt 2006 · S/N 35103 N565ASAlaska Airlines Inc · Seattle, WABuilt 2006 · S/N 35181 N566ASAlaska Airlines Inc · Seattle, WABuilt 2007 · S/N 35182 N568ASAlaska Airlines Inc · Seattle, WABuilt 2007 · S/N 35183 N569ASAlaska Airlines Inc · Seatac, WABuilt 2007 · S/N 35184 N570ASAlaska Airlines Inc · Seattle, WABuilt 2007 · S/N 35185 N571ASUmb Bank Na Trustee · Salt Lake City, UTS/N 32904 N577ASAlaska Airlines Inc · Seattle, WABuilt 2007 · S/N 35186 N579ASAlaska Airlines Inc · Seattle, WABuilt 2007 · S/N 35187 N581ASAlaska Airlines Inc · Seattle, WABuilt 2007 · S/N 35188 N583ASBank Of Utah Trustee · Salt Lake City, UTBuilt 2007 · S/N 35681 N584ASBank Of Utah Trustee · Salt Lake City, UTBuilt 2007 · S/N 35682 N585ASAlaska Airlines Inc · Seatac, WABuilt 2007 · S/N 35683 N586ASAlaska Airlines Inc · Seatac, WABuilt 2007 · S/N 35189 N587ASAlaska Airlines Inc · Seatac, WABuilt 2007 · S/N 35684 N588ASAlaska Airlines Inc · Seatac, WABuilt 2007 · S/N 35685 N589ASAlaska Airlines Inc · Seatac, WABuilt 2007 · S/N 35686 N590ASAlaska Airlines Inc · Seattle, WABuilt 2008 · S/N 35687 N592ASUmb Bank Na Trustee · Salt Lake City, UTBuilt 2008 · S/N 35190 N593ASUmb Bank Na Trustee · Salt Lake City, UTBuilt 2008 · S/N 35107 N594ASAlaska Airlines Inc · Seattle, WABuilt 2008 · S/N 35191 N596ASAlaska Airlines Inc · Seatac, WABuilt 2008 · S/N 35688 N597ASAlaska Airlines Inc · Seatac, WABuilt 2008 · S/N 35689 N607ASAlaska Airlines Inc · Seattle, WABuilt 1999 · S/N 29751 N60958Umb Bank Na Trustee · Salt Lake City, UTS/N 60958 N609ASAlaska Airlines Inc · Seattle, WABuilt 1999 · S/N 29752 N611ASAlaska Airlines Inc · Seatac, WABuilt 1999 · S/N 29753 N612ASAlaska Airlines Inc · Seatac, WABuilt 1999 · S/N 30162 N613ASAlaska Airlines Inc · Seatac, WABuilt 1999 · S/N 30163 N614ASAlaska Airlines Inc · Seatac, WABuilt 1999 · S/N 30343 N615ASAlaska Airlines Inc · Seatac, WABuilt 2000 · S/N 30344 N615PA2d Aviation Corp · Frisco, TXBuilt 1976 · S/N 21266 N615SCSvp LLC · Missoula, MTS/N 26100 N618ASAlaska Airlines Inc · Seatac, WABuilt 2000 · S/N 30543 N619ASAlaska Airlines Inc · Seattle, WABuilt 2000 · S/N 30164 N622ASAlaska Airlines Inc · Seattle, WABuilt 2000 · S/N 30165 N623RHOmega Air Inc · San Antonio, TXS/N 19623 N624RHOmega Air Inc · San Antonio, TXBuilt 1968 · S/N 19624 N625ASAlaska Airlines Inc · Seatac, WABuilt 2001 · S/N 30792 N626ASAlaska Airlines Inc · Seatac, WABuilt 2001 · S/N 30793

Back to AD 80-22-12 R2