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.

N715JBJetblue Airways Corp · Long Island City, NYBuilt 2008 · S/N 3554N716FRWells Fargo Trust Co Na Trustee · Salt Lake City, UTBuilt 2017 · S/N 7524N717FDFederal Express Corp · Memphis, TNBuilt 1987 · S/N 361N717FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 7536N718FRUmb Bank Na Trustee · Salt Lake City, UTBuilt 2017 · S/N 7575N719FDFederal Express Corp · Memphis, TNBuilt 1989 · S/N 388N719FRWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2017 · S/N 7736N720FRWilmington Trust Co Trustee · Wilmington, DEBuilt 2017 · S/N 7852N721FDFederal Express Corp · Memphis, TNS/N 477N721FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 7884N722FDFederal Express Corp · Memphis, TNBuilt 1988 · S/N 479N722FRAlc A321 8579 LLC · Camden, DEBuilt 2018 · S/N 8579N723FDFederal Express Corp · Memphis, TNBuilt 1990 · S/N 543N723FRAlc A321 8640 LLC · Camden, DEBuilt 2018 · S/N 8640N724AVBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 6153N724FDFederal Express Corp · Memphis, TNBuilt 1989 · S/N 530N725FDFederal Express Corp · Memphis, TNS/N 572N726FDFederal Express Corp · Memphis, TNBuilt 1990 · S/N 575N727FDFederal Express Corp · Memphis, TNBuilt 1991 · S/N 579N728AVBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 6209N728FDFederal Express Corporation · Memphis, TNBuilt 1990 · S/N 581N729CAAc Spe 6 LLC · Orlando, FLBuilt 1991 · S/N 25068N729FDFederal Express Corp · Memphis, TNBuilt 1992 · S/N 657N729JBJetblue Airways Corp · Long Island City, NYS/N 3572N730FDFederal Express Corp · Memphis, TNBuilt 1992 · S/N 659N731FDFederal Express Corp · Memphis, TNBuilt 1993 · S/N 709N73251United Airlines Inc · Chicago, ILBuilt 2000 · S/N 30582N73256United Airlines Inc · Chicago, ILBuilt 2000 · S/N 30611N73259United Airlines Inc · Chicago, ILBuilt 2001 · S/N 30803N73270United Airlines Inc · Chicago, ILBuilt 2001 · S/N 31632N73275United Airlines Inc · Chicago, ILBuilt 2002 · S/N 31593N73276United Airlines Inc · Chicago, ILBuilt 2002 · S/N 31594N73278United Airlines Inc · Chicago, ILBuilt 2003 · S/N 31596N73283Umb Bank Na Trustee · Salt Lake City, UTBuilt 2004 · S/N 31606N73291Umb Bank Na Trustee · Salt Lake City, UTBuilt 2004 · S/N 33454N73299United Airlines Inc · Chicago, ILBuilt 2005 · S/N 34005N732FDFederal Express Corporation · Memphis, TNBuilt 1993 · S/N 713N733FDFederal Express Corp · Memphis, TNBuilt 1993 · S/N 715N74007United Airlines Inc · Chicago, ILBuilt 1999 · S/N 29477N740AVWells Fargo Trust Co Na Trustee · Salt Lake City, UTBuilt 2015 · S/N 6411N740AXCargo Aircraft Management Inc · Wilmington, OHBuilt 1983 · S/N 22213N740FDFederal Express Corp · Memphis, TNBuilt 1990 · S/N 559N741FDFederal Express Corp · Memphis, TNBuilt 1991 · S/N 611N742AVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2015 · S/N 6692N742CKKalitta Air LLC · Ypsilanti, MIS/N 24424N742FDFederal Express Corp · Memphis, TNBuilt 1991 · S/N 613N743AVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2015 · S/N 6739N743CKKalitta Air LLC · Ypsilanti, MIBuilt 1993 · S/N 26350N743FDFederal Express Corp · Memphis, TNBuilt 1992 · S/N 630N744AXCargo Aircraft Management Inc · Wilmington, OHBuilt 1983 · S/N 22221
Back to AD 2007-19-13