OpenAirDocs.org
AD 2013-23-14

Registered aircraft · 33

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:2013-23-14')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2013-23-14')
  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.

N183AMAlc B879 60285 LLC · Camden, DEBuilt 2016 · S/N 60285N20904United Airlines Inc · Chicago, ILBuilt 2012 · S/N 34824N24972United Airlines Inc · Chicago, ILBuilt 2018 · S/N 40939N24973United Airlines Inc · Chicago, ILBuilt 2018 · S/N 40941N26902United Airlines Inc · Chicago, ILBuilt 2012 · S/N 34822N26906United Airlines Inc · Chicago, ILBuilt 2012 · S/N 34829N27901United Airlines Inc · Chicago, ILBuilt 2012 · S/N 34821N27903United Airlines Inc · Chicago, ILBuilt 2012 · S/N 34823N29971United Airlines Inc · Chicago, ILBuilt 2017 · S/N 60147N29978United Airlines Inc · Chicago, ILBuilt 2020 · S/N 66137N438AMBc2 43862 LLC · Camden, DEBuilt 2017 · S/N 43862N45905United Airlines Inc · Chicago, ILBuilt 2012 · S/N 34825N605UPC C & E I LLC · Louisville, KYBuilt 2017 · S/N 64252N606UPCc & E I LLC · Louisville, KYBuilt 2017 · S/N 64253N634UPUnited Parcel Service Co · Louisville, KYBuilt 2013 · S/N 37564N7478ETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2012 · S/N 37829N828AAAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 40648N835ANWilmington Trust Co Trustee · Wilmington, DEBuilt 2018 · S/N 40655N850GTAtlas Air Inc · Purchase, NYBuilt 2012 · S/N 37570N851GTAtlas Air Inc · Purchase, NYBuilt 2012 · S/N 37565N852GTAtlas Air Inc · Purchase, NYBuilt 2012 · S/N 37571N853GTAtlas Air Inc · Purchase, NYBuilt 2012 · S/N 37572N854GTAtlas Air Inc · Purchase, NYBuilt 2013 · S/N 37566N855GTAtlas Air Inc · Purchase, NYBuilt 2013 · S/N 37567N856GTWilmington Trust Co Trustee · Wilmington, DEBuilt 2011 · S/N 37561N857GTAtlas Air Inc · Purchase, NYBuilt 2011 · S/N 37568N858GTWilmington Trust Co Trustee · Wilmington, DEBuilt 2011 · S/N 37569N859GTAtlas Air Inc · Purchase, NYBuilt 2015 · S/N 62441N864GTUmb Bank Na Trustee · Salt Lake City, UTBuilt 2015 · S/N 60117N865GTUmb Bank Na Trustee · Salt Lake City, UTBuilt 2015 · S/N 60118N868GTUmb Bank Na Trustee · Salt Lake City, UTBuilt 2015 · S/N 60119N894BAUnited States Air Force · Wpafb, OHBuilt 2016 · S/N 42416N895BAUnited States Air Force · Wpafb, OHBuilt 2016 · S/N 42417
Back to AD 2013-23-14