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.

N322DNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2017 · S/N 7707N322SGAtlas Air Inc · Purchase, NYBuilt 2000 · S/N 30322N323DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 7672N324DXUmb Bank Na Trustee · Salt Lake City, UTBuilt 2017 · S/N 7765N325DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 7709N325FLUmb Bank Na Trustee · Salt Lake City, UTBuilt 2001 · S/N 28325N325USDelta Air Lines Inc · Atlanta, GABuilt 1991 · S/N 281N326DNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2017 · S/N 7845N326FLUmb Bank Na Trustee · Salt Lake City, UTBuilt 2001 · S/N 28326N327DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 7777N328DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 7840N328NWDelta Air Lines Inc · Atlanta, GABuilt 1992 · S/N 298N329DNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2017 · S/N 7885N329NWDelta Air Lines Inc · Atlanta, GABuilt 1992 · S/N 306N329ZAKalitta Air LLC · Ypsilanti, MIBuilt 2003 · S/N 32914N3300CCsds Asset Management LLC · Marana, AZS/N 211N330ADBank Of Utah Trustee · Salt Lake City, UTS/N 330N330AEBank Of Utah Trustee · Salt Lake City, UTS/N 33007N330DXBank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 7896N330QTWilmington Trust Co Trustee · Wilmington, DEBuilt 2012 · S/N 1368N331AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1991 · S/N 24875N331DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 7943N331QTWilmington Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 1380N33203United Airlines Inc · Chicago, ILBuilt 2000 · S/N 30613N33209United Airlines Inc · Chicago, ILBuilt 2000 · S/N 30581N33262United Airlines Inc · Chicago, ILBuilt 2001 · S/N 32402N33264United Airlines Inc · Chicago, ILBuilt 2001 · S/N 31584N33266United Airlines Inc · Chicago, ILBuilt 2001 · S/N 32403N33284Umb Bank Na Trustee · Salt Lake City, UTBuilt 2004 · S/N 31635N33286United Airlines Inc · Chicago, ILBuilt 2004 · S/N 31600N33289United Airlines Inc · Chicago, ILBuilt 2004 · S/N 31607N33292United Airlines Inc · Chicago, ILBuilt 2004 · S/N 33455N33294Wells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2005 · S/N 34000N332DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 7973N332QTWilmington Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 1428N333DXBank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 8026N333NWDelta Air Lines Inc · Atlanta, GABuilt 1992 · S/N 329N334DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 8040N334NWDelta Air Lines Inc · Atlanta, GABuilt 1992 · S/N 339N334QTWilmington Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 1448N335DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 8036N335NWDelta Air Lines Inc · Atlanta, GABuilt 1992 · S/N 340N335PHAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 31265N335QTWilmington Trust Co Trustee · Wilmington, DEBuilt 2014 · S/N 1534N336DXBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 8063N336NWDelta Air Lines Inc · Atlanta, GABuilt 1992 · S/N 355N336QTWilmington Trust Co Trustee · Wilmington, DEBuilt 2014 · S/N 1506N337AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1994 · S/N 27060N337DNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2018 · S/N 8080N337JXJetonex LLC · Sunny Isles Beach, FLS/N 33734
Back to AD 2007-19-13