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.

N68BWRegistered aircraftBuilt 1969 · S/N 700007N68CAAsset Management Advisors Corp · Plantation, FLBuilt 1992 · S/N 14560N68CNEichten Steve G · Colleyville, TXBuilt 1969 · S/N 28R-35388N68CSTrojen Properties LLC · Joplin, MOS/N 988N68DSkaggs Randall D · Sacramento, CABuilt 1973 · S/N 74-31072N68DBLai LLC · Flowood, MSS/N 722N68DEMazzoni Dennis · Mays Landing, NJBuilt 1974 · S/N 745-74N68DGDellar Randy Roger · Wasilla, AKS/N 1208-95N68DSSichak Stephen Jr · Wanaque, NJBuilt 1997 · S/N 18280033N68DWAero Group I LLC · Woodstock, VABuilt 1977 · S/N 28-7890006N68EEBurtt John B · Pierson, MIBuilt 1975 · S/N 18-7509087N68FSistrunk Donald M · Ragley, LABuilt 1956 · S/N 22-4107N68FDVargas Emmanuel N · Murrieta, CABuilt 1988 · S/N 306N68GJDc Foote & Associates Inc · Camarillo, CAS/N 28-7425210N68HKPomeroy Andy Lee · Seattle, WABuilt 2004 · S/N 60323N68JBOtto Pilot LLC · Everett, WABuilt 1963 · S/N 24-3531N68JCCapps Jon T · Bentonville, ARBuilt 1975 · S/N AA5-0801N68JDCorman Justin W · Bridgeport, NEBuilt 1974 · S/N 32-7440130N68JJRegistration Pending · N Richlnd Hls, TXRegistration pendingBuilt 1966 · S/N 1107N68JTVallandi Amy E · Las Vegas, NVBuilt 1989 · S/N 904N68JXRybarczyk Thomas B · Benton, KSBuilt 1992 · S/N S1-10-59N68JYHowell Jon · Texarkana, ARBuilt 1968 · S/N 28R-30850N68KSeymour Robin · Woodland Hills, CABuilt 1976 · S/N 32R-7680227N68KBKeller Bros Airport Inc · Lebanon, PABuilt 1961 · S/N 24-2467N68KTHobein Ted · Wheaton, ILBuilt 1999 · S/N 22584N68LCDriver Matthew · Rio Rancho, NMBuilt 1966 · S/N 670243N68LHGottschall James W · Highland, WIBuilt 1990 · S/N 434N68LKKing Larry E Jr · Wenatchee, WABuilt 1968 · S/N 18-8642N68LRMs Aero Inc · Lakeville, OHBuilt 1966 · S/N 30-1000N68MABig Creek Flyers LLC · Lewes, DEBuilt 2004 · S/N 2277N68MCAlpha Enterprises · Burley, IDBuilt 1981 · S/N 8-0004N68MWCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1975 · S/N 27-7554126N68NDSand Nicholas Patrick · Alta, IABuilt 1992 · S/N 668-92N68QCobb Lee C · Van Alstyne, TXBuilt 1971 · S/N OHB-1970N68RLeroy Philippe G · Willcox, AZS/N 2114N68RLSlutz David E · Morristown, TNBuilt 1979 · S/N AA5A0865N68RSAlston Walter III · Fernandina Beach, FLBuilt 2010 · S/N 73299N68RVSteed David A · Oklahoma City, OKS/N 20100N68SBLucey William E · Salisbury, NCBuilt 1984 · S/N 562N68SCBridges Lee P · Smithville, TNBuilt 1964 · S/N 30-633N68SDPro Aero LLC · Warrenton, VABuilt 1979 · S/N 32-7940126N68SEGateway Flight Center LLC · Port Lavaca, TXS/N 27-3780N68TSSmith Timothy R · Victoria, TXBuilt 1981 · S/N 1013N68TYKing Ty · Rogers, ARBuilt 1968 · S/N 28-11207N68VCammack Daniel P · Colorado Springs, COBuilt 1967 · S/N 28-4552N68VEK F Aviation Inc · San Juan, PRBuilt 1970 · S/N 27-4457N68VRGene Coleman Machine Inc · Menominee, MIBuilt 2004 · S/N 434N68WLGlobal Pilot Inc · Wilmington, DES/N 70600N68WPButseev Anthony · Tarzana, CABuilt 1996 · S/N 23661N68WWGalloway Lyle R · Ashton, IDBuilt 2005 · S/N 2035
Back to AD 87-10-06 R1