OpenAirDocs.org
AD 87-20-03 R2

Registered aircraft · 54,019

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.

N2692VKlr Aircraft Sales LLC · Wilmington, DES/N 177RG0659N2693DBarron Dillon L · Perry, MOS/N 20845N2693R15 Rides LLC · Manteo, NCBuilt 1967 · S/N 18258393N2693UBolden Myles · Plumas Lake, CABuilt 1963 · S/N 17250293N2694CCranford Billy J · Wasilla, AKBuilt 1971 · S/N 33701378N2694DDagenhart Jason F · Anchor Point, AKBuilt 1952 · S/N 20846N2694QMiller William A Jr · Okeechobee, FLBuilt 1966 · S/N 18257894N2694SMock Joseph R · Huntsville, TXS/N 337-0994N2695DRoss David · Chestertown, MDS/N 20847N2695GBackcountry Guys LLC · Prescott, AZBuilt 1959 · S/N 51995N2695LHindberg Jacob W · Fisher, MNBuilt 1967 · S/N 17255895N2695QKirbco Aviation LLC · Doniphan, MOS/N 18257895N2695RAccardo Paul A · Zwolle, LABuilt 1967 · S/N 18258395N2696CUnited States Air Force · Peterson Afb, COBuilt 1978 · S/N R18200218N2696DWotring Samuel Daniel II · Mount Pleasant, TXBuilt 1952 · S/N 20848N2696LPark Rapids Avionics Inc · Park Rapids, MNBuilt 1967 · S/N 17255896N2696QKlauber Gerald · Lake City, FLBuilt 1966 · S/N 18257896N2696VHall Cody G · Coeur D Alene, IDBuilt 1948 · S/N 18206N2696YD'Anna Michael Joseph · Durango, COBuilt 1962 · S/N 18051196N2697DSalinas Julius T · Esko, MNBuilt 1952 · S/N 20849N2697JSalem Aero Club Inc · Bridgeton, NJBuilt 1966 · S/N 15065697N2697KPrince John C III · Frierson, LABuilt 1979 · S/N 18053038N2697RMaring Matthew D · Westley, CAS/N 18258397N2697UOharra Robert J · Buckley, WAS/N 17250297N2698DGumley Andrew · Wasilla, AKBuilt 1952 · S/N 20850N2698GPeterson Floyd M · Lago Vista, TXBuilt 1959 · S/N 51998N2698JKruglov Stephan · Mundelein, ILBuilt 1966 · S/N 15065698N2698QButler John L · Omak, WABuilt 1966 · S/N 18257898N2698RWeishaupt Louis R · Mackinaw, ILBuilt 1967 · S/N 18258398N2699FRegistration Pending · Jonesboro, ARRegistration pendingBuilt 1966 · S/N 18256799N2699L98x LLC · Caddo Mills, TXBuilt 1967 · S/N 17255899N2699UHogue Richard L · Dos Palos, CAS/N 17250299N2699XAir Controls Billings Inc · Billings, MTBuilt 1966 · S/N P206-0199N269BJN2893e LLC · Reno, NVS/N 17270380N269CJLarson Martin B · Rapid City, SDBuilt 1970 · S/N 17259512N269NEOro LLC · Tilden, NES/N 17272505N269PBHmw LLC · La Grange, NCBuilt 1978 · S/N R18200546N269RDHumphries Aviation LLC · Maysville, KYS/N 17252737N26AWAntique Aircraft And Automobile LLC · Van Alstyne, TXS/N 32544N26BFBasco James Millard M · Richlands, NCS/N 28295N26CARogers Patricia A · Albany, ORBuilt 1979 · S/N 15283794N26CFKustatan Leasing LLC · Nikiski, AKBuilt 1975 · S/N 20700306N26CRSim International Inc · Fort Mill, SCBuilt 1973 · S/N 21060084N26CUAnselmo Jeffery A · Fairfield, CABuilt 1986 · S/N U20606984N26CWBarzelatto Brett · Thornton, COS/N 17272496N26DLHayden David Bernard Trustee · Roach, MOBuilt 1973 · S/N 18502287N26EFMischel Herbert · Las Vegas, NVS/N 15282800N26FCRwr Air Inc · Tok, AKBuilt 1974 · S/N U20602541N26FPTate Zachary W · Cypress, TXBuilt 1978 · S/N 17271318N26GRLakeside Capital Holdings LLC · Green Cove Springs, FLBuilt 1980 · S/N 18267661
Back to AD 87-20-03 R2