OpenAirDocs.org
AD 87-03-08

Registered aircraft · 1,364

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-03-08')
    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-03-08')
  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.

N1023DGregg John I Jr · Glendale, AZS/N 10520N10JLSmith Loren D · Great Falls, MTBuilt 1946 · S/N 6681N111THMartin Jesse A · Gainesville, FLBuilt 1946 · S/N 10044N1182KUllrich Sandy J · Haskell, OKS/N 8309N121BXEnglish Dexter · Syracuse, KSS/N 8960N128ZKammer Frank B · Ringgold, GAS/N 7149N13HSGregg Brian L · Guthrie, OKS/N F-039N144ELubeck Thomas L · Anchorage, AKBuilt 1974 · S/N F-013N1510TRegistered aircraftAssigned, pending cancellationS/N 2868N175JBWhitcher Garrick L · Woodburn, ORS/N 1607N18ECJenkins Norman G · North Pole, AKBuilt 1977 · S/N F-083N1938BKing Richard S · San Antonio, TXBuilt 1938 · S/N 1101N1941XNezgoda Daniel A Jr · Las Vegas, NVS/N 2558N19461Bouchard Jason A · Carmel Valley, CAS/N 9820N194KJCollins Richard F · Lake Wales, FLBuilt 1948 · S/N 12010N1951JDelaney John D · Mineral Point, WIBuilt 1946 · S/N 9902N197HKaspar Russell B · Frankfort, INBuilt 1941 · S/N 2915N19JLPodeweltz Dana A · Merrill, WIBuilt 1946 · S/N 6719N19TEBolton Adam W · Anchorage, AKS/N F-104N20004Kania Chester J Jr · Alton, NHBuilt 1978 · S/N F-129N2000UHanscom Rodney L · Holden, MEBuilt 1978 · S/N F-124N2000VHobson George A · Fairbanks, AKBuilt 1978 · S/N F-125N2001AMiller Brian T · Wasilla, AKBuilt 1978 · S/N F-130N2001JKrause Daniel J · Akron, COBuilt 1978 · S/N F-133N2001KJacko Josh E · Anchorage, AKBuilt 1978 · S/N F-134N2001TNystrom John H Trustee · Palmer, AKBuilt 1978 · S/N F-135N2002ALedford Stacey L · Saint Joseph, MOBuilt 1979 · S/N F-137N2002CStratus Air Services LLC · Punxsutawney, PABuilt 1979 · S/N F-138N2002VDay William S · Anchorage, AKBuilt 1979 · S/N F-142N2003CEggert Thomas F · Woodbury, MNBuilt 1979 · S/N F-147N2003KTobin Garvee Irene · Anchorage, AKS/N F-150N2003LOllmann Paul W · Poplar Grove, ILS/N F-151N2003XYelton Darrell A · Pleasant Hill, MOS/N F-152N2004ASwistunowicz Zygmunt S · Newtown Square, PABuilt 1979 · S/N F-153N2004HMolek Jon · Warren, OHS/N F-1004N2004VLindeman Jack E · Berlin, NYBuilt 1980 · S/N F-1007N2004YAmorelli Leon D · River Falls, WIBuilt 1980 · S/N F-1008N2005EShaw Brian W · Bemidji, MNBuilt 1981 · S/N F-1015N2005JGray Shane Charles · Interlochen, MIS/N F-1014N2005KBiornstad John A · Big Lake, AKBuilt 1981 · S/N F-1016N2005RMapes Rocky A · Thornton, COBuilt 1981 · S/N F-1012N2005SBaker James W · Rochester, NYBuilt 1982 · S/N F-1002N2005UArcand David R · Forest Lake, MNBuilt 1981 · S/N F-1013N2005ZKornstad Vern A · Kenai, AKBuilt 1982 · S/N F-1018N2006CPankratz David · Frazer, MTBuilt 1982 · S/N F-1501N2006JGlendinning William O · South Bristol, MEBuilt 1982 · S/N F-1021N2006LSutton Aircraft Salvage LLC · Palmer, AKBuilt 1982 · S/N F-1500N2006SSchimenek Richard J · Cloquet, MNS/N F-1502N2006TDanford Michael S · Chickamauga, GAS/N F-1503N2006UAllred Robert B · Anthem, AZBuilt 1983 · S/N F-1020
Back to AD 87-03-08