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.

N8839DHunter Houston W Jr · Marrero, LABuilt 1958 · S/N 22-6009N8839JPadgett John E · Austin, TXS/N 28-2796N8839NCooper Thomas J · Henderson, NVBuilt 1969 · S/N 28-25690N8839WKarval Fliers LLC · Karval, COBuilt 1964 · S/N 28-10388N8839YMcguinness William V IV · Houston, TXBuilt 1969 · S/N 39-2N883CFolkers Daniel E · Norwalk, IABuilt 1973 · S/N 28-7325345N883CGBrock Gary G · Roseboro, NCBuilt 2008 · S/N 90904N883DFAerial Ag Services LLC · Hillsboro, TXBuilt 2006 · S/N 11212N883HPStudio 15 Commercial Interiors Inc · Cherokee, NCBuilt 2000 · S/N T20608235N883JJJaffe Jordan E · Horseshoe Bay, TXBuilt 2003 · S/N 910-2003N883MMoffett James D · North East, MDBuilt 1969 · S/N 28-26047N883RVMann Allen W Trustee · Post Falls, IDBuilt 1993 · S/N 21677N883TCCoughlin Brian T · Cazenovia, NYBuilt 2023 · S/N 001N883TTRoser John E · Lake St Louis, MOBuilt 2003 · S/N 60576N88401Kimball Clayton Scott · Richland, WABuilt 1974 · S/N 122-75N88405Mulhern Georgia · Waddell, AZS/N 784-75N8840FPinchorski Ronald G · Wiconisco, PABuilt 1963 · S/N 33-0185N8840NBouillon Gloria J · Somerville, MABuilt 1969 · S/N 28-25691N8840PStutzman John M · Grand Rapids, MIBuilt 1965 · S/N 24-4295N8840WLee Ronald A · Bend, ORBuilt 1964 · S/N 28-10389N88412Rider Shawna · Anchorage, AKS/N 779-75N88417Alaska Department Of Fish And Game · Fairbanks, AKS/N 123-75N8841JE & G Flying Club LLC · Alliance, OHBuilt 1965 · S/N 28-2798N8841PBotsacos Chris S DBA · Long Beach, CABuilt 1965 · S/N 24-4296N8841WRegistration Pending · Dilley, TXRegistration pendingBuilt 1964 · S/N 28-10390N8841YHoffman Avery E · Bethel, AKBuilt 1973 · S/N 18-7309025N88421Dular Emil M · Elizabethtown, KYBuilt 1974 · S/N 785-75N88424Iowa Aerial Advertising LLC · Perry, IAS/N 305-75N88425Klamar Spraying Inc · Gatzke, MNBuilt 1974 · S/N 786-75N88428Mason Fred B · Waterford, OHBuilt 1974 · S/N 162-75N8842CTerry Jay F · Rome City, INBuilt 1953 · S/N 22-1455N8842DVan Bergeyk Ronald J · Trapper Creek, AKBuilt 1958 · S/N 22-6012N8842JCrowe Steven A · Bend, ORBuilt 1965 · S/N 28-2799N8842PGauss Roger W · Forest Hill, MDBuilt 1965 · S/N 24-4297N8842WMott Terry W · Hampton, IABuilt 1964 · S/N 28-10392N8842YQuest Aviation Inc · Houlton, MEBuilt 1969 · S/N 30-2000N88437Vst Aviation LLC · Ball Ground, GABuilt 1974 · S/N 490-75N8843JDiorio Christopher J · Melba, IDS/N 28-2801N8843LPolries Larry J · Jamestown, NDS/N 25-5354N8843PRodarte Lionel A · Downey, CABuilt 1965 · S/N 24-4298N8843WDay Eric N · Weatherford, TXBuilt 1964 · S/N 28-10393N8843YBw Aviation LLC · Wilmington, DES/N 32R-8013061N88443Jkt LLC · Douglas, WYBuilt 1974 · S/N 130-75N8844JCave Anthony B · Round Rock, TXBuilt 1965 · S/N 28-2802N8844NBruegmann Fred R III · Northfield, ILBuilt 1969 · S/N 28-25695N8844PReetz Roger D · Duluth, MNBuilt 1965 · S/N 24-4299N8844YStreater Aviation LLC · Weirsdale, FLBuilt 1969 · S/N 39-3N8845Rudloff Uwe K · Lake Village, INBuilt 1973 · S/N 365-73N88451Williams Charles S · Pearland, TXS/N 131-75N88458Cole John R · Greenfield, INBuilt 1975 · S/N 790-75
Back to AD 87-10-06 R1