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.

N337PJWilmington Trust Co Trustee · Wilmington, DEBuilt 2017 · S/N 33345N337QTBank Of Utah Trustee · Salt Lake City, UTBuilt 2006 · S/N 791N338DNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2018 · S/N 8078N338NWDelta Air Lines Inc · Atlanta, GABuilt 1992 · S/N 360N338PKWilmington Trust Co Trustee · Wilmington, DEBuilt 2017 · S/N 31268N338QTBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 1382N339DNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2018 · S/N 8128N339NWDelta Air Lines Inc · Atlanta, GABuilt 1992 · S/N 367N339PLWilmington Trust Co Trustee · Wilmington, DEBuilt 2017 · S/N 33346N340DNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2018 · S/N 8180N340NWDelta Air Lines Inc · Atlanta, GABuilt 1992 · S/N 372N340YYValiair Lc Trustee · Casper, WYS/N 764N341DNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2018 · S/N 8134N341NWDelta Air Lines Inc · Atlanta, GABuilt 1992 · S/N 380N34222United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28931N34282Umb Bank Na Trustee · Salt Lake City, UTBuilt 2004 · S/N 31634N342AVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2012 · S/N 1342N342DNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2018 · S/N 8159N342NWDelta Air Lines Inc · Atlanta, GABuilt 1992 · S/N 381N342PMWilmington Trust Co Trustee · Wilmington, DEBuilt 2017 · S/N 31269N343DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 8200N343NWDelta Air Lines Inc · Atlanta, GABuilt 1992 · S/N 387N343PNWilmington Trust Co Trustee · Wilmington, DEBuilt 2017 · S/N 31270N344CMCargo Aircraft Management Inc · Wilmington, OHS/N 28745N344DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 8171N344KDAtares Funding LLC · Miami Beach, FLBuilt 1992 · S/N 26344N344NWDelta Air Lines Inc · Atlanta, GABuilt 1992 · S/N 388N344PPWilmington Trust Co Trustee · Wilmington, DEBuilt 2017 · S/N 31272N345AVAircol 20 · Wilmington, DEBuilt 2010 · S/N 4345N345DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 8191N345NWDelta Air Lines Inc · Atlanta, GABuilt 1993 · S/N 399N346DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 8227N346PRWilmington Trust Co Trustee · Wilmington, DEBuilt 2017 · S/N 31273N347AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1994 · S/N 26264N347CMCargo Aircraft Management Inc · Wilmington, OHBuilt 1993 · S/N 26995N347DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 8250N347NWDelta Air Lines Inc · Atlanta, GABuilt 1993 · S/N 408N348DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 8258N348NWDelta Air Lines Inc · Atlanta, GABuilt 1993 · S/N 410N349CMCargo Aircraft Management Inc · Wilmington, OHBuilt 1993 · S/N 26996N349DXBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 8233N349NWDelta Air Lines Inc · Atlanta, GABuilt 1993 · S/N 417N350DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 8207N350NADelta Air Lines Inc · Atlanta, GABuilt 1993 · S/N 418N3518JJetran LLC · Horseshoe Bay, TXS/N 35108N351CMCargo Aircraft Management Inc · Wilmington, OHBuilt 1992 · S/N 25201N351DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 8251N351NWDelta Air Lines Inc · Atlanta, GABuilt 1997 · S/N 766N35204United Airlines Inc · Chicago, ILBuilt 2000 · S/N 30576N35236United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28801
Back to AD 2007-19-13