AD 2017-20-06

Registered aircraft · 364

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-20-06')
    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-20-06')
  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.

N534XJTvpx Aircraft Solutions Inctrustee · North Salt Lake, UTBuilt 2013 · S/N 20406N535FXFlexjet LLC · Cleveland, OHBuilt 2007 · S/N 20167N535XJU S Bank Na · Marshall, MNS/N 20137N536FXFlexjet LLC · Cleveland, OHBuilt 2007 · S/N 20171N536XJBank Of Utah Trustee · Salt Lake City, UTBuilt 2004 · S/N 20036N537XJBank Of Utah Trustee · Salt Lake City, UTBuilt 2008 · S/N 20213N538FXFlexjet LLC · Cleveland, OHBuilt 2008 · S/N 20201N538XJBank Of Utah Trustee · Salt Lake City, UTBuilt 2008 · S/N 20224N539XJBank Of Utah Trustee · Salt Lake City, UTBuilt 2008 · S/N 20230N540FXFlexjet LLC · Cleveland, OHBuilt 2008 · S/N 20205N541FXCitation X Parts LLC · Liberty, NCBuilt 2008 · S/N 20211N541XJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2009 · S/N 20279N542FXCitation X Parts LLC · Liberty, NCBuilt 2008 · S/N 20217N545XJBank Of Utah Trustee · Salt Lake City, UTBuilt 2009 · S/N 20278N546XJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2009 · S/N 20280N547FXFlexjet LLC · Cleveland, OHBuilt 2011 · S/N 20341N547XJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2009 · S/N 20281N548XJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2010 · S/N 20301N549FXCitation X Parts LLC · Liberty, NCBuilt 2012 · S/N 20374N549XJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2011 · S/N 20322N54HAL&D Air LLC · Minneapolis, MNBuilt 2005 · S/N 20076N550FXFlexjet LLC · Cleveland, OHBuilt 2013 · S/N 20391N550XJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2011 · S/N 20323N551FXFlexjet LLC · Cleveland, OHBuilt 2010 · S/N 20272N551XJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2011 · S/N 20324N552FXCitation X Parts LLC · Liberty, NCBuilt 2006 · S/N 20084N552XJBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 20329N553FXCitation X Parts LLC · Liberty, NCBuilt 2008 · S/N 20236N556DDDelta Aviation LLC · West Bend, WIBuilt 2005 · S/N 20082N556FXFlexjet LLC · Cleveland, OHBuilt 2006 · S/N 20132N557XJBank Of Utah Trustee · Salt Lake City, UTBuilt 2005 · S/N 20047N55EBBank Of Utah Trustee · Salt Lake City, UTBuilt 2009 · S/N 20257N56BACore Natural Resources Inc · Canonsburg, PABuilt 2008 · S/N 20228N575FDEcho Acquisitions LLC · Dover, DEBuilt 2004 · S/N 20023N578XJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 20078N585AXCentury Mold Holdings LLC · Rochester, NYBuilt 2007 · S/N 20184N58HAAcrisure Aircraft N58ha LLC · New York, NYBuilt 2007 · S/N 20146N58LCAtlantic Excel LLC · San Marcos, CABuilt 2007 · S/N 20163N590MCRegistered aircraftBuilt 2004 · S/N 20027N595CBTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2011 · S/N 20326N59KGRegistered aircraftBuilt 2013 · S/N 20393N5LAir Sansone LLC · Wilmington, DEBuilt 2006 · S/N 20101N600CFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2008 · S/N 20191N606RPSydes Aviation LLC · Jacksonville, NCBuilt 2010 · S/N 20309N607GJGabinoah LLC · Miami Beach, FLBuilt 2013 · S/N 20414N608KHIronwood Sky Holdings LLC · Wilmington, DEBuilt 2008 · S/N 20237N608RPWheels Up Partners LLC · New York, NYBuilt 2012 · S/N 20372N610CGMac Air LLC · Sellersburg, INBuilt 2008 · S/N 20241N610HCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 20185N615WDCharlie 300 LLC · Columbus, OHBuilt 2013 · S/N 20415
Back to AD 2017-20-06