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.

N709MWGrant Michael R · South Weber, UTBuilt 1968 · S/N 172-56629N709RVOliveira John S · Port Townsend, WABuilt 2012 · S/N 90054N709RWHogan David G · Urbandale, IABuilt 2017 · S/N 22213N709SAN709sa LLC · Maxville, FLBuilt 1983 · S/N 318352027N709SCRunamuck LLC · New Orleans, LABuilt 2023 · S/N 2881624N709WBBowman Stephen L · Palm Bay, FLBuilt 1972 · S/N 1N70ABVastola Alex G · Conroe, TXBuilt 2020 · S/N 70225N70BBKidd Howard C · Sawyer, OKBuilt 1963 · S/N 28-10198N70BMAatw LLC · Conway, ARBuilt 1984 · S/N 429N70BTBurg Robert L · Fairbanks, AKBuilt 1974 · S/N 18-7409098N70BZFaibisoff Isaac J · Caseyville, ILBuilt 2005 · S/N 1325N70CDLewis Cherrie · Hampton, CTBuilt 1969 · S/N 28-26542N70CEBandit Soaring LLC · Gig Harbor, WABuilt 1997 · S/N GA0058N70CKAlbatross Air Inc · Beaver, WVBuilt 1972 · S/N 32-7200043N70EF720 Degrees Inc · Santa Monica, CABuilt 1972 · S/N 28R-7335064N70EPMccain William A · Jackson, MSBuilt 1996 · S/N 20809N70FGPears Aviation Corp · Kissimmee, FLS/N 28-7890410N70FLFl Jet Services Inc · Miami Springs, FLFirst renewal noticeBuilt 1978 · S/N 31-7952030N70GBVinter Mooney LLC · Philadelphia, PABuilt 1976 · S/N 20-1196N70GDBig Bend Soaring Inc · Port Orange, FLBuilt 1976 · S/N AA5B-0338N70GGAnderson Gary · Port Orange, FLBuilt 2018 · S/N L2K-141N70GKScott Archer LLC · Scott City, KSBuilt 1977 · S/N 28-7790590N70GSDavis Jeffrey W · Thomasville, NCBuilt 1992 · S/N 2057N70GTTaylor Gary T · Ontario, ORBuilt 1985 · S/N 8-0157N70GVWeidner Melvin · Elk Grove, CAS/N 24-482N70HFCavorite Aviation LLC · West Jordan, UTBuilt 1977 · S/N 28-7890248N70HHAmys Aircraft Services LLC · Bridgeton, MOBuilt 1974 · S/N 31-7405208N70HUHexom Nathan · Bozeman, MTBuilt 1996 · S/N 1322N70HYHigher Powered Racing LLC · Port Saint Lucie, FLBuilt 2004 · S/N 2257N70JHBlythe Anne T · Paso Robles, CABuilt 1970 · S/N JH-2N70JMTriple M Investments LLC · Whitehall, PABuilt 1976 · S/N 32R-7680259N70KAEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 2001 · S/N 1058N70KCLa Chabola Aviation LLC · Plano, TXBuilt 1976 · S/N 61P-0291-070N70KDN70kd Research & Development LLC · Keller, TXBuilt 2000 · S/N 60282N70KPPrichard Kevin L · Enterprise, KSBuilt 1969 · S/N 17257954N70LMIrving Mark S · Cordova, AKBuilt 1946 · S/N 12-490N70MHN70mh LLC · Wilmington, DEBuilt 1976 · S/N 28R-7635390N70MPWhitewater River Runners LLC · Wilmington, DEFirst renewal noticeBuilt 1994 · S/N 21338N70NCB2 Aero Corp · Jamestown, NCBuilt 1978 · S/N 28-7911077N70NGGriffin Bernard · Peckville, PABuilt 2002 · S/N 70N70NTTaylor Margaret L Trustee · Ontario, ORFirst renewal noticeS/N 94-0129N70PFSwaz Aviation LLC · Mesa, AZBuilt 1981 · S/N 28-8116264N70PWStoner Tommy E · Kennesaw, GABuilt 1976 · S/N AA5B-0265N70REHendricks Field Aviation LLC · Sebring, FLBuilt 2012 · S/N 70238N70RPPulis John · Willis, TXBuilt 2023 · S/N 1010AN70RVDonovan Gerald A · Los Lunas, NMBuilt 1991 · S/N 2139N70RWHines Thomas J · Anchorage, AKBuilt 1975 · S/N 150N70SFFred Stuart L · Houston, TXBuilt 2005 · S/N 493-2005N70SHGarmin International · Olathe, KSBuilt 2011 · S/N 71108N70SRBray Max W · Dora, ALBuilt 1967 · S/N 28R-30122
Back to AD 87-10-06 R1