OpenAirDocs.org
AD 87-20-03 R2

Registered aircraft · 54,016

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.

N10452Demott Steven J · Stanley, WIBuilt 1973 · S/N 15074864N10454Ratliff Byron L · Paragould, ARBuilt 1973 · S/N 15074865N10455Cowden Ryan A · Everson, WABuilt 1973 · S/N 15074866N10459Ender Richard M · Rye, NHBuilt 1973 · S/N 15074868N10466Richards Matthew · Southaven, MSS/N 15074870N1046VSusitna Air Service LLC · Anchorage, AKBuilt 1974 · S/N U20602418N10473Vincent Geoffrey M · Andover, KSBuilt 1973 · S/N 15074873N10474Some Beech LLC · Bolivar, MOBuilt 1973 · S/N 15074874N10478Van Winkle Nicolas A · Renton, WABuilt 1973 · S/N 15074877N1047FBondurant Jok · Talkeetna, AKS/N 18502704N10483Tennant Michael D · Granite Falls, WAS/N 15074881N10487Wonderboy Aviation LLC · Hollsopple, PABuilt 1973 · S/N 15074885N10488Heller John S Sr · Jackson, WIBuilt 1973 · S/N 15074886N10495Pacific Electro Mechanical Inc · Pearl City, HIBuilt 1973 · S/N 15074888N10498Scoma Steven G · Rhome, TXS/N 15074890N104AFNance David B · Quinton, VABuilt 1967 · S/N 17700238N104BU1984k LLC · Gypsum, COS/N 18254352N104BWJurak Mike D · Kimberly, IDBuilt 1974 · S/N 18502517N104DEVince John G · West Ossipee, NHBuilt 1980 · S/N 18504009N104FDDippolito Michael M · Norristown, PABuilt 1968 · S/N 15068727N104HEDixie Sand And Gravel LLC · Edisto Island, SCBuilt 1975 · S/N 18502742N104HSErdmann Hollis K · Santa Monica, CABuilt 1973 · S/N 182-61758N104JSSmith Timothy A · Shafter, CABuilt 1977 · S/N 18265625N104JVPryor Michael C · Riverview, FLBuilt 1967 · S/N 15066392N104KJb Aircraft LLC · Anchorage, AKBuilt 1969 · S/N 20700122N104KMMorrison Mitchell A · Forest, VABuilt 1970 · S/N 15072415N104NPDv Aviation Inc · Brainerd, MNBuilt 1975 · S/N 17265021N104NRMiller Dale D · Eagle River, AKBuilt 1966 · S/N 18051693N104PSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1975 · S/N 182-63801N104PDBaumann James R · Muskogee, OKBuilt 1973 · S/N 17261428N104PMPats Offroad Inc · Mitchell, SDS/N 18258085N104RCChan Ronald G · Anchorage, AKBuilt 1966 · S/N 1851098N104SKAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1969 · S/N 15071907N104SPJanaitis Aviation LLC · Middletown, DEBuilt 1973 · S/N 18261667N104TRAuburn Sheet Metal Inc · Enumclaw, WABuilt 1976 · S/N 18503212N104UCAspiring Aviators Aero Club · Winter Haven, FLS/N 15284673N104WDHill Keith D · Kirby, ORBuilt 1979 · S/N P21000366N10505Metro Flyers LLC · Paducah, KYBuilt 1973 · S/N 15074894N10507Pch Aviation LLC · Elmhurst, ILBuilt 1973 · S/N 15074896N10509Mckenna Andrew J Sr · Waynesville, OHBuilt 1973 · S/N 15074897N1050CCourser Ezra D · Columbiaville, MIBuilt 1973 · S/N 15074893N1050FBuchan John F · Port Ludlow, WABuilt 1975 · S/N 18502707N1050VState Of Wisconsin · Madison, WIBuilt 1968 · S/N 18051966N10518Post Ryan · Carmichaels, PAS/N 15074900N1051VSackett Ryan W · Anchorage, AKBuilt 1974 · S/N U20602421N10524Putrakul Kobkit · London, KYS/N 15074902N1052FGlb Farms Inc · Pasco, WABuilt 1975 · S/N 18502709N1052MFendt Alan D Trustee · Dexter, MIBuilt 1975 · S/N 18264216N1053DFisher Evan G · Fort Worth, TXBuilt 1951 · S/N 7665N10548Scootair LLC · Alburgh, VTBuilt 1973 · S/N 15074908
Back to AD 87-20-03 R2