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.

N812AKAlaska Airlines Inc · Seattle, WABuilt 2025 · S/N 68518N812DNDelta Air Lines Inc · Atlanta, GABuilt 2013 · S/N 31923N812NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 33520N812UPAmerican Airlines Inc · Fort Worth, TXBuilt 2025 · S/N 68205N813AKAlaska Airlines Inc · Seattle, WABuilt 2025 · S/N 67441N813DNDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 31925N813NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 30918N813VLUmb Bank Na Trustee · Salt Lake City, UTBuilt 2009 · S/N 35353N81449United Airlines Inc · Chicago, ILBuilt 2012 · S/N 31651N814AKAlaska Airlines Inc · Seatac, WABuilt 2025 · S/N 67509N814DNDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 31924N814NNAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 29562N815AKAlaska Airlines Inc · Seattle, WABuilt 2025 · S/N 68539N815DNDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 31926N815NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 33208N816AKAlaska Airlines Inc · Seattle, WABuilt 2025 · S/N 67511N816DNDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 31927N816NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 31081N817DNDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 31929N817NNAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 29558N818DADelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 31928N818NHAersale Inc · Doral, FLBuilt 2000 · S/N 29311N818NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 30910N819DNDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 31930N819NNAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 31083N820DNDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 31931N820NNAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 29559N821AKAlaska Airlines Inc · Seatac, WABuilt 2025 · S/N 67510N821DNDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 31932N821NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 30912N822DNDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 31933N822NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 31085N823AKAlaska Airlines Inc · Seatac, WABuilt 2025 · S/N 68528N823DNDelta Airlines Inc · Atlanta, GABuilt 2014 · S/N 31934N823NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 29560N823SYSun Country Inc · Minneapolis, MNS/N 33971N824DNDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 31935N824NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 30916N824SYSun Country Inc · Minneapolis, MNBuilt 2005 · S/N 33976N825AMWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2014 · S/N 36699N825DNDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 31936N825MHDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 29703N825NNAmerican Airlines Inc · Fort Worth, TXBuilt 2010 · S/N 31087N826DNDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 31937N826MHDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 29713N826NNAmerican Airlines Inc · Fort Worth, TXBuilt 2010 · S/N 31089N827DNDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 31938N827MHDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 29705N827NNAmerican Airlines Inc · Fort Worth, TXBuilt 2010 · S/N 33209N828DNDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 31939
Back to AD 2018-20-13