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.

N97MMRegistered aircraftBuilt 2006 · S/N 81389N97MRRebel Back Home LLC · Waterford, MIS/N 426-REBN97MSJesnowski J Luke · Atchison, KSBuilt 2003 · S/N 01SN97MVNorth American Safety Education Group LLC · Flowery Branch, GABuilt 1996 · S/N 4636023N97MWRudderworks Aviation LLC · Fairfax Station, VABuilt 1975 · S/N 17264946N97NNAviation Business Corp · Saint Louis, MOS/N 23-435N97NTChasteen Coleman C · Keller, TXBuilt 1998 · S/N 001N97PBlack River Construction Services LLC · Black River Falls, WIBuilt 2001 · S/N 881-2001N97PFSoaring Eagles Flying Svc Ltd · Edwards, ILBuilt 1980 · S/N 28-8116068N97PLLarson Preston A · Webster, MNBuilt 1997 · S/N 20942N97PZStoraasli Paul · Torrance, CABuilt 1997 · S/N 581N97RADavis James K · Vero Beach, FLBuilt 1976 · S/N 28-7610020N97RKKeenan Michael P · Ankeny, IABuilt 1998 · S/N 97K003N97RPCombs Jonathan R · Girdwood, AKBuilt 1998 · S/N PR-18-1N97RTDoran John F · Charlestown, RIS/N 974N97RVLindberg Stephen J · Tumwater, WABuilt 1997 · S/N 2431N97RWWiplinger Robert D · Inver Grove Hts, MNS/N 18280387N97SARegistration Pending · Peosta, IARegistration pendingBuilt 1975 · S/N 18-7509117N97SCIpme Management Corp · Jefferson, GABuilt 1998 · S/N 6003N97TFTerell Enterprises LLC · Deland, FLFirst renewal noticeBuilt 1993 · S/N 119N97TKDekalb Aviation LLC · Williston, NDBuilt 2007 · S/N 1717N97UAManufacturing Services And Solutions LLC · Lake Villa, ILBuilt 1978 · S/N 28R7837163N97UPMf Helicopters LLC · East Troy, WIBuilt 1996 · S/N 0237N97VPAtkins Louis Clifford Jr · Birmingham, ALBuilt 1964 · S/N 30-480N97WButler William E · Idaho Falls, IDBuilt 1987 · S/N 120N97WHCox Thomas R · Kirkland, WAS/N 5263N97WKPantas James S · Mount Pleasant, NCBuilt 1999 · S/N 265978369N97XCN97xc LLC · Milpitas, CABuilt 2019 · S/N CC19-0045N97XTRobertson Paul L · Knoxville, TNBuilt 2001 · S/N 205N97XZAllen Nathanael W · Bemidji, MNBuilt 2026 · S/N 42063N97ZZMx7 LLC · Hudson, OHBuilt 2006 · S/N 22023CN98001Goltsos William · Barrington, RIBuilt 1969 · S/N 28-25991N98009Lebron Renard Luke Jr · Gulfport, MSBuilt 1969 · S/N 28-25994N9800PGrisham Steve DBA · Belzoni, MSBuilt 1976 · S/N 18-7609032N9800UHarvey Mallory · Baxley, GABuilt 1976 · S/N AA5A0200N9800WMrd Aero LLC · Manheim, PABuilt 1967 · S/N 28-23296N98012Registration Pending · West Sacramento, CARegistration pendingBuilt 1969 · S/N 28-25995N98014Bas Part Sales LLC · Greeley, COBuilt 1969 · S/N 28-25998N98015Rd Aire LLC · Opelika, ALBuilt 1969 · S/N 28-25999N98017Blakeslee Vernon A Jr · Torrington, CTBuilt 1969 · S/N 28-26000N9801WNorth Little Rock Air Inc · North Little Rock, ARBuilt 1967 · S/N 28-23297N98021Wright Joseph R · Perry, GABuilt 1969 · S/N 28-26001N9802AAtp Aircraft 7 LLC · Wilmington, DEBuilt 2008 · S/N 4496255N9802UStoll John E · Summerville, SCBuilt 1976 · S/N AA5A0202N98037Hammer Joseph K · Dike, TXBuilt 1969 · S/N 28-26004N9803CWhite Traci M · Manasquan, NJBuilt 1971 · S/N 17259703N9803DAttitude Aerobatics LLC · Wilmington, DEBuilt 1959 · S/N 22-6690N9803PLosse Randall J · Wasola, MOBuilt 1975 · S/N 25-7556118N9803YHubbard Nathan · Butte, MTS/N 38N98041Rosman Patrick R · Creston, WABuilt 1946 · S/N 18188
Back to AD 87-10-06 R1