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.

N308JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2008 · S/N 20218N309JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2021 · S/N 20348N30QAWood Asg LLC · Carrollton, TXBuilt 2012 · S/N 20357N310VZRan Air LLC · Driggs, IDBuilt 2012 · S/N 20366N311FCWheels Up Partners LLC · New York, NYBuilt 2010 · S/N 20298N311GSCh Aircraft LLC · Palm Beach, FLBuilt 2008 · S/N 20233N313DSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 20183N313VClyde Companies Inc · Orem, UTBuilt 2012 · S/N 20365N314JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2006 · S/N 20100N315JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 20030N316CSCaroler 316 LLC · Solon, OHBuilt 2007 · S/N 20180N317VBVictor Bravo Air LLC · Dallas, TXS/N 20234N31CAHf Sinclair Payroll Services Inc · Dallas, TXBuilt 2004 · S/N 20021N320JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 20155N320LXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2013 · S/N 20417N325PEPeco Air LLC · Park City, UTBuilt 2015 · S/N 20409N325TGFlying G Aviation LLC · Atlanta, GABuilt 2014 · S/N 20455N325WJDorado Aircraft Leasing LLC · Jupiter, FLBuilt 2014 · S/N 20449N328RSHolloman Ventures Aviation LLC · Houston, TXBuilt 2012 · S/N 20382N330PJKhcl LLC · Cincinnati, OHBuilt 2006 · S/N 20102N330SAThree Feathers Logistics LLC · Atlanta, GABuilt 2013 · S/N 20413N330ZAMead Gregory Zane · Lubbock, TXBuilt 2004 · S/N 20035N3337JBig Horns Leasing LLC · Jackson, WYBuilt 2011 · S/N 20337N334AFSusieair LLC · Houston, TXBuilt 2012 · S/N 20359N335AFArcadia Leasing LLC · Arcadia, WIS/N 20190N338JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2006 · S/N 20091N339BVAljobe Bajeky LLC · Levittown, NYBuilt 2011 · S/N 20328N33CHRitz Air LLC · Dayton, OHBuilt 2004 · S/N 20033N340JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2006 · S/N 20109N345HGAxios Aviation LLC · Traverse City, MIBuilt 2013 · S/N 20431N347KKiewit Engineering Group Inc · Omaha, NEBuilt 2008 · S/N 20240N350XXPete Mitchell Aviation LLC · Plantation, FLBuilt 2004 · S/N 20019N353PCQuantum Aviation LLC · Tampa, FLBuilt 2005 · S/N 20053N354WGAutomatic Press LLC · Horseshoe Bay, TXBuilt 2012 · S/N 20354N356MLAviation Travel Ventures LLC · Melbourne, FLBuilt 2005 · S/N 20075N357KGN357kg LLC · Bluffton, SCBuilt 2003 · S/N 20012N357TWLazer Aviation LLC · Orange Park, FLBuilt 2011 · S/N 20314N35FEFederal Express Leasing Corp · Memphis, TNBuilt 2013 · S/N 20408N362JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2008 · S/N 20249N362LRegistered aircraftBuilt 2010 · S/N 20291N365LRegistered aircraftBuilt 2009 · S/N 20271N370DBCitation X Parts LLC · Liberty, NCBuilt 2005 · S/N 20056N370ELLge Management Partners LLC · Phoenix, AZBuilt 2013 · S/N 20399N371DBCitation X Parts LLC · Liberty, NCBuilt 2005 · S/N 20064N371JGNih-Aviation LLC · Charlotte, NCBuilt 2012 · S/N 20371N372DBCitation X Parts LLC · Liberty, NCBuilt 2005 · S/N 20055N373DBCitation X Parts LLC · Liberty, NCBuilt 2005 · S/N 20057N377DPOrr Investments LLC · Casper, WYBuilt 2012 · S/N 20377N377MDCambria Aviation LLC · Belle Plaine, MNBuilt 2007 · S/N 20149N377RUCmmr Enterprise LLC · Round Top, TXBuilt 2009 · S/N 20263
Back to AD 2017-20-06