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.

N390DADelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30536N390DNDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 9066N390HAWilmington Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 1389N391CMCargo Aircraft Management Inc · Wilmington, OHBuilt 2002 · S/N 32975N391DADelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30560N391DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 9027N391HAHawaiian Airlines Inc · Seatac, WABuilt 2013 · S/N 1399N391UPCargo Aircraft Management Inc · Wilmington, OHS/N 28039N39297United Airlines Inc · Chicago, ILBuilt 2005 · S/N 34003N392DADelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30561N392DNDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 9028N392HAWilmington Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 1404N392UPCargo Aircraft Management Inc · Wilmington, OHBuilt 1996 · S/N 28041N393DADelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30377N393DNDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 9067N393HAAlaska Airlines Inc · Seatac, WABuilt 2013 · S/N 1422N393UPCargo Aircraft Management Inc · Wilmington, OHBuilt 1998 · S/N 29228N394DADelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30562N394DXDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 9125N394UPCargo Aircraft Management Inc · Wilmington, OHBuilt 1991 · S/N 25136N395CMCargo Aircraft Management Inc · Wilmington, OHBuilt 1992 · S/N 25447N395DNDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30773N395DZDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 9126N395HAAlaska Airlines Inc · Seattle, WABuilt 2013 · S/N 1469N395UPCargo Aircraft Management Inc · Wilmington, OHBuilt 1998 · S/N 29229N396CMCargo Aircraft Management Inc · Wilmington, OHBuilt 1991 · S/N 25195N396DADelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30378N396DNDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 9128N396HAHawaiian Airlines Inc · Seattle, WABuilt 2014 · S/N 1488N396UPUnited Parcel Service Co · Louisville, KYBuilt 2010 · S/N 40364N397ACTvpx Trust Co LLC Trustee · North Salt Lake, UTS/N 2982N397AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1988 · S/N 24035N397DADelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30537N397DNDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 9176N397UPUnited Parcel Service Co · Louisville, KYBuilt 2010 · S/N 40363N398AVAircol 6 Statutory Trust · Wilmington, DEBuilt 2009 · S/N 3988N398DADelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30774N398DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2020 · S/N 9360N399DADelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30379N399HAHawaiian Airlines Inc · Seattle, WABuilt 2014 · S/N 1496N401AVAircol 8 · Wilmington, DEBuilt 2009 · S/N 4001N401UAUnited Airlines Inc · Chicago, ILBuilt 1993 · S/N 435N402UAUnited Airlines Inc · Chicago, ILBuilt 1993 · S/N 439N404KZWilmington Trust Co Trustee · Wilmington, DEBuilt 2007 · S/N 34283N404UAUnited Airlines Inc · Chicago, ILBuilt 1993 · S/N 450N405KZWilmington Trust Co Trustee · Wilmington, DEBuilt 2007 · S/N 36132N406KZWilmington Trust Co Trustee · Wilmington, DEBuilt 2007 · S/N 36133N406UAUnited Airlines Inc · Chicago, ILBuilt 1994 · S/N 454N410GXWilmington Trust Co Trustee · Wilmington, DEBuilt 2000 · S/N 01199N411AEBank Of Utah Trustee · Salt Lake City, UTBuilt 2010 · S/N 4411
Back to AD 2007-19-13