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.

N61318Wilmington Trust Co Trustee · Wilmington, DEBuilt 2001 · S/N 650N613AQTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 5181N613BRRegistered aircraftBuilt 1997 · S/N 531N616AFAmeriprise Financial Inc · Oxford, CTBuilt 2010 · S/N 5295N616CAPioneer Hi-Bred International Inc · Wilmington, DEBuilt 2019 · S/N 5601N616RKBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 5361N617EAMeridien Aircraft Holdings LLC · Greenwich, CTBuilt 2002 · S/N 693N619GVTrans-Exec Air Service Inc · Van Nuys, CABuilt 2000 · S/N 619N620JHBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 5595N621MDBide A Wee LLC · Newark, DEBuilt 2000 · S/N 608N623TAL3 Harris Technologies Inc · Waco, TXBuilt 2012 · S/N 5374N625GNPaper Airplanes 3 LLC · Scottsdale, AZBuilt 1999 · S/N 575N626JEMmap III LLC · Houston, TXBuilt 2001 · S/N 642N626RAMavir LLC · Albany, NYBuilt 2007 · S/N 5176N62FFPsalm 52:8 LLC · Dover, DEBuilt 1999 · S/N 569N631VRDoheny Leasing Inc · Culver City, CABuilt 2001 · S/N 631N640WBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 5416N641GVTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2001 · S/N 641N642GAGulfstream Aerospace Corp · Savannah, GABuilt 1998 · S/N 542N645CCL3harris Technologies Flight Capital LLC · Greenville, TXS/N 5496N645EARegistered aircraftN-number assigned (import), not yet registeredS/N 5590N645LHL3harris Technologies Flight Capital LLC · Greenville, TXBuilt 2020 · S/N 5606N65CCNbi Holdings LLC · New Bremen, OHBuilt 2008 · S/N 5207N65KLRegency Aviation LLC · Edgewater, MDBuilt 2004 · S/N 5035N660HH94924 LLC · Medford, ORBuilt 2009 · S/N 5255N665JJUmb Bank Na Trustee · Salt Lake City, UTBuilt 2006 · S/N 5126N66CCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2012 · S/N 5375N670RRTvpx Trust Co LLC · North Salt Lake, UTBuilt 2010 · S/N 5281N671LEGreen Sky Aviation LLC · Jupiter, FLBuilt 2006 · S/N 5130N677FNational Science Foundation · Alexandria, VABuilt 2002 · S/N 677N688CBFrc Holding Inc V · Dover, DEBuilt 2007 · S/N 5172N699KRBank Of Utah Trustee · Salt Lake City, UTBuilt 2007 · S/N 5171N69CKCd 321 LLC · Austin, TXBuilt 2004 · S/N 5046N6JPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2004 · S/N 5062N6PCMountain Aviation Leasing LLC · Park City, UTS/N 505N700HAWilmington Trust Co Trustee · Wilmington, DES/N 634N702QVNaqvi Law LLC · Las Vegas, NVBuilt 2002 · S/N 685N703FSFlo-Sun Aircraft Inc · West Palm Beach, FLBuilt 2010 · S/N 5307N703RKEmergence Southwest LLC · Jacksonville, FLBuilt 2002 · S/N 671N708JHUnited States Government · Washington, DCFirst renewal noticeBuilt 2019 · S/N 5599N709AABank Of Utah Trustee · Salt Lake City, UTBuilt 2001 · S/N 635N71111Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2011 · S/N 5316N711EGG550 N711 LLC · Newport Beach, CABuilt 2009 · S/N 5231N712LWWanderweg Holdings LLC · Salt Lake City, UTBuilt 2007 · S/N 5154N716ASAs Aviation Holdings LLC · Wilmington, DEBuilt 2002 · S/N 687N716GCGreat Clips Inc · Minneapolis, MNBuilt 2014 · S/N 5499N718JJJj Acquistions 681 LLC · Secaucus, NJBuilt 2002 · S/N 681N718MCRadical Ventures LLC · Dallas, TXBuilt 2004 · S/N 5061N718PMConfectionery Advantage LLC · Park Ridge, NJBuilt 2012 · S/N 5384N721AZSz Aviation LLC · Miami, FLBuilt 1999 · S/N 565
Back to AD 2017-08-01