OpenAirDocs.org
AD 87-20-03 R2

Registered aircraft · 54,015

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

N8175SAnderson Marcus D · Memphis, TNBuilt 1965 · S/N 15061775N8175TMachovsky Randolph P · Montague, MIBuilt 1960 · S/N 17556875N8175UN8175u LLC · Rosemount, MNS/N 17252075N8175VTaylor Charles G · Knoxville, TNBuilt 1974 · S/N A1500555N8175XBeebe Shawn D · Ammon, IDBuilt 1961 · S/N 17248675N8176AThom Jacob D · Wasilla, AKS/N 25028N8176LAdams David F · South Lyon, MIBuilt 1967 · S/N 17256376N8176XCorrigan Walter E Jr · Seward, AKBuilt 1961 · S/N 17248676N81772American Patrols Inc · Midland, TXS/N 17263860N81775Flying B Aviation LLC · Waynesboro, TNBuilt 1967 · S/N 17255171N8177FLong Steven J · Amery, WIBuilt 1966 · S/N 15064277N8177LDenton Scotchie M · Calhoun City, MSS/N 17256377N8177TRegistration Pending · Fairmont, WVRegistration pendingBuilt 1960 · S/N 17556877N8177XUnderground Aviation Group LLC · Elizabethtown, PABuilt 1961 · S/N 17248677N8177ZWilliams Dutch R · Mohave Valley, AZBuilt 1962 · S/N 205-0177N8178LMalone Traci L M · Effingham, ILBuilt 1967 · S/N 17256378N8178TFairbanks Kelly E · Twin Falls, IDBuilt 1960 · S/N 17556878N8178XPaulsen Olaf · Clackamas, ORBuilt 1961 · S/N 17248678N8178ZCameron Joseph · Tucson, AZBuilt 1963 · S/N 205-0178N8179BWolford Robert C · Knoxville, TNBuilt 1957 · S/N 29979N8179DGarza Jose R Jr · West Jordan, UTBuilt 1971 · S/N 177RG0009N8179LExecutive Wings LLC · Bolivar, TNBuilt 1967 · S/N 17256379N8179SOllantair LLC · Chicago, ILBuilt 1965 · S/N 15061779N8179THill Jason M · Bakersfield, CABuilt 1960 · S/N 17556879N817AKZweifel Brad · Palmer, AKBuilt 1958 · S/N 55101N817PSSutton Aircraft Salvage LLC · Palmer, AKBuilt 1965 · S/N 17252705N817TStone Michael A · Winston Salem, NCS/N 17250644N817ZBennett Condon P · Stormville, NYBuilt 1976 · S/N 17266787N818High Alpha Airshows LLC · Santa Rosa Valley, CABuilt 1968 · S/N 15069651N8180Wayman Daniel M · Medford, ORBuilt 1981 · S/N 18053189N8180ANipp Michael P · Nampa, IDBuilt 1952 · S/N 25032N8180BNiehaus James O · Erie, COBuilt 1957 · S/N 29980N8180LManser Andrew R · Neenah, WIBuilt 1967 · S/N 17256380N8180MLeap Aviation Inc · Wilmington, DES/N 17260570N8180ZAikins Nicholas O · Renton, WABuilt 1962 · S/N 205-0180N8181BManning Richard F Jr · Midway, GABuilt 1957 · S/N 29981N8181SCopeland Kevin D · Vidalia, GABuilt 1965 · S/N 15061781N8181THetge Kenneth R · Viola, ARBuilt 1961 · S/N 17556881N8181UMillman Chris · Auburn, WABuilt 1964 · S/N 17252081N8182ERed Arrow Aviation LLC · Santa Teresa, NMBuilt 1978 · S/N 17272148N8182UMorristown Flying Service Inc · Talbott, TNBuilt 1964 · S/N 17252082N8182ZWolf Richard Cory · Syracuse, UTBuilt 1963 · S/N 2050182N8183ARegistered aircraftBuilt 1952 · S/N 25035N8183FArvizu Jason Arthur Scott · Bakersfield, CABuilt 1966 · S/N 15064283N8183MHaman Peter A · Douglas, WYBuilt 1977 · S/N 21062033N8183THysell Donovan · Atwater, OHBuilt 1960 · S/N 17556883N8183UMacauley Richard D · Shingle Springs, CABuilt 1964 · S/N 17252083N8184BPalouse Aviation Holdings LLC · Moscow, IDBuilt 1957 · S/N 29984N8184GAspire Aviation LLC · Farmingdale, NYBuilt 1979 · S/N 17273615N8184LVanderlaan Dirk C · Reno, NVBuilt 1967 · S/N 17256384
Back to AD 87-20-03 R2