OpenAirDocs.org
AD 2002-08-52

Registered aircraft · 72

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
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-08-52')
    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-08-52')
  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.

N615ASAlaska Airlines Inc · Seatac, WABuilt 2000 · S/N 30344N618ASAlaska Airlines Inc · Seatac, WABuilt 2000 · S/N 30543N619ASAlaska Airlines Inc · Seattle, WABuilt 2000 · S/N 30164N622ASAlaska Airlines Inc · Seattle, WABuilt 2000 · S/N 30165N625ASAlaska Airlines Inc · Seatac, WABuilt 2001 · S/N 30792N626ASAlaska Airlines Inc · Seatac, WABuilt 2001 · S/N 30793N626DSBoeing Co · Renton, WABuilt 2025 · S/N 68738N627ASAlaska Airlines Inc · Seattle, WABuilt 2001 · S/N 30794N644ASAlaska Airlines Inc · Seattle, WABuilt 2003 · S/N 30795N721VLUmb Bank Na Trustee · Salt Lake City, UTBuilt 2005 · S/N 34295N7835ASouthwest Airlines Co · Dallas, TXBuilt 2005 · S/N 34294N7843ABank Of Utah Trustee · Salt Lake City, UTBuilt 2006 · S/N 35786N7844ABank Of Utah Trustee · Salt Lake City, UTBuilt 2007 · S/N 35118N7847AUmb Bank Na Trustee · Salt Lake City, UTBuilt 2005 · S/N 34297N7848AUmb Bank Na Trustee · Salt Lake City, UTBuilt 2005 · S/N 34298N784XASale Reported · CuauhtemocSale reportedBuilt 2009 · S/N 33784N7886ABank Of Utah Trustee · Salt Lake City, UTBuilt 2007 · S/N 35122N7887ABank Of Utah Trustee · Salt Lake City, UTBuilt 2007 · S/N 35123N7888ABank Of Utah Trustee · Salt Lake City, UTBuilt 2007 · S/N 35124N788XABank Of Utah Trustee · Salt Lake City, UTBuilt 2004 · S/N 33788N970STNational Nuclear Security Administration · Albuquerque, NMBuilt 2008 · S/N 29645N976JMBank Of Utah Trustee · Salt Lake City, UTS/N 29190
Back to AD 2002-08-52