AD 2018-20-13

Registered aircraft · 2,770

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

N920DUBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 63533N920NNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2013 · S/N 31165N920UPBoeing Co · Renton, WABuilt 2026 · S/N 68366N921AKBank Of Utah Trustee · Salt Lake City, UTS/N 43337N921ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29522N921DUBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 63532N921NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 33229N921UPBoeing Co · Renton, WABuilt 2026 · S/N 68367N922ANAmerican Airlines Inc · Forth Worth, TXBuilt 1999 · S/N 29523N922DZBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 64886N922NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 29574N922TSAero Micronesia Inc DBA · Barrigada, GUBuilt 1990 · S/N 24845N922UPBoeing Co · Renton, WABuilt 2026 · S/N 68368N923ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29524N923DZDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 64887N923FDFederal Express Corp · Memphis, TNS/N 26266N923NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 31167N923UPBoeing Co · Renton, WABuilt 2026 · S/N 68369N924AKBank Of Utah Trustee · Salt Lake City, UTBuilt 2021 · S/N 43333N924ANWilmington Trust Co Trustee · Wilmington, DEBuilt 1999 · S/N 29525N924DZBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 63536N924FDFederal Express Corp · Memphis, TNBuilt 1993 · S/N 26267N924NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 33486N924UPBoeing Co · Renton, WAS/N 68370N925ANWilmington Trust Co Trustee · Wilmington, DEBuilt 1999 · S/N 29526N925DZBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 63535N925FDFederal Express Corp · Memphis, TNBuilt 1994 · S/N 27238N925NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 31169N925UPBoeing Co · Renton, WAS/N 70801N9264UTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 44009N926AKBank Of Utah Trustee · Salt Lake City, UTBuilt 2021 · S/N 43314N926ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 29527N926DZBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 63534N926NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 33321N926UPBoeing Co · Renton, WAS/N 70802N927ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30077N927DZBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 64888N927FDFederal Express Corp · Memphis, TNBuilt 1994 · S/N 27220N927NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 31171N927UPBoeing Co · Renton, WAS/N 70803N928AKAlaska Airlines Inc · Seattle, WABuilt 2022 · S/N 44099N928ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 29528N928DUBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 63537N928NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 31172N929AKBank Of Utah Trustee · Salt Lake City, UTBuilt 2021 · S/N 43322N929ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30078N929DZBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 63538N929NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 33322N929UPBoeing Co · Renton, WAS/N 70804N930ANAmerican Airlines Inc · Ft. Worth, TXBuilt 2000 · S/N 29529
Back to AD 2018-20-13