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.

N811NWDelta Air Lines Inc · Atlanta, GABuilt 2005 · S/N 0690N812NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 33520N812NWDelta Air Lines Inc · Atlanta, GABuilt 2006 · S/N 0784N813KWAlta 777 LLC · Salt Lake City, UTS/N 27641N813NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 30918N813NWDelta Air Lines Inc · Atlanta, GAS/N 0799N813VLUmb Bank Na Trustee · Salt Lake City, UTBuilt 2009 · S/N 35353N814KWAlta 777 LLC · Salt Lake City, UTS/N 28396N814NNAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 29562N814NWDelta Air Lines Inc · Atlanta, GABuilt 2006 · S/N 0806N815KWAlta 777 LLC · Salt Lake City, UTS/N 27640N815NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 33208N815NWDelta Air Lines Inc · Atlanta, GABuilt 2007 · S/N 0817N816NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 31081N816NWDelta Air Lines Inc · Atlanta, GABuilt 2007 · S/N 0827N817CMCargo Aircraft Management Inc · Wilmington, OHS/N 1269N817KWAlta 777 LLC · Salt Lake City, UTS/N 27642N817NNAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 29558N817NWDelta Air Lines Inc · Atlanta, GABuilt 2007 · S/N 0843N818NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 30910N818NWDelta Air Lines Inc · Atlanta, GABuilt 2007 · S/N 0857N819KWAlta 777 LLC · Salt Lake City, UTS/N 27654N819NNAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 31083N819NWDelta Air Lines Inc · Atlanta, GABuilt 2007 · S/N 0858N820KWAlta 777 LLC · Salt Lake City, UTS/N 27655N820NNAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 29559N820NWDelta Air Lines Inc · Atlanta, GABuilt 2007 · S/N 0859N821AVAircol 22 · Wilmington, DEBuilt 2011 · S/N 4821N821CMCargo Aircraft Management Inc · Wilmington, OHS/N 1146N821JBJetblue Airways Corp · Long Island City, NYBuilt 2012 · S/N 5417N821NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 30912N821NWDelta Air Lines Inc · Atlanta, GABuilt 2007 · S/N 0865N822KWAlta 777 LLC · Salt Lake City, UTS/N 28532N822NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 31085N822NWDelta Air Lines Inc · Atlanta, GABuilt 2015 · S/N 1627N823NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 29560N823NWDelta Air Lines Inc · Atlanta, GABuilt 2015 · S/N 1628N823SYSun Country Inc · Minneapolis, MNS/N 33971N824NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 30916N824NWDelta Air Lines Inc · Atlanta, GABuilt 2015 · S/N 1637N824SYSun Country Inc · Minneapolis, MNBuilt 2005 · S/N 33976N825AMWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2014 · S/N 36699N825KWEal Asset Holdings LLC · Kansas City, MOBuilt 2003 · S/N 32318N825NNAmerican Airlines Inc · Fort Worth, TXBuilt 2010 · S/N 31087N825NWDelta Air Lines Inc · Atlanta, GABuilt 2015 · S/N 1679N826KWAlta 777 LLC · Salt Lake City, UTS/N 28521N826NNAmerican Airlines Inc · Fort Worth, TXBuilt 2010 · S/N 31089N826NWDelta Air Lines Inc · Atlanta, GABuilt 2016 · S/N 1701N827JBJetblue Airways Corp · Long Island City, NYBuilt 2013 · S/N 5677N827KWAlta 777 LLC · Salt Lake City, UTS/N 28525
Back to AD 2007-19-13