Skip to content

AD 2002-19-51 R1

Registered aircraft · 835

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:2002-19-51-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-19-51-R1') 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:2002-19-51-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-19-51-R1')
  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:2002-19-51-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-19-51-R1')
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.

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 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 N625ASAlaska Airlines Inc · Seatac, WABuilt 2001 · S/N 30792 N626ASAlaska Airlines Inc · Seatac, WABuilt 2001 · S/N 30793 N626DSBoeing Co · Renton, WABuilt 2025 · S/N 68738 N627ASAlaska Airlines Inc · Seattle, WABuilt 2001 · S/N 30794 N640CSCsds Asset Management LLC · Marana, AZS/N 26078 N644ASAlaska Airlines Inc · Seattle, WABuilt 2003 · S/N 30795 N652EEAerotrust Services Corp Trustee · Wilmington, DEBuilt 1992 · S/N 26526 N708MBUmb Bank Na Trustee · Salt Lake City, UTBuilt 2001 · S/N 30878 N708SSierra Pacific Airlines Inc · Tucson, AZBuilt 1995 · S/N 27424 N709SSierra Pacific Airlines Inc · Tucson, AZBuilt 1997 · S/N 28722

Back to AD 2002-19-51 R1