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.

N534UWAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 3989N535ASAlaska Airlines Inc · Seattle, WABuilt 2011 · S/N 35200N535JBJetblue Airways Corp · Long Island City, NYBuilt 2002 · S/N 1739N535UWAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 3993N536ASAlaska Airlines Inc · Seattle, WABuilt 2012 · S/N 35203N536AVWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2012 · S/N 5360N536JBJetblue Airways Corp · Long Island City, NYBuilt 2002 · S/N 1784N536UWAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 4025N537ASAlaska Airlines Inc · Seatac, WABuilt 2012 · S/N 35204N537CAAc Spe 10 LLC · Orlando, FLBuilt 2004 · S/N 33749N537JTJetblue Airways Corp · Long Island City, NYBuilt 2002 · S/N 1785N537UWAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 4041N538ASAlaska Airlines Inc · Seattle, WABuilt 2012 · S/N 41188N538AVWilmington Trust Co Trustee · Wilmington, DEBuilt 2012 · S/N 5398N538LAQuetro Aircraft Leasing Trust · Wilmington, DEBuilt 2006 · S/N 34628N538UWAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 4050N539UWAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 4082N540LACaiquen Leasing LLC · Wilmington, DEBuilt 2006 · S/N 35229N540UWAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 4107N54241United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28953N542LAQuetro Aircraft Leasing Trust · Wilmington, DEBuilt 2008 · S/N 34629N542UWAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 4134N543UWAmerican Airlines Inc · Fort Worth, TXBuilt 2011 · S/N 4843N544UWAmerican Airlines Inc · Fort Worth, TXBuilt 2011 · S/N 4847N545UWAmerican Airlines Inc · Fort Worth, TXBuilt 2011 · S/N 4850N546ASAlaska Airlines Inc · Seattle, WABuilt 2005 · S/N 30022N546UWAmerican Airlines Inc · Fort Worth, TXBuilt 2011 · S/N 4885N547JBBank Of Utah Trustee · Salt Lake City, UTBuilt 2002 · S/N 1849N548ASAlaska Airlines Inc · Seattle, WABuilt 2005 · S/N 30020N549UWAmerican Airlines Inc · Fort Worth, TXBuilt 2011 · S/N 4932N551ASAlaska Airlines Inc · Seattle, WABuilt 2006 · S/N 34593N551UWUmb Bank N A Trustee · Salt Lake City, UTBuilt 2011 · S/N 4940N552ASAlaska Airlines Inc · Seattle, WABuilt 2006 · S/N 34595N552JBBank Of Utah Trustee · Salt Lake City, UTBuilt 2002 · S/N 1861N552UWUmb Bank Na Trustee · Salt Lake City, UTBuilt 2011 · S/N 4957N553ASAlaska Airlines Inc · Seattle, WABuilt 2006 · S/N 34594N553UWUmb Bank Na Trustee · Salt Lake City, UTBuilt 2011 · S/N 4960N554JBBank Of Utah Trustee · Salt Lake City, UTBuilt 2002 · S/N 1898N554UWUmb Bank Na Trustee · Salt Lake City, UTBuilt 2011 · S/N 4966N556ASAlaska Airlines Inc · Seattle, WABuilt 2006 · S/N 35175N556JBJetblue Airways Corp · Long Island City, NYBuilt 2002 · S/N 1904N556UWAmerican Airlines Inc · Fort Worth, TXBuilt 2012 · S/N 5244N557ASAlaska Airlines Inc · Seattle, WABuilt 2006 · S/N 35176N557UWAmerican Airlines Inc · Fort Worth, TXBuilt 2012 · S/N 5269N558ASAlaska Airlines Inc · Seattle, WABuilt 2006 · S/N 35177N558JBBank Of Utah Trustee · Salt Lake City, UTBuilt 2003 · S/N 1915N558UWUmb Bank Na Trustee · Salt Lake City, UTBuilt 2012 · S/N 5282N559ASAlaska Airlines Inc · Seattle, WABuilt 2006 · S/N 35178N559JBJetblue Airways Corp · Long Island City, NYBuilt 2003 · S/N 1917N559UWAmerican Airlines Inc · Fort Worth, TXBuilt 2012 · S/N 5292
Back to AD 2007-19-13