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.

N8555ZSouthwest Airlines Co · Dallas, TXBuilt 2017 · S/N 63600N8556ZSouthwest Airlines Co · Dallas, TXBuilt 2017 · S/N 63583N8557QSouthwest Airlines Co · Dallas, TXBuilt 2017 · S/N 63582N8558ZSouthwest Airlines Co · Dallas, TXBuilt 2017 · S/N 63602N8559QSouthwest Airlines Co · Dallas, TXBuilt 2018 · S/N 63584N855NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 40582N855NWDelta Air Lines Inc · Atlanta, GABuilt 2004 · S/N 0621N8560ZSouthwest Airlines Co · Dallas, TXBuilt 2018 · S/N 64115N8561ZSouthwest Airlines Co · Dallas, TXBuilt 2018 · S/N 63585N8562ZSouthwest Airlines Co · Dallas, TXBuilt 2018 · S/N 64171N8563ZSouthwest Airlines Co · Dallas, TXBuilt 2018 · S/N 64172N8564ZSouthwest Airlines Co · Dallas, TXBuilt 2018 · S/N 42545N8565ZUmb Bank Na Trustee · Salt Lake City, UTBuilt 2018 · S/N 42533N8566ZUmb Bank Na Trustee · Salt Lake City, UTBuilt 2018 · S/N 64174N8567ZSouthwest Airlines Co · Dallas, TXBuilt 2018 · S/N 36928N8568ZUmb Bank Na Trustee · Salt Lake City, UTBuilt 2018 · S/N 64248N8569ZSouthwest Airlines Co · Dallas, TXBuilt 2018 · S/N 36954N856NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 31107N856NWDelta Air Lines Inc · Atlanta, GABuilt 2004 · S/N 0631N8570WSouthwest Airlines Co · Dallas, TXBuilt 2018 · S/N 36952N8571ZSouthwest Airlines Co · Dallas, TXBuilt 2018 · S/N 36957N8572XSouthwest Airlines Co · Dallas, TXBuilt 2018 · S/N 64251N8573ZSouthwest Airlines Co · Dallas, TXBuilt 2018 · S/N 64250N8574ZBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 63588N8575ZSouthwest Airlines Co · Dallas, TXBuilt 2018 · S/N 63589N8576ZBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 63590N8577ZBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 64350N8578QBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 64349N8579ZBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 63591N857NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 30907N857NWDelta Air Lines Inc · Atlanta, GABuilt 2004 · S/N 0633N8580ZBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 64347N8581ZBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 64348N8582ZBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 64801N8583ZBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 64799N8584ZBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 64800N858NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 30904N858NWDelta Air Lines Inc · Atlanta, GABuilt 2006 · S/N 0718N859AMUmb Bank Na Trustee · Salt Lake City, UTBuilt 2003 · S/N 32796N859NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 29555N859NWDelta Air Lines Inc · Atlanta, GABuilt 2006 · S/N 0722N860DAWilmington Trust Co Trustee · Wilmington, DEBuilt 1999 · S/N 29951N860NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 40583N860NWDelta Air Lines Inc · Atlanta, GABuilt 2006 · S/N 0778N861NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 31109N861NWDelta Air Lines Inc · Atlanta, GABuilt 2006 · S/N 0796N862AVAircol 23 · Wilmington, DEBuilt 2011 · S/N 4862N862DAWilmington Trust Co Trustee · Wilmington, DEBuilt 1999 · S/N 29734N862NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 30905N863DAWilmington Trust Co Trustee · Wilmington, DEBuilt 1999 · S/N 29735
Back to AD 2007-19-13