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.

N827NNAmerican Airlines Inc · Fort Worth, TXBuilt 2010 · S/N 33209N827NWBank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 1716N827QDelaware Aircraft Trust LLC Trustee · New Castle, DES/N 0827N828CAAc Spe 13 LLC · Orlando, FLBuilt 2012 · S/N 1279N828JBJetblue Airways Corp · Long Island City, NYBuilt 2013 · S/N 5723N828NWBank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 1720N829NNAmerican Airlines Inc · Fort Worth, TXBuilt 2010 · S/N 33210N829NWBank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 1721N829WWHemisphere Aerospace Investments LLC · Waco, TXS/N 27503N830KWAlta 777 LLC · Salt Lake City, UTS/N 30870N830NNAmerican Airlines Inc · Fort Worth, TXBuilt 2010 · S/N 31091N830NWDelta Air Lines Inc · Atlanta, GABuilt 2017 · S/N 1769N831NNAmerican Airlines Inc · Fort Worth, TXBuilt 2010 · S/N 33211N831NWDelta Air Lines Inc · Atlanta, GABuilt 2017 · S/N 1783N832NNAmerican Airlines Inc · Fort Worth, TXBuilt 2010 · S/N 33521N833KWAlta 777 LLC · Salt Lake City, UTS/N 30868N833NNAmerican Airlines Inc · Fort Worth, TXBuilt 2010 · S/N 31093N834JBJetblue Airways Corp · Long Island City, NYBuilt 2013 · S/N 5782N834KWAlta 777 LLC · Salt Lake City, UTS/N 32317N834NNAmerican Airlines Inc · Fort Worth, TXBuilt 2010 · S/N 29576N835NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2010 · S/N 29577N836NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 31095N837NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 30908N837VABank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 4558N838NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 31097N839NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 29557N839SYBank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 42083N840KWAlta 777 LLC · Salt Lake City, UTS/N 32890N840NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 33518N840SYBank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 42084N841NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 30914N842NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 31099N843NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 30906N844NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 33212N845AMWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2014 · S/N 36706N845NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 40579N846NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 31101N847NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 29575N848NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 31103N849NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 33213N8501VSouthwest Airlines Co · Dallas, TXBuilt 2016 · S/N 41530N8502ZSouthwest Airlines Co · Dallas, TXBuilt 2016 · S/N 36666N8503ASouthwest Airlines Co · Dallas, TXBuilt 2016 · S/N 38813N8504GSouthwest Airlines Co · Dallas, TXBuilt 2016 · S/N 38812N8507CSouthwest Airlines Co · Dallas, TXBuilt 2016 · S/N 41531N8508WSouthwest Airlines Co · Dallas, TXBuilt 2016 · S/N 38814N8509USouthwest Airlines Co · Dallas, TXBuilt 2016 · S/N 36925N850NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 40580N8510ESouthwest Airlines Co · Dallas, TXBuilt 2016 · S/N 36944N8511KSouthwest Airlines Co · Dallas, TXBuilt 2016 · S/N 36670
Back to AD 2007-19-13