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.

N915MBBarras David G · Breaux Bridge, LABuilt 2004 · S/N 1N915PSmith Jr Franklin R · Rock Hill, SCBuilt 2012 · S/N 90856N915PABird Acquisition LLC · Phoenix, AZBuilt 1999 · S/N 2843304N915PBLease Lawrence · Royal Oaks, CABuilt 2010 · S/N 91523N915PRAvialogia Inc · CancunS/N 3126N915RDDavis Richard L · Kenai, AKBuilt 2007 · S/N 122284N915RSHayward Houston C · Lansdale, PABuilt 1999 · S/N 1260-99N915RVWiegand Jeffrey L · Ocean Isle Beach, NCBuilt 1999 · S/N 22356RV6N915TAAurora Aircraft LLC · Waterford, MIBuilt 2006 · S/N 172S10358N915TTLake Elmo Aero LLC · Lake Elmo, MNBuilt 1977 · S/N 28-7890158N915WBBordelon Warren P · Breaux Bridge, LABuilt 1972 · S/N 17261221N915WCBarr Air Patrol LLC · Mesquite, TXBuilt 2003 · S/N T20608412N915WMChambers David N · Cullman, ALBuilt 1976 · S/N 28-7310107N915WVSmith Aviation LLC · Springer, OKBuilt 1959 · S/N TD-236N916Kyer Barry Patrick · Honey Grove, TXBuilt 1994 · S/N 5316N9160DMalsby Thomas H · Blairsville, GABuilt 1958 · S/N 22-6212N9160HTodd Media Inc · Tuscaloosa, ALBuilt 1975 · S/N 17265984N9160JMohan Aditya · Rancho Cordova, CAS/N 28-3218N9160NBoeing Co · Renton, WABuilt 1971 · S/N 3114N9160PHeath Allen W · Westlake, TXBuilt 1966 · S/N 24-4648N9160VLangis Maximus · Newburyport, MABuilt 1969 · S/N 690029N9160WAmerican Aviator LLC · Arlington, TXBuilt 1966 · S/N 28-10779N9160ZBriggs Robert B · Germantown, TNBuilt 1989 · S/N 4622023N9161DSchlesinger Warren · Page, AZBuilt 1990 · S/N 270071N9161EKurtz Andrew · Boise, IDBuilt 1990 · S/N 27-0068N9161FHuie John E · Burnet, TXBuilt 2002 · S/N 001N9161HAir Athens LLC · Athens, GABuilt 1975 · S/N 17265985N9161JNortheast Nebraska Aviators Inc · Wayne, NEBuilt 1966 · S/N 28-3220N9161KSkymook Aviation LLC · Beaver Falls, PABuilt 1989 · S/N 4622022N9161NCorvallis Rapid Transit LLC · Corvallis, ORBuilt 1999 · S/N 27-0266N9161PAven Michael D · Georgetown, INBuilt 1966 · S/N 24-4649N9161SCarr Jack Willson · East Lansing, MIBuilt 1975 · S/N MB-785N9161UHeron Kyle B · Modesto, CABuilt 1992 · S/N 27-0145N9161VKaroki Jonah · Strasburg, COBuilt 1969 · S/N 690034N9161YFonville David N · Cresson, TXBuilt 1992 · S/N 27-0146N91622Utterback Karl D · Fort Wayne, INBuilt 2002 · S/N M-II-1820N9162DWeagle Aviation LLC · Birmingham, ALBuilt 1993 · S/N 27-0152N9162HStratus Aviation LLC DBA · Vacaville, CABuilt 1975 · S/N 17265986N9162JHillelson Lawrence E · Grosse Ile, MIBuilt 1966 · S/N 28-3221N9162NMann Aviation LLC · Wilmington, DEBuilt 1998 · S/N 24-3421N9162PBrown Nathan B · Wallace, KSBuilt 1966 · S/N 24-4650N9162WYanka Anthony Joseph · Moorestown, NJBuilt 1968 · S/N 28-11096N91631Seale Taylor Edward · Madison, WIBuilt 1993 · S/N 2890177N91634Tharp Anthony W · Charleston, WVBuilt 1993 · S/N 2890178N9163CZaparovanny Alexey · Westford, MABuilt 1995 · S/N 27-0208N9163DRubbert Jan Dale · Upham, NDBuilt 1958 · S/N 22-6216N9163JCavu Flight Training LLC · Freeport, MEBuilt 1966 · S/N 28-3222N9163PMiller Richard Marc Trustee · Dana Point, CABuilt 1966 · S/N 24-4651N9163QWebb John L · Elgin, TXBuilt 1998 · S/N 24-3422N9163WMetsker Kay B · Winnemucca, NVBuilt 1966 · S/N 28-10788
Back to AD 87-10-06 R1