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.

N4381RDugan James M · North Bend, OHS/N 17263131N4382BBoyd Delbert L · Oroville, CABuilt 1955 · S/N 26726N4382LFielding Gregory J · Holland, MABuilt 1966 · S/N 17254461N4382QLegends Air LLC · Wilmington, DES/N 17260282N4382RMoranski Joseph F · Budd Lake, NJBuilt 1974 · S/N 17263132N4383LHasman Robert B · Flushing, MIS/N 17254462N4383QBladen Aviation Inc · Elizabethtown, NCBuilt 1971 · S/N 17260283N4383VPorter Charles R · Ocala, FLBuilt 1949 · S/N 7305N4384BMead Aviation LLC · Missoula, MTBuilt 1955 · S/N 26728N4384KLewis Flying Service Inc · Morse, LABuilt 1967 · S/N 18051827N4384QMorten John E · Larimore, NDBuilt 1971 · S/N 17260284N4384RAmerican Patrols Inc · Midland, TXBuilt 1974 · S/N 17263134N4384UMarkey William C · Wenatchee, WAFirst renewal noticeS/N 15060384N4384VBennett Robert M · Felton, DEBuilt 1949 · S/N 7306N4385BDorris Michael R · Mccall, IDBuilt 1956 · S/N 26729N4385NVyfvinkel Frederick J · New Smyrna Beach, FLBuilt 1947 · S/N 7019N4385QKulis Richard W · Gill, MABuilt 1971 · S/N 17260285N4385RAnderson Kenneth J · Norman, OKBuilt 1974 · S/N 17263135N43860Friends Of Army Aviation · Ozark, ALS/N R172-0124N4386RFlying H LLC · Lake Placid, FLBuilt 1974 · S/N 17263136N4386VAlerion Aviation LLC · Elbert, COBuilt 1949 · S/N 7308N4387BN4387b LLC · Sheridan, ARBuilt 1955 · S/N 26731N4387QCrose Merrill L · Sibley, MOBuilt 1971 · S/N 17260287N4387UR&M Steel Co Inc · Caldwell, IDBuilt 1964 · S/N 15060387N4388BHanke Lowell E · Deerbrook, WIBuilt 1955 · S/N 26732N4388RSunrise Aviation Inc · Ormond Beach, FLBuilt 1974 · S/N 17263138N4388VPhilbrick Rodney C · Bishop, CABuilt 1949 · S/N 7310N4389BVogel Max R · Havre, MTBuilt 1955 · S/N 26733N4389LOdell John J · Salinas, CABuilt 1966 · S/N 17254470N4389QMellinger Jason C · North Pole, AKS/N 17260289N4390LAero Science International LLC · Martinez, GABuilt 1966 · S/N 17254471N4390QFlying Mermaid LLC · Aiea, HIBuilt 1971 · S/N 17260290N4390RBrown David R · Kent, WABuilt 1974 · S/N 17263140N4390VNamtvedt Erik · Wasilla, AKBuilt 1956 · S/N 28741N4391LVeness Matthew B Trustee · Fairborn, OHBuilt 1966 · S/N 17254472N4391NRoy Rodney E · Grand Marais, MNBuilt 1947 · S/N 7030N4391QSpringville Flying Club · Spanish Fork, UTBuilt 1971 · S/N 17260291N4391RCheek Kenneth W · Yadkinville, NCBuilt 1974 · S/N 17263141N4392BBrooks Todd A · Vacaville, CAFirst renewal noticeBuilt 1955 · S/N 26736N4392QRose Denver W · Eubank, KYBuilt 1971 · S/N 17260292N4392VKeith Harry E III · Coffeyville, KSFirst renewal noticeBuilt 1949 · S/N 7343N4393BMiller Zachary · Anchorage, AKS/N 26737N4393QJkj Aviation LLC · Wilmington, NCBuilt 1971 · S/N 17260293N4393RHorizon Dreams LLC · Homer, GABuilt 1974 · S/N 17263143N4393URoberts Alan W · Emmetsburg, IABuilt 1964 · S/N 15060393N4394LR A Marsh Flying Club LLC · Williamson, GABuilt 1966 · S/N 17254475N4394NEnnis Shannon E · Chesapeake, VABuilt 1947 · S/N 7011N4394QAircraft Resource Center Inc · Lakeville, MNBuilt 1971 · S/N 17260294N4394URawdon Robert C Jr · Hohenwald, TNBuilt 1964 · S/N 15060394N4395UMhaskar Advait S · Burlington, IABuilt 1964 · S/N 15060395
Back to AD 87-20-03 R2