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.

N560ASAlaska Airlines Inc · Seatac, WABuilt 2006 · S/N 35179N560UWAmerican Airlines Inc · Fort Worth, TXBuilt 2012 · S/N 5300N561JBBank Of Utah Trustee · Salt Lake City, UTBuilt 2003 · S/N 1927N561UWAmerican Airlines Inc · Fort Worth, TXBuilt 2012 · S/N 5317N562ASBank Of Utah Trustee · Salt Lake City, UTBuilt 2006 · S/N 35091N562AVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2013 · S/N 5622N562JBBank Of Utah Trustee · Salt Lake City, UTBuilt 2003 · S/N 1948N562UWAmerican Airlines Inc · Fort Worth, TXBuilt 2012 · S/N 5332N563ASAlaska Airlines Inc · Seatac, WABuilt 2006 · S/N 35180N563JBBank Of Utah Trustee · Salt Lake City, UTBuilt 2003 · S/N 2006N563UWAmerican Airlines Inc · Fort Worth, TXBuilt 2012 · S/N 5368N564ASBank Of Utah Trustee · Salt Lake City, UTBuilt 2006 · S/N 35103N564JBJetblue Airways Corp · Long Island City, NYBuilt 2003 · S/N 2020N564LATagua Owner Trust · Wilmington, DEBuilt 2012 · S/N 40593N565ASAlaska Airlines Inc · Seattle, WABuilt 2006 · S/N 35181N565JBBank Of Utah Trustee · Salt Lake City, UTBuilt 2003 · S/N 2031N566ASAlaska Airlines Inc · Seattle, WABuilt 2007 · S/N 35182N566JBJetblue Airways Corp · Long Island City, NYBuilt 2003 · S/N 2042N566LAJilguero Owner Trust · Wilmington, DEBuilt 2011 · S/N 40798N567AVBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 4567N567UWAmerican Airlines Inc · Fort Worth, TXBuilt 2013 · S/N 5728N568ASAlaska Airlines Inc · Seattle, WABuilt 2007 · S/N 35183N568JBJetblue Airways Corp · Long Island City, NYBuilt 2003 · S/N 2063N568LATagua Owner Trust · Wilmington, DEBuilt 2012 · S/N 42214N568UWAmerican Airlines Inc · Fort Worth, TXBuilt 2013 · S/N 5751N569ASAlaska Airlines Inc · Seatac, WABuilt 2007 · S/N 35184N569AZAmazon.Com Services LLC · Seattle, WAS/N 25246N569CAAc Spe 11 LLC · Orlando, FLS/N 30763N569JBJetblue Airways Corp · Long Island City, NYBuilt 2003 · S/N 2075N57016United Airlines Inc · Chicago, ILBuilt 2000 · S/N 28679N570ASAlaska Airlines Inc · Seattle, WABuilt 2007 · S/N 35185N570JBJetblue Airways Corp · Long Island City, NYBuilt 2003 · S/N 2099N570LATagua Owner Trust · Wilmington, DEBuilt 2012 · S/N 40799N570TABank Of Utah Trustee · Salt Lake City, UTBuilt 2009 · S/N 3869N571ASUmb Bank Na Trustee · Salt Lake City, UTS/N 32904N571AZAmazon.Com Services LLC · Seattle, WABuilt 2000 · S/N 30388N571JBJetblue Airways Corp · Long Island City, NYBuilt 2003 · S/N 2125N572LATagua Owner Trust · Wilmington, DEBuilt 2012 · S/N 41747N572UWAmerican Airlines Inc · Fort Worth, TXBuilt 2013 · S/N 5899N573UWAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 5939N575UWAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 5980N576UWAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 6027N577ASAlaska Airlines Inc · Seattle, WABuilt 2007 · S/N 35186N577NANasa Langley Research Center · Hampton, VAS/N 32892N577TABank Of Utah Trustee · Salt Lake City, UTS/N 355N578UWAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 6035N579ASAlaska Airlines Inc · Seattle, WABuilt 2007 · S/N 35187N579JBBank Of Utah Trustee · Salt Lake City, UTBuilt 2003 · S/N 2132N579UWAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 6100N580JBBank Of Utah Trustee · Salt Lake City, UTBuilt 2003 · S/N 2136
Back to AD 2007-19-13