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.

N915USAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 6387N916ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29517N916NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 31163N916USAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6420N917ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29518N917NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 29572N917UYAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6427N918ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29519N918NNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2013 · S/N 33228N918USAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6443N919ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29520N919CAAc Spe 2 LLC · Orlando, FLBuilt 1991 · S/N 25302N919NNBank Of Utah Owner Trustee · Salt Lake City, UTBuilt 2013 · S/N 29573N919RATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 30174N919USAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6479N920ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29521N920NNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2013 · S/N 31165N920USAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6490N921ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29522N921NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 33229N921USAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6523N922ANAmerican Airlines Inc · Forth Worth, TXBuilt 1999 · S/N 29523N922NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 29574N922USAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6537N923ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29524N923JBJetblue Airways Corp · Long Island City, NYBuilt 2014 · S/N 5960N923NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 31167N923USAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6543N924ANWilmington Trust Co Trustee · Wilmington, DEBuilt 1999 · S/N 29525N924NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 33486N924USAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6569N925ANWilmington Trust Co Trustee · Wilmington, DEBuilt 1999 · S/N 29526N925NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 31169N925UYAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6613N926ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 29527N926NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 33321N926UWAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6618N927ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30077N927NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 31171N927UWAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6625N928AMAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 7515N928ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 29528N928NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 31172N929AAAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 7525N929ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30078N929JBJetblue Airways Corp · Long Island City, NYBuilt 2014 · S/N 6031N929NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 33322N930ANAmerican Airlines Inc · Ft. Worth, TXBuilt 2000 · S/N 29529N930AUAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 7539N930NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 33487
Back to AD 2007-19-13