AD 2007-19-13

Registered aircraft · 2,446

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:2007-19-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:2007-19-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.

N35260United Airlines Inc · Chicago, ILBuilt 2001 · S/N 30855N35271United Airlines Inc · Chicago, ILBuilt 2001 · S/N 31589N352DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 8283N352NWDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 778N352PSWilmington Trust Co Trustee · Wilmington, DEBuilt 2017 · S/N 33256N353ASAersale Inc · Coral Gables, FLS/N 553N353AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1992 · S/N 25198N353DNDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 8322N353NWDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 786N354DNDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 8332N354NWDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 801N354PTAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 31275N355DNDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 8359N355FLBank Of Utah Trustee · Salt Lake City, UTS/N 2553N355NWDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 807N355PUAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 33348N356DNDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 8279N356KDAtares Funding LLC · Miami Beach, FLBuilt 1994 · S/N 26356N356NWDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 818N357DCAwas 3896 Trust · Wilmington, DES/N 3896N357DNDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 8339N357NWDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 830N357PVWilmington Trust Co Trustee · Wilmington, DEBuilt 2017 · S/N 31277N358CLIagcas LLC · Tucson, AZFirst renewal noticeS/N 28358N358DNDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 8316N358NWDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 832N358PWWilmington Trust Co Trustee · Wilmington, DEBuilt 2017 · S/N 33349N359AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1988 · S/N 24036N359DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 8370N359NWDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 846N359PXAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 31280N360DNDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 8388N360HAAlc A332 1732 LLC · Camden, DEBuilt 2016 · S/N 1732N360NWDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 0903N361DNDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 8423N361HAWilmington Trust Co Trustee · Wilmington, DEBuilt 2017 · S/N 1823N361NWDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 0907N36207United Airlines Inc · Chicago, ILBuilt 2000 · S/N 30579N36247United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28807N36272United Airlines Inc · Chicago, ILBuilt 2001 · S/N 31590N36280United Airlines Inc · Chicago, ILBuilt 2003 · S/N 31598N362CMCargo Aircraft Management Inc · Wilmington, OHS/N 24316N362DNDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 8447N362NWDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 0911N362UPUnited Parcel Service Co · Louisville, KYS/N 33493N363CMCargo Aircraft Management Inc · Wilmington, OHS/N 24853N363DNDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 8502N363NWDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 0923N363UPUnited Parcel Service Co · Louisville, KYBuilt 2003 · S/N 33494N364CMCargo Aircraft Management Inc · Wilmington, OHS/N 24531
Back to AD 2007-19-13