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.

N795UAUnited Airlines Inc · Chicago, ILBuilt 1997 · S/N 26927N796ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30796N796JBJetblue Airways Corp · Long Island City, NYBuilt 2012 · S/N 5060N796UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 26931N797ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30012N797AXCargo Aircraft Management Inc · Wilmington, OHBuilt 1985 · S/N 23147N797UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 26924N798ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30797N798UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 26928N799ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30258N799UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 26926N800NNAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 29564N801NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2009 · S/N 29565N801NWDelta Air Lines Inc · Atlanta, GABuilt 2003 · S/N 0524N801XAWells Fargo Trust Co Na Trustee · Salt Lake City, UTBuilt 2017 · S/N 61781N801XTBank Of Utah Trustee · Salt Lake City, UTBuilt 2007 · S/N 35220N802NNWilmington Trust Co Trustee · Wilmington, DES/N 31073N802NWDelta Air Lines Inc · Atlanta, GABuilt 2003 · S/N 0533N802XAWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2017 · S/N 61782N803NNAmerican Airlines Inc · Fort Worth, TXS/N 29566N803NWDelta Air Lines Inc · Atlanta, GABuilt 2003 · S/N 0542N803XAWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2017 · S/N 61797N804JBJetblue Airways Corp · Long Island City, NYBuilt 2012 · S/N 5142N804NNAmerican Airlines Inc · Fort Worth, TXS/N 29567N804NWDelta Air Lines Inc · Atlanta, GABuilt 2003 · S/N 0549N804XAWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2017 · S/N 61784N805JBJetblue Airways Corp · Long Island City, NYBuilt 2012 · S/N 5148N805NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 31075N805NWDelta Air Lines Inc · Atlanta, GABuilt 2003 · S/N 0552N805XAWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2017 · S/N 61785N806JBJetblue Airways Corp · Long Island City, NYBuilt 2012 · S/N 5302N806NNAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 29561N806NWDelta Air Lines Inc · Atlanta, GABuilt 2004 · S/N 0578N806XAWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2017 · S/N 61786N807JBJetblue Airways Corp · Long Island City, NYBuilt 2012 · S/N 5312N807KWAlta 777 LLC · Salt Lake City, UTS/N 27638N807NNAmerican Airlines Inc · Fort Worth, TXS/N 31077N807NWDelta Air Lines Inc · Atlanta, GABuilt 2004 · S/N 0588N807XAWilmington Trust Co Trustee · Wilmington, DEBuilt 2018 · S/N 63406N808NNWilmington Trust Co Trustee · Wilmington, DES/N 33206N808NWDelta Air Lines Inc · Atlanta, GABuilt 2004 · S/N 0591N809JBJetblue Airways Corp · Long Island City, NYBuilt 2012 · S/N 5349N809NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 33519N809NWDelta Air Lines Inc · Atlanta, GABuilt 2005 · S/N 0663N810KWAlta 777 LLC · Salt Lake City, UTS/N 27639N810NNAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 33207N810NWDelta Air Lines Inc · Atlanta, GABuilt 2005 · S/N 0674N8118KTvpx Trust Co LLC Trustee · North Salt Lake, UTS/N 33722N811KWAlta 777 LLC · Salt Lake City, UTS/N 27656N811NNAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 31079
Back to AD 2007-19-13