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.

N972NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 33334N973AKAlaska Airlines Inc · Seattle, WABuilt 2021 · S/N 43346N973ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 29548N973NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 31219N97424Umb Bank Na Trustee · Salt Lake City, UTBuilt 2026 · S/N 67655N974AKAlaska Airlines Inc · Seatac, WABuilt 2022 · S/N 64963N974AMAlc B379 66438 LLC · Los Angeles, CABuilt 2023 · S/N 66438N974ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30098N975AKAlaska Airlines Inc · Seattle, WABuilt 2021 · S/N 64960N975ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 29549N976AKAlaska Airlines Inc · Seattle, WABuilt 2022 · S/N 64967N976ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30099N976JMBank Of Utah Trustee · Salt Lake City, UTS/N 29190N976NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2015 · S/N 33243N977AKAlaska Airlines Inc · Seatac, WABuilt 2022 · S/N 43391N977NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 31225N978AKAlaska Airlines Inc · Seattle, WABuilt 2022 · S/N 43348N978ANMsn 30100 Trust · Wilmington, DEBuilt 2001 · S/N 30100N978FDFederal Express Corp · Memphis, TNBuilt 1988 · S/N 24119N978NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 31226N979AKAlaska Airlines Inc · Seatac, WABuilt 2021 · S/N 43393N979ANWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 29568N979FDFederal Express Corp · Memphis, TNBuilt 1992 · S/N 25592N979NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 31228N980ANWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 33203N980NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 31229N981ANAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 29569N981NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 31230N982AKAlaska Airlines Inc · Seatac, WABuilt 2023 · S/N 67422N982ANWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 31067N982NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 31231N983AKAlaska Airlines Inc · Seattle, WABuilt 2023 · S/N 67505N983ANAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 29570N983NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 33337N984AKAlaska Airlines Inc · Seattle, WABuilt 2023 · S/N 67499N984NNAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 31234N985AKAlaska Airlines Inc · Seattle, WABuilt 2023 · S/N 67423N985NNAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 31233N986FDFederal Express Corp · Memphis, TNBuilt 1997 · S/N 28482N986NNAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 31236N987ANWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 31069N987FDFederal Express Corp · Memphis, TNBuilt 1997 · S/N 28483N987NNAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 33247N988FDFederal Express Corp · Memphis, TNBuilt 1993 · S/N 26705N988NNAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 31237N989ANWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 33205N989FDFederal Express Corp · Memphis, TNBuilt 1997 · S/N 28480N989NNAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 33338N990AKAlaska Airlines Inc · Seatac, WABuilt 2023 · S/N 67424N990ANAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 29563
Back to AD 2018-20-13