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.

N88061Stoican Steve G · Ryegate, MTS/N DW-1-0045-81N88063Evenson Gabriel J · Fargo, NDS/N 461-74N88065Obx Airplanes LLC · Manteo, NCBuilt 1974 · S/N 460-74N88066Nightingale Patrick R · Lakewood, CABuilt 1974 · S/N 1037-74N8806JLytle Hugh R · Senoia, GABuilt 1965 · S/N 28-2756N8806KMadsen Travis E · New Underwood, SDBuilt 1981 · S/N DW-1-0041-81N8806LMadsen Travis E · New Underwood, SDBuilt 1981 · S/N DW-1-0042-81N8806NHorne Terry A · Carefree, AZBuilt 1969 · S/N 28-25652N8806PZiolkowski James E · Amarillo, TXBuilt 1965 · S/N 24-4261N8806WKennemer Mark · San Angelo, TXBuilt 1964 · S/N 28-10351N8807Potter David · Huntley, ILBuilt 1973 · S/N 473-73N88078Khm Investments Inc · Lehi, UTBuilt 1974 · S/N 464-74N8807DGorski Tim B · Larsen, WIBuilt 1958 · S/N 22-5975N8807JNorris Dana G III · Zanesville, OHS/N 28-2757N8807NTruax James D · Roanoke, INBuilt 1969 · S/N 28-25653N8807PRegistered aircraftBuilt 1965 · S/N 24-4263N8807WSimon Randall V P · Fairbanks, AKBuilt 1966 · S/N 28-10803N8807YRich Lucas Aircraft Sales LLC · Lincoln Park, NJBuilt 1969 · S/N 30-1964N8807ZMadsen Travis E · New Underwood, SDBuilt 1981 · S/N DW-1-0049-81N88081Butler Julie L · Los Osos, CABuilt 1974 · S/N 718-74N88083N3542w Inc · Wilmington, DEBuilt 1974 · S/N 719-74N88085Poulson Daniel J · Anchorage, AKBuilt 1974 · S/N 722-74N8808BSemple Gary W · Flaxville, MTBuilt 1981 · S/N DW-1-0050-81N8808DDwight Thomas W · Castalia, OHBuilt 1958 · S/N 22-5977N8808JCoulliette Brian K · Jacksonville, FLBuilt 1965 · S/N 28-2758N8808WHolysz Matthew M · Vicksburg, MIBuilt 1964 · S/N 28-10353N8808YAukes Brian E · Huxley, IABuilt 1969 · S/N 30-1965N88092Verhulst Charles · Reva, SDBuilt 1974 · S/N 723-74N88098Merriwether David E · Whitesburg, GABuilt 1974 · S/N 467-74N8809PPa24 LLC · Painesville, OHBuilt 1965 · S/N 24-4265N8809UDoyles Ag Services LLC · Two Buttes, COBuilt 1982 · S/N DW-1-0058-82N880CBJ-Airco LLC · Nashville, TNBuilt 1973 · S/N 17262582N880FTFlorida Institute Of Technology · Melbourne, FLBuilt 2000 · S/N 4496033N880GLNew England Airlines Inc · Westerly, RIS/N 2020N880HCBadger Heli Corp · Wilmington, DEBuilt 1989 · S/N 1208N880JGGray Richard D · White Stone, VABuilt 2022 · S/N 82827N880MXCool Breeze LLC · Shelbyville, KYBuilt 2002 · S/N 002DCN880PUPurdue University Trustees · West Lafayette, INBuilt 2025 · S/N 2881949N880RCPuerto Rico Aircraft Leasing Corp · Ceiba, PRBuilt 1973 · S/N 31-7305022N880SCKc Hawgs Inc · Wilmington, DEBuilt 1979 · S/N 32R-8029015N880THAviation Peter Corp Of New York · New York, NYBuilt 1980 · S/N 172RG0522N880XPAllen Ryan L · Lafayette, INBuilt 2026 · S/N 41308N88108Nor-Wes Inc · Shreveport, LABuilt 1982 · S/N DW-1-0068-82N8810DNorman Timothy J · Tofte, MNBuilt 1958 · S/N 22-5979N8810NShawl Robert M · Woodlake, CABuilt 1969 · S/N 28-25657N8810WLayne Andrew P · North Port, FLBuilt 1964 · S/N 28-10355N88110Lovas Thomas A · Anchorage, AKBuilt 1974 · S/N 725-74N88118Richard Thomas W · Greenville, MSBuilt 1974 · S/N 726-74N88119Aysta Nathan P · Hermantown, MNBuilt 1974 · S/N 606-74N8811UAlder William D III · Athens, OHBuilt 1965 · S/N 17252718
Back to AD 87-10-06 R1