AD 2017-17-18

Registered aircraft · 1,791

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

N125SYSky West Airlines Inc · St George, UTBuilt 2014 · S/N 17000440N126HQRepublic Airways Inc · Carmel, INBuilt 2008 · S/N 17000204N127HQRepublic Airways Inc · Carmel, INBuilt 2008 · S/N 17000206N127SYSkywest Airlines Inc · St George, UTBuilt 2014 · S/N 17000441N128SYSkywest Airlines Inc · St George, UTBuilt 2014 · S/N 17000445N129HQRepublic Airways Inc · Carmel, INBuilt 2008 · S/N 17000211N130HQRepublic Airways Inc · Carmel, INBuilt 2008 · S/N 17000212N130SYSkywest Airlines Inc · Saint George, UTBuilt 2015 · S/N 17000449N131EVDelta Air Lines Inc · Atlanta, GABuilt 2009 · S/N 15217N131HQRepublic Airways Inc · Carmel, INBuilt 2008 · S/N 17000215N131SYSkywest Airlines Inc · St George, UTBuilt 2015 · S/N 17000450N132EVDelta Air Lines Inc · Atlanta, GABuilt 2009 · S/N 15219N132HQRepublic Airways Inc · Carmel, INBuilt 2008 · S/N 17000216N132SYSkywest Airlines Inc · St George, UTBuilt 2015 · S/N 17000451N133EVDelta Air Lines Inc · Atlanta, GABuilt 2009 · S/N 15222N133HQRepublic Airways Inc · Carmel, INBuilt 2008 · S/N 17000217N133SYSkywest Airlines Inc · St George, UTBuilt 2015 · S/N 17000452N134EVDelta Air Lines Inc · Atlanta, GABuilt 2009 · S/N 15223N134HQRepublic Airways Inc · Carmel, INBuilt 2008 · S/N 17000220N134SYSkywest Airlines Inc · St George, UTBuilt 2015 · S/N 17000458N134WM560 Company Inc · Anchorage, AKBuilt 1997 · S/N 5340N135EVDelta Air Lines Inc · Atlanta, GABuilt 2009 · S/N 15225N135HQRepublic Airways Inc · Carmel, INBuilt 2008 · S/N 17000224N135SMStonegate Leasing 2020 LLC · Natick, MABuilt 2000 · S/N 5444N135SYSkywest Airlines Inc · St George, UTBuilt 2015 · S/N 17000460N136EVDelta Air Lines Inc · Atlanta, GABuilt 2009 · S/N 15226N136HQRepublic Airways Inc · Carmel, INBuilt 2008 · S/N 17000228N136SYSkywest Airlines Inc · St George, UTBuilt 2015 · S/N 17000462N137EVDelta Air Lines Inc · Atlanta, GABuilt 2009 · S/N 15227N137HQRepublic Airways Inc · Carmel, INBuilt 2008 · S/N 17000231N138EVDelta Air Lines Inc · Atlanta, GABuilt 2009 · S/N 15235N138HQRepublic Airways Inc · Carmel, INBuilt 2008 · S/N 17000234N138SYSkywest Airlines Inc · St George, UTBuilt 2015 · S/N 17000466N139LJGlobal Aircraft Trust Inc Trustee · Cheyenne, WYBuilt 1988 · S/N 5025N139SYSkywest Airlines Inc · St George, UTBuilt 2015 · S/N 17000468N140SYSkywest Airlines Inc · Saint George, UTBuilt 2015 · S/N 17000470N141SHLead And Steel 4 LLC · Fountain Valley, CABuilt 1997 · S/N 7206N141SYSkywest Airlines Inc · Saint George, UTBuilt 2015 · S/N 17000472N142SYSkywest Airlines Inc · St George, UTBuilt 2015 · S/N 17000475N143SYSkywest Airlines Inc · St George, UTBuilt 2015 · S/N 17000476N144MHW Hughes Aviation LLC · Stanton, TXBuilt 1993 · S/N 5135N144SYSkywest Airlines Inc · St George, UTBuilt 2015 · S/N 17000482N145SYSkywest Airlines Inc · St George, UTBuilt 2015 · S/N 17000484N146PQDelta Air Lines Inc · Atlanta, GABuilt 2007 · S/N 15146N146SYSkywest Airlines Inc · St George, UTBuilt 2015 · S/N 17000491N147PQDelta Air Lines Inc · Atlanta, GABuilt 2007 · S/N 15147N148SYSkywest Airlines Inc · St George, UTBuilt 2015 · S/N 17000492N149SYSkywest Airlines Inc · St George, UTBuilt 2015 · S/N 17000495N150BBMs Hawker LLC · Farmington Hills, MIBuilt 2000 · S/N 5470N150SYSkywest Airlines Inc · St George, UTBuilt 2015 · S/N 17000499
Back to AD 2017-17-18