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.

N8811YHutchinson Douglas E · Cle Elum, WABuilt 1969 · S/N 30-1968N88124West Aviation Inc · Creston, IABuilt 1982 · S/N DW-1-0078-82N88128Moore John T · Ward, ARBuilt 1982 · S/N DW-1-0080-82N8812BSale Reported · Missoula, MTSale reportedS/N DW-1-0073-82N8812DSowders Darwin G · Robinson, TXBuilt 1958 · S/N 22-5981N8812EHeiman Flying Services LLC · Summerfield, KSBuilt 1983 · S/N DW-1-0074-82N8812PRegistered aircraftBuilt 1965 · S/N 24-4267N8812YSpain Air LLC · Dadeville, ALBuilt 1969 · S/N 30-1969N88130Harper Clayton E · Seabrook, TXBuilt 1974 · S/N 727-74N88135Reed Aviation Inc · Iota, LABuilt 1982 · S/N DW-1-0085-82N8813CUlrich Helmut Wiegand · Satellite Beach, FLBuilt 1976 · S/N 32R-7680140N8813KPrecissi Flying Service Inc · Lodi, CABuilt 1982 · S/N DW-1-0084-82N8813MMja Flight LLC · Justin, TXBuilt 1964 · S/N TD-571N8813NLangton Shane A · Boise, IDBuilt 1969 · S/N 28-25660N8813PWolcott Kent E · Colorado Springs, COBuilt 1965 · S/N 24-4268N8813WOntiveros Carlos E · Prescott, AZBuilt 1964 · S/N 28-10359N88144Hitchens Steven · Conesville, OHS/N 79-74N88149Cheshire Brad F · Flower Mound, TXS/N 157-74N8814FBas Part Sales LLC · Greeley, COBuilt 1976 · S/N 28-7790268N8814JCarey H Dwain · Cheyenne, WYBuilt 1965 · S/N 28-2766N8814NMarshall Lance A · Portland, ORBuilt 1969 · S/N 28-25661N8814YTwin C 14y LLC · Cape Coral, FLBuilt 1969 · S/N 30-1972N88156Wilcox Aerial Applications Inc · Tilden, NEBuilt 1974 · S/N 730-74N8815NJenkins Roger Clayton II · Plain Dealing, LABuilt 1969 · S/N 28-25663N8815UHendrickson Tyrel L · Chester, MTBuilt 1983 · S/N DW-1-0094-83N8815YBauer Andrew J · Concord, NCBuilt 1969 · S/N 30-1973N88161Jordan Jay S · Wasilla, AKBuilt 1974 · S/N 84-74N88165Becker Aaron S · Santa Cruz, CABuilt 1974 · S/N 731-74N8816JHuff Roger A · Johnstown, OHBuilt 1965 · S/N 28-2770N8816LWindy City Soaring Association · Hinckley, ILBuilt 1971 · S/N 25-5321N88172Hughes Glenn D · Wrightsville Beach, NCBuilt 1974 · S/N 470-74N8817CSharon Ricky E · Roberta, GABuilt 1976 · S/N 28-7625132N8817JMy Bird Is Bigger Than Yours LLC · Fort Myers, FLBuilt 1965 · S/N 28-2771N8817PTei Corp · Kalispell, MTBuilt 1965 · S/N 24-4273N8817YWiehl Thomas K III · Earlysville, VABuilt 1969 · S/N 30-1975N88181Oglesby Holdings LLC · Henrico, VABuilt 1974 · S/N 732-74N88182Dachnowicz Peter A · Avon, CTBuilt 1974 · S/N 471-74N88184Delmolino Kevin R Sr · Walkersville, MDBuilt 1974 · S/N 472-74N88188Blair Keeley A · Erie, COBuilt 1974 · S/N 473-74N88189Ocean Aerial Ads Inc · Ocean City, MDS/N 89-74N8818XBeech Bash In The Bluegrass LLC · Fort Myers, FLBuilt 1973 · S/N 60-0143-063N8818YSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1969 · S/N 30-1976N88191Brown Dennis K · Reno, NVBuilt 1974 · S/N 474-74N88194Registered aircraftBuilt 1974 · S/N 91-74N8819ETransition Aviation LLC · Hummelstown, PABuilt 1976 · S/N 28R-7635209N8819PN8819p LLC · Boca Raton, FLBuilt 1965 · S/N 24-4275N8819WBowen Donald M · Wasco, ORBuilt 1964 · S/N 28-10367N881ACFly Twin Comanche LLC · Peoria, AZBuilt 2001 · S/N 172S8818N881BBBittner Robert A · Pewaukee, WIBuilt 2011 · S/N 1N881CDWestern Pilot Service Inc · Phoenix, AZBuilt 1958 · S/N TD-95
Back to AD 87-10-06 R1