OpenAirDocs.org
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.

N600WPort Of Tillamook Bay · Tillamook, ORS/N 1N600ZKSeventh LLC · Ocala, FLBuilt 2021 · S/N PX1520013N60104Theo-N60104 LLC · Wilmington, DEBuilt 1978 · S/N M-2093N60106Lutzko Timothy R · Ocean View, DEBuilt 1978 · S/N M-2094N6010CBig Bend Community College · Moses Lake, WABuilt 1978 · S/N MB-905N6010DTrenkamp John F · Oskaloosa, IAS/N 22-4662N6010LBergstrom Robert L · Amelia, VABuilt 1972 · S/N AA5-0110N6010PSniffen Kirby K · Sycamore, OHBuilt 1959 · S/N 24-1104N6010YSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1993 · S/N 14589N6011FAmeriflyers Of Texas Inc · Addison, TXBuilt 2022 · S/N 28020090N6011JSymond Clarence B · Eastover, NCBuilt 1978 · S/N MC-625N6011LBiondich Amy Sue · Rubicon, WIBuilt 1972 · S/N AA5-0111N6011QHikari Aviation Ltd · Torrance, CABuilt 1978 · S/N ME-100N6011UJin Jin Aviation LLC · Anchorage, AKBuilt 1978 · S/N ME-101N6011YTab Associates Inc DBA · Port Saint Lucie, FLBuilt 1966 · S/N 27-3193N6012FSanders Flight Training Center · Jasper, ALBuilt 1965 · S/N TD-616N6012LCloudkicker Lc · Sioux Falls, SDBuilt 1972 · S/N AA5-0112N6012QClassic Aircraft LLC · West Point, NEBuilt 1965 · S/N 864N6012YBieszczad Wally · Bloomingdale, ILBuilt 1979 · S/N M-2106N60135Charles Ray Aviation LLC · Fleming Island, FLBuilt 1979 · S/N M-2105N6013DBennett Garrett Douglas · Bonners Ferry, IDBuilt 1956 · S/N 22-4665N6013LCraven Jeremy A · Winter Garden, FLBuilt 1972 · S/N AA5-0113N6013ZVandelay Aviation LLC · San Diego, CABuilt 1978 · S/N ME-112N6014CHangar 14 LLC · Spokane, WABuilt 1978 · S/N R18200352N6014PTwo Men And A Plane Inc · Dearborn, MIBuilt 1959 · S/N 24-1109N6014WLeaders Bob O · Clear Lake, MNBuilt 1964 · S/N 28-20014N6014YBackscheider Eric D · La Follette, TNBuilt 1997 · S/N 24367N6014ZSimpson Alena A · Blue Eye, MOBuilt 1979 · S/N M-2141N60156Shannon School Of Aeronautics LLC · Fredericksburg, VABuilt 1979 · S/N ME-147N6015FAmeriflyers Of Texas Inc · Addison, TXBuilt 2022 · S/N 28020091N6015LWade Rolla R · Kingsport, TNBuilt 1972 · S/N AA5-0115N6015PWeeks Vaughan B · Racine, WIBuilt 1959 · S/N 24-1110N6015QBohlke LLC · Kingshill, VIBuilt 1979 · S/N ME-141N6015UN6015u LLC · Lakeview, NCS/N M-2135N6015ZOsorio Aviation Corp · Miami, FLNon-citizen corporation, flight hours not reportedBuilt 1979 · S/N ME-145N60165Caballero Arturo C · Clute, TXBuilt 1979 · S/N M-2145N6016DWells Roger M · Stratford, TXBuilt 1956 · S/N 22-4669N6016KRamsey Keith W · Morrison, TNS/N MC-646N6016LAssociated Aircraft LLC · San Diego, CABuilt 1975 · S/N 0710N6016PCorson Dana · Helena, MTBuilt 1959 · S/N 24-1111N6016QAbrahem Bishoy · Bakersfield, CABuilt 1965 · S/N 866N6016UAbbasi Babak · Escondido, CABuilt 1979 · S/N ME-156N6016XBeland Michael R · Maiden, NCS/N 1650N6016YClute Jack S · Valparaiso, INBuilt 1979 · S/N MC-650N6016ZPrestenbach Kyle A · Vacherie, LAS/N 25-19N6017WKarg James R · Paradise, TXBuilt 1964 · S/N 28-20017N6017YTulsa Technology Center School District No 18 · Tulsa, OKS/N 27-3200N6018DBader Ronald W · Montrose, MIBuilt 1956 · S/N 22-4671N6018FAmeriflyers Of Texas Inc · Addison, TXBuilt 2022 · S/N 28020092N6018QWilson Reed · Arlington, VABuilt 1965 · S/N 868
Back to AD 87-10-06 R1