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.

N514VLWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2012 · S/N 5337N515VLBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 5391N516ASWilmington Trust Co Trustee · Wilmington, DEBuilt 2008 · S/N 39044N516JBJetblue Airways Corp · Long Island City, NYBuilt 2000 · S/N 1302N517ASAlaska Airlines Inc · Seatac, WABuilt 2008 · S/N 35197N517JBJetblue Airways Corp · Long Island City, NYBuilt 2000 · S/N 1327N518ASAlaska Airlines Inc · Seattle, WABuilt 2009 · S/N 35693N518VLBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 5488N519ASAlaska Airlines Inc · Seatac, WABuilt 2009 · S/N 36482N519BCAlta 777 LLC · Salt Lake City, UTS/N 32321N519JBJetblue Airways Corp · Long Island City, NYBuilt 2001 · S/N 1398N519UWAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 3881N519VLBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 5510N520ASAlaska Airlines Inc · Seattle, WABuilt 2009 · S/N 36481N520JBJetblue Airways Corp · Long Island City, NYBuilt 2001 · S/N 1446N520VLBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 5595N521JBJetblue Airways Corp · Long Island City, NYBuilt 2001 · S/N 1452N521SHGlobal Crossing Airlines Inc · Miami, FLS/N 2840N521UWAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 3944N521VLUmb Bank Na Trustee · Salt Lake City, UTBuilt 2013 · S/N 5651N522VLBank Of Utah Owner Trustee · Salt Lake City, UTBuilt 2013 · S/N 5776N523ASWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 35194N523JBJetblue Airways Corp · Long Island City, NYBuilt 2001 · S/N 1506N523UWAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 3960N523VLUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 6014N524ASAlaska Airlines Inc · Seatac, WABuilt 2009 · S/N 35195N524JBJetbule Airways Corporation · Long Island City, NYBuilt 2001 · S/N 1528N524UWBank Of Utah Trustee · Salt Lake City, UTBuilt 2009 · S/N 3977N524VLBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 6161N525ASAlaska Airlines Inc · Seatac, WABuilt 2009 · S/N 35692N525VLUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 6332N526ASAlaska Airlines Inc · Seatac, WABuilt 2009 · S/N 35196N526JLJetblue Airways Corp · Long Island City, NYBuilt 2001 · S/N 1546N526VLWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2015 · S/N 6470N527ASAlaska Airlines Inc · Seatac, WAS/N 35694N527JLJetblue Airways Corp · Long Island, NYBuilt 2001 · S/N 1557N527VLWilmington Trust Na Trustee · Wilmington, DEBuilt 2015 · S/N 6705N528ASAlaska Airlines Inc · Seattle, WABuilt 2009 · S/N 35695N529ASAlaska Airlines Inc · Seatac, WABuilt 2010 · S/N 35198N529CGCargo Aircraft Management Inc · Wilmington, OHS/N 529N529JBJetblue Airways Corporation · Long Island City, NYBuilt 2001 · S/N 1610N530ASAlaska Airlines Inc · Seattle, WABuilt 2010 · S/N 36578N530FLBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1153N530XTBank Of Utah Trustee · Salt Lake City, UTS/N 4931N531ASAlaska Airlines Inc · Seattle, WABuilt 2010 · S/N 35199N531JLJetblue Airways Corp · Long Island City, NYBuilt 2001 · S/N 1650N532ASAlaska Airlines Inc · Seatac, WABuilt 2010 · S/N 36346N533ASAlaska Airlines Inc · Seatac, WABuilt 2011 · S/N 35201N534ASAlaska Airlines Inc · Seatac, WABuilt 2011 · S/N 35202N534JBJetblue Airways Corp · Long Island City, NYBuilt 2002 · S/N 1705
Back to AD 2007-19-13