AD 2017-20-08

Registered aircraft · 1,569

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-08')
    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-08')
  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.

N1CCTonkawa Inc · Minnetonka, MNBuilt 2013 · S/N 5419N1CVTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2015 · S/N 6165N1DWac I LLC · Fort Lauderdale, FLBuilt 1992 · S/N 1209N1DCBlue Star Management Services Corp · Frisco, TXBuilt 2001 · S/N 651N1DSDcs Enterprises Inc · West Palm Beach, FLBuilt 2019 · S/N 6369N1DWAir Orange 650 LLC · Thayne, WYBuilt 2022 · S/N 6496N1FTvpx Ars Inc Trustee · Concord, MABuilt 2014 · S/N 6076N1HCHardesty-Gulfstream LLC · Tulsa, OKBuilt 2003 · S/N 5009N1HGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2004 · S/N 1534N1JMWhiskey Uniform LLC · Wichita Falls, TXS/N 682N1KETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2012 · S/N 6024N1LATvpx Aircraft Solultions Inc Trustee · North Salt Lake, UTBuilt 2015 · S/N 6176N1NKBase Aviation LLC · Jupiter, FLBuilt 2015 · S/N 5534N1PGProcter & Gamble Leasing LLC · Cincinnati, OHBuilt 2017 · S/N 6260N1RHHms Holdings LLC · Charlotte, NCBuilt 2021 · S/N 6470N1RPPts As LLC · Reading, PABuilt 2013 · S/N 5458N1TDThreshold Ventures Inc · Scottsdale, AZBuilt 1990 · S/N 1133N1TMMarsico Aviation LLC · Denver, COBuilt 2002 · S/N 1490N2000STvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2015 · S/N 6133N200AExxon Mobil Corp · Houston, TXBuilt 2023 · S/N 6548N200CKMacs Aviation LLC · Columbus, INBuilt 2014 · S/N 4304N200KPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 5170N200LCSn 1067 LLC · Wilmington, DEBuilt 1988 · S/N 1067N201ACWilmington Trust Co Trustee · Providence, RIBuilt 2023 · S/N 6551N201CETvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2014 · S/N 6074N2030PRegistered aircraftBuilt 2021 · S/N 6476N203RCWcs Inc · Troy, ALBuilt 2010 · S/N 4211N204AMercury International Holdings LLC · Salt Lake City, UTBuilt 2011 · S/N 5341N20CPRegistered aircraftBuilt 2018 · S/N 6347N20GGoodyear Tire & Rubber Co · Akron, OHBuilt 2010 · S/N 4212N20RCBristol Air LLC · Missoula, MTBuilt 2017 · S/N 6300N2107ZAir Prestigio LLC · Aliso Viejo, CAS/N 1211N210AMShamrock Aviation LLC · Miami, FLBuilt 2010 · S/N 4207N21112Ihgh LLC · Salt Lake City, UTS/N 4282N211DHHagadone Aviation LLC · Coeur D Alene, IDBuilt 2000 · S/N 1432N2120Wilmington Trust Co Trustee · Wilmington, DEBuilt 2014 · S/N 5468N212DDTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2020 · S/N 6438N212VZNapleton Aviation Group LLC · Sugar Grove, ILBuilt 2014 · S/N 4325N213EFMontana Aircraft Trust Inc Trustee · Bozeman, MTBuilt 1996 · S/N 1283N213TGBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 4219N215BBBl Charter LLC · Pittsfield, MABuilt 2000 · S/N 610N218HFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2018 · S/N 5587N218KDMojave Jet LLC · Wilmington, DEBuilt 1991 · S/N 1164N218MDNe-2 LLC · Houston, TXBuilt 2003 · S/N 1515N219TFMaple Holdings LLC · Kansas City, MOBuilt 2013 · S/N 4292N21EHRegistered aircraftBuilt 2007 · S/N 5141N21UGiven To Fly Holdings LLC · West Chicago, ILS/N 5379N21UCUnited Co · Bristol, VABuilt 2014 · S/N 5484N220TDRegistration Pending · Rantoul, KSRegistration pendingBuilt 1988 · S/N 1070N221DGDavid Geffen Co · Los Angeles, CABuilt 2013 · S/N 6061
Back to AD 2017-20-08