OpenAirDocs.org
AD 2016-23-10

Registered aircraft · 34

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

N1103SScs 21 LLC · North Salt Lake, UTBuilt 2013 · S/N 761016N115MQArkansas Childrens Hospital · Little Rock, ARS/N 761009N27DXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2015 · S/N 761069N36ENWilmington Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 761014N36RPMirasol Sky LLC · Dallas, TXBuilt 2013 · S/N 761037N553XBAmerican Express Travel Related Services Co Inc · Newburgh, NYBuilt 2013 · S/N 761019N576AVRegistered aircraftBuilt 2016 · S/N 761008N676FXFlexjet Vertical Lift LLC · Stratford, CTBuilt 2013 · S/N 761025N760AFArkansas Childrens Hospital · Little Rock, ARBuilt 2013 · S/N 761038N761AFArkansas Childrens Hospital · Little Rock, ARBuilt 2013 · S/N 761039N761DSikorsky Aircraft Corp · Stratford, CTBuilt 2009 · S/N 761001N761NYNew York State Police · Latham, NYBuilt 2013 · S/N 761021N762DSikorsky Aircraft Corp · Stratford, CTBuilt 2009 · S/N 761002N7633MSikorsky Aircraft Corp · Stratford, CTS/N 761033N7634YSikorsky Aircraft Corp · Stratford, CTS/N 761034N763DXSikorsky Aircraft Corp · Stratford, CTBuilt 2011 · S/N 761003N7654ZWilmington Trust Co Trustee · Wilmington, DEBuilt 2014 · S/N 761054N7663PBank Of Utah Trustee · Salt Lake City, UTS/N 761063N7664WBank Of Utah Trustee · Salt Lake City, UTS/N 761064N7675VNevada Aircraft Corp · Henderson, NVS/N 761075N767JSikorsky Aircraft Corp · West Palm Beach, FLBuilt 2012 · S/N 761007N7685CSikorsky Aircraft Corp · Stratford, CTS/N 761085N7686QSikorsky Aircraft Corp · Stratford, CTS/N 761086N7687LSikorsky Aircraft Corp · Stratford, CTS/N 761087N7688PSikorsky Aircraft Corp · Stratford, CTS/N 761088N7689LSikorsky Aircraft Corp · Stratford, CTS/N 761089N7690LSikorsky Aircraft Corp · Stratford, CTS/N 761090N800SGWhirlybird LLC · Los Angeles, CABuilt 2015 · S/N 761004N80EWWeatherstone Air Inc · Teterboro, NJBuilt 2013 · S/N 761023N817SSTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2019 · S/N 761080N825MLMinuteman Aviation LLC · New Castle, DEBuilt 2013 · S/N 761013N894CCConstellation Energy Generation LLC · New Castle, DEBuilt 2015 · S/N 761076N93RTWaco Oil & Gas Co Inc · Glenville, WVBuilt 2012 · S/N 761006N976TRBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 761032
Back to AD 2016-23-10