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.

N4100ZMountain Escape LLC · Pullman, WAS/N 18-8114N4101BBerry Larry A · Bryan, TXBuilt 1974 · S/N 74-31106N4101JRichardson Howell · Gilbert, AZBuilt 1966 · S/N 28-22413N4101NGateway Of Sturgis LLC · Sturgis, MIBuilt 1981 · S/N 31-8252010N4101RMclean David L · Nashville, TNBuilt 1968 · S/N 32-40489N4101YBower Gary R · Miranda, SDBuilt 1976 · S/N 230-76N4102BLamay James R · Reno, NVBuilt 1977 · S/N 77-31136N4102HForeman Guy W · Valparaiso, INBuilt 1978 · S/N 240617N4102JCarto Flight Inc · Willoughby, OHBuilt 1981 · S/N 31-8152158N4102PDoran Jeffrey T · Westerville, OHBuilt 1959 · S/N 23-1582N4102RDudzinski James · Reno, NVBuilt 1968 · S/N 32-40418N4102WSkirzynski Eric N · Meridian, IDBuilt 1967 · S/N 32-40165N4102ZValley Airways Inc · Scottsbluff, NEBuilt 1981 · S/N 31-8212009N4103NKarpik Joseph Paul · Floodwood, MNS/N 680074N4103PLumley John J · Delray Beach, FLBuilt 1959 · S/N 23-1583N4103WBean Sheila L · San Antonio, TXBuilt 1967 · S/N 32-40166N4104KStar Marianas Aviation School Inc · Tinian, MPBuilt 1982 · S/N 31-8252018N4104PSpooter Air II LLC · Willis, TXBuilt 1959 · S/N 23-1584N4104XBandy Carla Sr · Texarkana, TXBuilt 1968 · S/N 201N4104YBurgett Gary · Galena, AKBuilt 1976 · S/N 945-76N4104ZZelina William B III · Fort Greely, AKBuilt 1964 · S/N 18-8124N4105CJohnson Rodney R · Roseburg, ORS/N R18200322N4105DGrant Aviation Inc · Anchorage, AKFirst renewal noticeBuilt 1981 · S/N 31-8252027N4105HBonanza Valley Air LLC · Alexandria, MNBuilt 1978 · S/N 24-0621N4105RWertz Travis F · Richland Center, WIBuilt 1968 · S/N 32-40424N4105ZMccaughey Steven A · Winter Haven, FLBuilt 1964 · S/N 18-8126N4106CAir Data Solutions LLC · Natchitoches, LABuilt 1978 · S/N R18200323N4106FRocket Air Charter LLC · Melbourne, FLBuilt 1982 · S/N 31-8252034N4106JFlander Donald D · What Cheer, IABuilt 1966 · S/N 28-22419N4106NGioia Matthew M · Stafford, VABuilt 1968 · S/N 680035N4106XRossiter Andrew J · Vancouver, WAS/N 203N4106ZJohnson Royce D · Clinton, ARBuilt 1964 · S/N 188127N4107NWest Main Auto Sales Inc · Tupelo, MSS/N 680075N4107PTm Aero Marine Inc · North Miami, FLBuilt 1959 · S/N 23-1562N4107QGrant Aviation Inc · Anchorage, AKBuilt 1982 · S/N 31-8253008N4107RSatnews Publishers Inc · Carson City, NVBuilt 1967 · S/N 32-40426N4107XRedsun Oren Daniel · Fairfield, CAS/N 205N4107ZMissaukee Aircraft Leasing LLC · Cadillac, MIBuilt 1964 · S/N 18-8128N4108JMetoyer Eric D · Yukon, OKBuilt 1966 · S/N 28-22421N4108WArrow Ventures Inc · Lake Preston, SDS/N 32-40171N4108ZRamstad Trygg J · Anchorage, AKBuilt 1964 · S/N 18-8130N4109AMarc Inc · Bolton, MSBuilt 1970 · S/N 27-4459N4109FB&C Blue Sky II LLC · Augusta, GABuilt 1982 · S/N 31-8212027N4109NRoss George H · Delano, MNS/N 680036N4109ZAlf Robert R · Elkhorn, NEBuilt 1964 · S/N 18-8129N410BLRegistered aircraftBuilt 2013 · S/N 40684N410BPWeiss Michael K · Paige, TXBuilt 2012 · S/N P01-P001/P002-P121N410BWHeffelfinger Darin W · Sterling, ILS/N 106N410CPNomad Flight One Inc · Clearwater, FLBuilt 2003 · S/N 3255010N410DPConner Mark A · Palmetto, FLBuilt 2011 · S/N 41135
Back to AD 87-10-06 R1