OpenAirDocs.org
AD 87-10-06 R1

Registered aircraft · 72,001

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.

N161MABarnes Gordon R · Manalapan, NJBuilt 2000 · S/N 3257161N161MBKerf 25 Corp · Wilmington, DEBuilt 1982 · S/N 28-8216163N161MRVictor Aircraft Co · Wilmington, DEBuilt 1977 · S/N 27-7754106N161MSBaker Weldon J · Lamesa, TXBuilt 2002 · S/N 60469N161PRegistered aircraftBuilt 1958 · S/N 24-533N161PCSpence Jeffrey · Haskell, OKBuilt 2020 · S/N 40052N161PSBond Robert E · Knoxville, TNBuilt 1996 · S/N 5339N161PTPilot Training Center LLC · Miami, FLBuilt 1989 · S/N 2841156N161REVornholt David · New Richmond, OHBuilt 1969 · S/N 30-1952N161RPCrucial LLC · Kalispell, MTBuilt 1982 · S/N 32R-8213049N161RVMatice Brian W · Riverview, FLBuilt 2022 · S/N 74520N161RWMcdonald Walter S · Park City, UTBuilt 2006 · S/N 53MN161SAAviation Consultants Inc DBA · San Luis Obispo, CABuilt 2002 · S/N 901-2002N161SG3bs Aviation LLC · Wilmington, DEBuilt 2005 · S/N 1000-2005N161SMMorcom Aviation Services Inc DBA · Everett, WABuilt 1979 · S/N 28-7916508N161SWLober Cameron K · Matthews, NCBuilt 1966 · S/N 28-3752N161TCAkrotown USA LLC · Tualatin, ORS/N 5357N161TFAirmart Inc · Lexington, KYBuilt 2022 · S/N 2881549N161WAWashburn Aviation LLC · Murfreesboro, TNS/N 5259N162Payne David J · Eagle River, AKBuilt 1957 · S/N 22-5677N1620ABeaver David W Trustee · Wasilla, AKBuilt 1952 · S/N 18-1263N1620GDrexler Charles T · Albuquerque, NMBuilt 1968 · S/N 123N1620PNielsen Mona · Ford, WABuilt 1954 · S/N 22-2434N1622AKelly Steven L · Saline, MIBuilt 2016 · S/N 5574N1622PBaker Kenneth C · Brenham, TXBuilt 1992 · S/N 3213040N16244Oakland William S · New Port Richey, FLBuilt 1973 · S/N 28-7305211N162505b Aviation LLC · Duncan, OKBuilt 1973 · S/N 28-7305212N16252Robbins Warren N · Chandler, AZBuilt 1973 · S/N 28-7305213N16253Quincy Aircraft LLC · Quincy, ILS/N 32-7340080N16257Chauvet Nicolas · North Kingstown, RIBuilt 1973 · S/N 28-7305216N1625GPippert Jim · Dysart, IABuilt 1968 · S/N 127N1625JCain Philip K · Escondido, CABuilt 1968 · S/N 28-24818N1625LArtime Jorge Daniel · Miami Beach, FLBuilt 1979 · S/N 13N1625PGauthier Robert Jones · Melba, IDBuilt 1954 · S/N 22-2439N16269Kelley John Charles · Hot Springs Ntl, ARBuilt 1973 · S/N 32-7340081N1626JLawrence Gavin · Borger, TXBuilt 1967 · S/N 28-24013N16273Taildraggers LLC · Syracuse, KSBuilt 1973 · S/N 28-7305217N16278Cademartori Joel T · Norris, TNBuilt 1973 · S/N 28R-7335121N16279Deyoung Christopher H · Tucson, AZBuilt 1973 · S/N 28-7310083N1627APlettner David C · Sutton, NEBuilt 1951 · S/N 18-1267N1627EWichterman George J Trustee · Fort Myers, FLBuilt 1978 · S/N 17271070N1627HCirrus Services Inc · Fargo, NDBuilt 1977 · S/N 28-7716028N1627PMiller Wesley M · Crookston, MNBuilt 1954 · S/N 22-2441N16283Winn Philip P · Salem, OHBuilt 1973 · S/N 28-7325231N16284Rocco Jeffrey M · Carson, CABuilt 1969 · S/N 28-26015N16288Bailey Brent M · Dalzell, SCBuilt 1973 · S/N 28-7325234N16289Williams Kevin L · Buchanan, TNBuilt 1973 · S/N 28-7325235N1628HWarrior N1628h LLC · Huntsville, ALBuilt 1977 · S/N 28-7716029N16292Morcom Aviation Services Inc DBA · Everett, WABuilt 1973 · S/N 34-7350125N16293Quale Jeffrey L · Craig, COFirst renewal noticeBuilt 1973 · S/N 28R-7335123
Back to AD 87-10-06 R1