OpenAirDocs.org
AD 87-20-03 R2

Registered aircraft · 54,017

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.

N4756EAero Missions Inc · Sylacauga, ALBuilt 1979 · S/N 18503862N4757DCalhoun Gerrald E · Leesburg, FLS/N 17272352N4757EHoogendorn Homer E · Wasilla, AKS/N 18503863N4757FMulcaire Jess E · Camp Verde, AZBuilt 1966 · S/N P206-0357N4757KGirard Gregory M · Tucson, AZBuilt 1979 · S/N P21000288N4757NTwin Falls Fliers Inc · Twin Falls, IDBuilt 1979 · S/N 18267343N4757QKroenke Seth M · Palmer, AKS/N 185-1216N4757THagen Brian T · Allen, TXBuilt 1981 · S/N R18201754N4757UPj Aviation LLC · Eden Prairie, MNBuilt 1965 · S/N 18051457N4757XFountain John D Jr · Lynchburg, SCBuilt 1966 · S/N 15064807N47582Beckham Jackie D Trustee · Coyle, OKS/N 15283238N47586Pea-Wayman Flight LLC · Daytona Beach, FLS/N 15283239N47587Neel Aviation LLC · Lakeland, FLS/N 15283240N4758BJaars Inc · Waxhaw, NCS/N 31656N4758DBurt William G · Tullahoma, TNBuilt 1958 · S/N 34858N4758KRuvo Scott J · Augusta, NJBuilt 1979 · S/N P21000289N4759BHoover Michael B · Ridgeland, WIS/N 31657N4759ERatcliff Stephen B · Anchorage, AKBuilt 1979 · S/N 18503865N4759GSanders Flight Training Center Inc · Jasper, ALS/N 17273341N4759NMitchell Robert L · Presque Isle, MIBuilt 1980 · S/N 18267344N4759QPease Robert J · Anchorage, AKBuilt 1967 · S/N 185-1220N4759XBaginsky D D · Salesville, OHBuilt 1966 · S/N 15064809N475LN475l LLC · Boise, IDS/N 18259396N4760CJaars Inc · Waxhaw, NCS/N U20605805N4760EYoung John L · Glorieta, NMBuilt 1982 · S/N 18268269N4760KWhitton Aviation LLC · Mesa, AZS/N P21000291N4761AAmarel Robert E Jr · Yuba City, CABuilt 1983 · S/N P21000821N4761CForbis Aviation LLC · Calera, OKBuilt 1979 · S/N 21063617N4761DNordstrom Anne D Trustee · Walpole, NHBuilt 1958 · S/N 34861N4761EDorsheimer Ryan J · Camp Hill, PABuilt 1982 · S/N 18268270N4761KLyman Leslie F · Walnut Grove, CABuilt 1979 · S/N P21000292N4761LWings Over Texas Holdings LLC · Denton, TXBuilt 1980 · S/N 15284229N4761QMichaelson Lawrence · Big Lake, AKBuilt 1967 · S/N 185-1226N4761TWorden Frederick F · Tucson, AZBuilt 1981 · S/N R18201755N4762BAllen Kenneth W · Anchorage, AKBuilt 1955 · S/N 31660N4762EFly185 LLC · Estes Park, COBuilt 1979 · S/N 18503868N4762XSpatiumtech LLC · Madison, ALBuilt 1966 · S/N 15064812N4763DRandolph Terrence · Bowie, MDBuilt 1979 · S/N 17272354N4763NBathum Dale · Ketchum, IDS/N 18267346N4763SMayday Flyers LLC · West Jordan, UTBuilt 1979 · S/N R18201419N4763UCopper River Airmotive LLC · Copper Center, AKBuilt 1964 · S/N 18051463N4764BPratt Sean · Hampton, NHBuilt 1977 · S/N 18503371N4764DQuadrelec Engineering Corp · Tulsa, OKBuilt 1979 · S/N 17272355N4764NWhite Robert H · Eagar, AZBuilt 1979 · S/N 18267347N4764QShapiro David · Homer, AKBuilt 1967 · S/N 185-1230N4764URegistered aircraftBuilt 1965 · S/N 18051464N47657Dallam Pat M · Cool, CABuilt 1979 · S/N 17271962N4765QDigger Dougs Crop Dusting Services Inc · Salem, WIBuilt 1976 · S/N 18802513TN4765TWehrman David Hugh · Queen Creek, AZS/N R18201756N4766B4 One Air LLC · Holland, MIBuilt 1979 · S/N 15283624
Back to AD 87-20-03 R2