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.

N828MHDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 29699N829DNDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 31941N829MHDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 29700N829NNAmerican Airlines Inc · Fort Worth, TXBuilt 2010 · S/N 33210N830DNDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 31940N830MHDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 29701N830NNAmerican Airlines Inc · Fort Worth, TXBuilt 2010 · S/N 31091N831DNDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 31942N831MHDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 29702N831NNAmerican Airlines Inc · Fort Worth, TXBuilt 2010 · S/N 33211N832DNDelta Air Lines Inc · Atlanta, GABuilt 2015 · S/N 31943N832MHDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 29704N832NNAmerican Airlines Inc · Fort Worth, TXBuilt 2010 · S/N 33521N833DNDelta Air Lines Inc · Atlanta, GABuilt 2015 · S/N 31944N833MHDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 29706N833NNAmerican Airlines Inc · Fort Worth, TXBuilt 2010 · S/N 31093N834ASAersale Inc · Coral Gables, FLS/N 28834N834DNDelta Air Lines Inc · Atlanta, GABuilt 2015 · S/N 31946N834MHDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 29707N834NNAmerican Airlines Inc · Fort Worth, TXBuilt 2010 · S/N 29576N835DNDelta Air Lines Inc · Atlanta, GABuilt 2015 · S/N 31945N835MHDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 29708N835NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2010 · S/N 29577N836DNDelta Air Lines Inc · Atlanta, GABuilt 2015 · S/N 31947N836MHDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 29709N836NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 31095N837AMAlc B379 65190 LLC · Los Angeles, CABuilt 2023 · S/N 65190N837DNDelta Air Lines Inc · Atlanta, GABuilt 2015 · S/N 31948N837MHDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 29710N837NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 30908N838AKAlaska Airlines Inc · Seatac, WABuilt 2026 · S/N 68529N838AMAlc B379 43392 LLC · Los Angeles, CAS/N 43392N838DNDelta Air Lines Inc · Atlanta, GABuilt 2015 · S/N 31949N838MHDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 29711N838NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 31097N839AKAlaska Airlines Inc · Seattle, WABuilt 2026 · S/N 68540N839DNDelta Air Lines Inc · Atlanta, GABuilt 2015 · S/N 31950N839MHDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 29712N839NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 29557N839SYBank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 42083N840DNDelta Air Lines Inc · Atlanta, GABuilt 2015 · S/N 31951N840MHDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 29718N840NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 33518N840SYBank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 42084N841DNDelta Air Lines Inc · Atlanta, GABuilt 2015 · S/N 31952N841MHDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 29714N841NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 30914N842AKAlaska Airlines Inc · Seattle, WABuilt 2026 · S/N 68530N842DNDelta Air Lines Inc · Atlanta, GABuilt 2015 · S/N 31953N842MHDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 29715
Back to AD 2018-20-13