AD 2017-08-01

Registered aircraft · 572

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

N5000XTeratorn LLC · Seattle, WABuilt 2000 · S/N 611N500GFIntellectual Air LLC · Atlanta, GABuilt 2008 · S/N 5191N501GMSc Transport LLC · Torrance, CABuilt 2017 · S/N 5561N501QCQuikrete Aircraft Leasing LLC · Atlanta, GABuilt 2013 · S/N 5450N503GSRegistered aircraftBuilt 2003 · S/N 5005N503GVEmmanuel Group · North Wilkesboro, NCBuilt 2015 · S/N 5503N505DSwift Connections LLC · Los Angeles, CABuilt 2011 · S/N 5323N506HGKimberly-Clark Integrated Services Corp · Dallas, TXBuilt 2012 · S/N 5400N508CKIbc Hospitality LLC · Newport Beach, CABuilt 2007 · S/N 5158N50JEIn50je LLC · New York, NYBuilt 1999 · S/N 567N50KUUnder The Stars LLC · Millington, TNBuilt 2001 · S/N 659N50SRegistered aircraftBuilt 2008 · S/N 5216N50WHWhite Wing Holdings LLC · Waukegan, ILBuilt 2019 · S/N 5589N510GTSouthwest Associates LLC · Bigfork, MTBuilt 2008 · S/N 5204N510GVTtp Services LLC · Hillsborough, NCBuilt 2006 · S/N 5106N510QSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2011 · S/N 5326N513MARichport Air LLC · Miami, FLBuilt 2003 · S/N 5019N516GHMadero Air LLC · South Saint Paul, MNBuilt 1998 · S/N 553N516WWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2015 · S/N 5516N517DWColleen Corp · New Castle, DEBuilt 2013 · S/N 5417N517TWGtw Corp · Jupiter, FLBuilt 2008 · S/N 5209N518GAL3harris Technologies Flight Capital LLC · Greenville, TXBuilt 2020 · S/N 5618N518GPG550 Msn 5051 Leasing LLC · Miami Beach, FLBuilt 2004 · S/N 5051N51VETrousdale Aviation LLC · West Hollywood, CABuilt 1999 · S/N 586N521GAGulfstream Aerospace Corp · Savannah, GABuilt 1997 · S/N 521N521SBBank Of Utah Trustee · Salt Lake City, UTBuilt 2008 · S/N 5199N522GDL3harris Technologies Flight Capital LLC · Greenville, TXBuilt 2020 · S/N 5622N524ACPegasus Leasing LLC · Ada, MIBuilt 2013 · S/N 5433N524AGTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2002 · S/N 686N524VEBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 5424N526EMEmi Travel LLC · Tampa, FLBuilt 2016 · S/N 5537N526GAL3harris Technologies Flight Capital LLC · Greenville, TXBuilt 2020 · S/N 5626N526SDWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 5229N527GAL3harris Technologies Flight Capital LLC · Greenville, TXBuilt 2020 · S/N 5627N527JGGibbs International Inc · Spartanburg, SCBuilt 2005 · S/N 5067N528APArrow Plane Lc · Provo, UTBuilt 2007 · S/N 5168N529GAL3harris Technologies Flight Capital LLC · Greenville, TXBuilt 2021 · S/N 5629N529RLRegistered aircraftBuilt 1999 · S/N 574N530GL3harris Technologies Flight Capital LLC Trustee · Greenville, TXBuilt 2021 · S/N 5630N530PMEbts LLC · New York, NYBuilt 2004 · S/N 5031N531GAL3harris Technologies Flight Capital LLC Trustee · Greenville, TXBuilt 2021 · S/N 5631N532SPGulfstream Leasing LLC · Savannah, GAFirst renewal noticeBuilt 2001 · S/N 632N533GVWilmington Trust Co Trustee · Wilmington, DEBuilt 2011 · S/N 5330N535VDelaware Aircraft Trust LLC Trustee · New Castle, DEBuilt 1997 · S/N 535N537NASetna Express LLC · Lincolnshire, ILBuilt 2008 · S/N 5188N539JSG550 Msn 5390 Leasing LLC · Bay Harbor Islands, FLBuilt 2012 · S/N 5390N542GDUnited States Air Force 645 Aesg · Wright Pat, OHBuilt 2016 · S/N 5542N543HAir Troxel LLC · Honolulu, HIBuilt 2002 · S/N 688N5465MBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 5465N549CFAvex Xvii LLC · Ft Lauderdale, FLBuilt 1997 · S/N 519
Back to AD 2017-08-01