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.

N907SCCrowe Talmadge Layne Jr · Anchorage, AKS/N 18-4584N907STState Of Alaska Department Of Public Safety · Anchorage, AKBuilt 1960 · S/N 18-7262N907TTHangar Ak LLC · Sterling, AKBuilt 1974 · S/N 17262358N907TWCarpenter Orin C II · Anchorage, AKBuilt 2023 · S/N 0001N907UTClaus Paul E · Chitina, AKBuilt 1957 · S/N 18-5547N907VCVision Cubs LLC · Deville, LABuilt 2025 · S/N VC-18001N907VLBlue Waters Air Charters LLC · San Juan, PRBuilt 1973 · S/N 343N907WAPea-Wayman Flight LLC · Daytona Beach, FLBuilt 1976 · S/N 17267907N907WDWd Aircraft Investments LLC · Anchorage, AKBuilt 2000 · S/N T20608230N907WMSpano Darren M · Deville, LABuilt 1979 · S/N 18-8009038N907XLLunenschloss Michael L · Anchor Point, AKBuilt 1976 · S/N 18-7609010N9080DTrieber Steven M · Eastport, MEBuilt 1958 · S/N 18-6448N9080LStewarts Aircraft Service Inc · Waynesville, OHBuilt 1970 · S/N 255-70N9080NBoeing Co · Renton, WABuilt 1969 · S/N 3066N9081HRich Lucas Aircraft Sales LLC · Lincoln Park, NJBuilt 1975 · S/N 17265930N9081JPerkins Jimmy Keith · Lonoke, ARBuilt 1966 · S/N 28-3118N9081LReed William B Trustee · San Jose, CABuilt 1970 · S/N 224-70N9081PTriple J Aviation LLC · Turlock, CABuilt 1966 · S/N 24-4551N9081VSale Reported · Phoenix, AZSale reportedBuilt 1968 · S/N 690015N9081WStickley John E · Lothian, MDBuilt 1965 · S/N 28-10683N90829Leading Edge Aviation Consultants LLC · Windsor, CTBuilt 1985 · S/N 28-8690011N9082DLeahy Garry E · Van Wert, IABuilt 1958 · S/N 18-6450N9082PAmeneyro David · Walla Walla, WABuilt 1966 · S/N 24-4552N90839White Jake W · San Antonio, TXS/N 101N9083BNorth Coast Flight School Inc · Meadville, PABuilt 1985 · S/N 28-8590076N9083DSachs Randy S · S Huntington, NYBuilt 1986 · S/N 28-8690050N9083KShuey Robert D III · Albertville, ALBuilt 1977 · S/N 28-7890174N9083LPeavy Michael J · Chico, CAS/N 256-70N9083NKnoxville Flyers Inc · Knoxville, TNBuilt 1986 · S/N 28-8611005N9083PRowland Blayne Administrator · Raymondville, TXBuilt 1966 · S/N 24-4553N9084FIsland Bound LLC · Dunedin, FLBuilt 1980 · S/N 172RG0352N9084PSchafer Timothy M · Ridgefield, CTBuilt 1966 · S/N 24-4555N9084VLinear Air LLC · Herriman, UTBuilt 1968 · S/N 690018N9085JBligh Michelle C · Oceanside, CABuilt 1966 · S/N 28-3122N9085KSale Reported · Grayling, MISale reportedBuilt 1977 · S/N 28-7890175N9085LBlanton Jeffrey D · Valley Center, KSBuilt 1970 · S/N 226-70N9085PCross Seth B · Whitewood, SDS/N 24-4556N9085WColip Lydia · Bowling Green, INS/N 28-10689N9086DDarrow John K · Soldotna, AKBuilt 1958 · S/N 18-6460N9086JBrogan William J · Port Matilda, PABuilt 1966 · S/N 28-3123N9086KMedia Stew LLC · Carson City, NVBuilt 1977 · S/N 28-7890176N9086PRick Crum Aircraft Sales Inc · Prestonsburg, KYBuilt 1966 · S/N 24-4557N90874Myers Brian R · South Bend, INBuilt 1985 · S/N 28-8690014N90878Schmoll Steven D · Zimmerman, MNBuilt 1974 · S/N 194HN9087DBolden Family Farms · Little Rock, ARBuilt 1986 · S/N 2816001N9087VPyne Jeffery G · Waxhaw, NCBuilt 1986 · S/N 32R-8613005N9087WKohlhardt Ronald C Trustee · Cameron Park, CABuilt 1965 · S/N 28-10692N9088DMetro Aircraft Co · Bloomington, MNBuilt 1986 · S/N 28-8616049N9088EBrink Kirk H · Greeneville, TNBuilt 1977 · S/N 7092CN9088JRiggins Ryan W · Durango, COBuilt 1966 · S/N 28-3126
Back to AD 87-10-06 R1