AD 87-10-06 R1

Registered aircraft · 72,010

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:87-10-06-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-10-06-R1')
  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.

N83988Frese Dental LLC · Birmingham, ALBuilt 1981 · S/N 32R-8113080N8398AKeller William F · Burbank, CABuilt 1983 · S/N 0344N8398JBryant Thomas H · Justin, TXBuilt 1981 · S/N 32-8106073N8398LWingsleasing LLC · Wichita, KSBuilt 1968 · S/N 17256598N8398PBaca Andre · Albuquerque, NMBuilt 1964 · S/N 24-3657N8398RParker Jeffrey S · Aurora, OHBuilt 1966 · S/N 28-22275N8398WFlaspohler David E Trustee · Lake Lotawana, MOBuilt 1965 · S/N 28-2608N83993Brandywine Flight School · West Chester, PABuilt 1981 · S/N 28-8216007N8399LSanders George W Jr · Cloverdale, INBuilt 1968 · S/N 17256599N8399YHirschler Andre N · Goshen, INBuilt 1966 · S/N 30-1137N839ABMaloy Alec Stephan · Houston, TXBuilt 2020 · S/N 83339N839ALHorizon Dreams LLC · Homer, GABuilt 2000 · S/N 2843412N839HBlair Helicopter Service Inc · Lemoore, CABuilt 1975 · S/N 1090839N839JCGng LLC · New Market, ALBuilt 1973 · S/N 28R-7335193N839KTMiller Aviation Group LLC · Coon Rapids, MNBuilt 1982 · S/N M-2352N839RMN839rm LLC · Otsego, MNBuilt 2013 · S/N 2327N839RVHigh Performance Aircraft Products LLC · Bloomer, WIBuilt 2010 · S/N 90839N839SJj Aero LLC · Valley Center, KSBuilt 1995 · S/N 22061N839SAUS Department Of Homeland Security · Washington, DCBuilt 2003 · S/N T20608391N83ABBaggett Billy E · Florence, ALBuilt 2004 · S/N 24954N83AFN83af LLC · Stuart, FLBuilt 2001 · S/N 17281052N83AGGleixner Aaron J · South Glastonbury, CTBuilt 2004 · S/N 80511N83BETecce Andrew J · Cambridge, MDS/N 28-22218N83BFHayssen Arthur H · Sebastopol, CABuilt 1976 · S/N 27-7654171N83BWJohnson Nathan D · Pacheco, CABuilt 1965 · S/N 30-888N83BZNagy Brittany · Lady Lake, FLBuilt 2023 · S/N 71614N83DHHansen Douglas M · Garden City, SDBuilt 1997 · S/N 786-96N83DPPhilipsen David B · Bloomington, ILBuilt 1999 · S/N DMO 187N83DVRegistration Pending · Omaha, NERegistration pendingS/N 2134N83ECCarter Associates Inc · Sturgis, MIBuilt 2000 · S/N 4636307N83ERMike Smith Aviation International Inc · Rancho Murieta, CABuilt 1979 · S/N ME-201N83EWTremarco Philip J · Anchorage, AKS/N 17261231N83FDBury Christopher E · Hawthorne, CABuilt 1998 · S/N 5059N83FPPhillips Tom Scott · Beach City, TXBuilt 1978 · S/N 17271377N83GMRobbins William · Mansfield, LABuilt 1987 · S/N 101N83JDRegistered aircraftBuilt 2001 · S/N 80936N83JEKeenan Drew P · Chico, CAS/N 2273N83JFForker John S · Orcas, WABuilt 1995 · S/N LIV 192N83JRPriest Justin · Arlington, WAS/N 364N83JWCarpe Diem Aviation LLC · Cleveland Heights, OHBuilt 1979 · S/N 27-7954034N83KLLagrelius Thomas W · Redondo Beach, CABuilt 1999 · S/N 3246129N83KSN83ks LLC · Heber City, UTBuilt 1998 · S/N 074N83KTTaylor Paul A · Overgaard, AZBuilt 2022 · S/N SC002N83LHHelms Timethy M · Hamilton, MTBuilt 1995 · S/N 22167N83LMJohannsen Gregory A · Salina, KSBuilt 1964 · S/N 28-1563N83MAJones Stephen W · Tampa, FLBuilt 1978 · S/N AA5B0997N83MEScott Mark W · Bethany, CTBuilt 2014 · S/N 073-141/142-953N83MHStich Michael A · Malvern, OHBuilt 1969 · S/N 27-4302N83MTApplebaum Steven · Morton Grove, ILBuilt 1996 · S/N 387N83MZZeitlin Marc J · Tehachapi, CABuilt 2002 · S/N 386
Back to AD 87-10-06 R1