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.

N4302ULarson Gary L · Elgin, TXBuilt 1964 · S/N 15060302N4303BWetherbee Michael · Howell, MIBuilt 1955 · S/N 26647N4303LArtic'S Air Academy LLC · Palmer, AKBuilt 1966 · S/N 17254372N4303QHobart Aviation Inc · Akron, OHBuilt 1971 · S/N 17260203N4303SCartersfly LLC · Lewes, DES/N 18257541N4303USherbak Michael J II · St Helena Is, SCBuilt 1963 · S/N 15060303N4304QProfessional Aviation Inc · Dalton, GAS/N 17260204N4304RMoore Robby J · Salem, ORBuilt 1978 · S/N R18200587N4304UStoller Aircraft Rentals LLC · Sharpsburg, GAS/N 15060304N4305LLavin Renaye K · Wasilla, AKS/N 17254374N4306LGrandinetti Robert L · Fayetteville, NYS/N 17254375N4306NWesner Robert F · El Reno, OKBuilt 1948 · S/N 7104N4307RMcmath Don · Collinsville, OKBuilt 1974 · S/N 17263060N4308BLyons Milo J · Sequim, WABuilt 1955 · S/N 26652N4308LKim Jingu · Mount Prospect, ILBuilt 1966 · S/N 17254377N4308QN4038q LLC · Merritt Island, FLBuilt 1971 · S/N 17260208N4308UWildcat Aviation LLC · Schoolcraft, MIBuilt 1964 · S/N 15060308N4308ZMike Victor Yankee LLC · Andover, MABuilt 1983 · S/N T30300183N4309LWallace Leroy C · Wshngtn Ct Hs, OHBuilt 1966 · S/N 17254378N4309QCamp Harold S Jr · Bossier City, LABuilt 1971 · S/N 17260209N4309RWest Atlantic Transportation Corp · Mount Pleasant, NCBuilt 1976 · S/N 18502928N430DBIkard James C · Shelbyville, TNBuilt 1979 · S/N R18201386N430FSCustom Air International LLC · Homestead, FLBuilt 1978 · S/N 17271355N430KUlve Scott David · Camdenton, MOBuilt 1979 · S/N 18267209N430MState Of Louisiana · Baton Rouge, LAS/N 18268250N430RPSale Reported · Billings, MTSale reportedBuilt 1976 · S/N 18503244N4310BMaly Burr J · Anchorage, AKBuilt 1955 · S/N 26654N4310LMckenzie Donovan G · East Northport, NYBuilt 1966 · S/N 17254379N4310NMilton William H · Amsterdam, NYBuilt 1948 · S/N 7100N4310QRonceverte Fliers Incorporated · Asbury, WVBuilt 1971 · S/N 17260210N4310USport Wings Enterprises LLC · Pasadena, TXBuilt 1964 · S/N 15060310N4310VRobertson Nathan M · Acworth, GABuilt 1948 · S/N 7217N4311BPohl Jeffrey A · Milaca, MNBuilt 1955 · S/N 26655N4311LRockin Robin Aviation LLC · Natchez, MSS/N 17254380N4311NSchafhausen Mark G · Spokane, WABuilt 1948 · S/N 7099N4311QLink John · West Milford, NJBuilt 1971 · S/N 17260211N4311UMoreland Wesley M · Mckinney, TXBuilt 1965 · S/N 337-0093N4312NBarron John L · Perry, MOBuilt 1948 · S/N 7098N4312RHorizon Group Inc Trustee · Boca Raton, FLBuilt 1974 · S/N 17263065N4312UDudley Benjamin H · Wasilla, AKS/N 15060312N4313RStauffer Kurt A · Belleville, PABuilt 1974 · S/N 17263066N4314QRafinski Marcus · San Juan, PRBuilt 1971 · S/N 17260214N4315BMckamey Dave S · Sonora, CABuilt 1955 · S/N 26659N4315LBeedle Jeremiah J H · Juneau, AKS/N 17254384N4315QCentral Arkansas Flying Club Inc · Bryant, ARBuilt 1971 · S/N 17260215N4315RDuffys Aircraft Sales And Leasng Inc · Neillsville, WIBuilt 1974 · S/N 17263068N4315UYoung Margaret J · Peck, IDBuilt 1964 · S/N 15060315N4316BAnderson Gregory P · Meadow Vista, CABuilt 1955 · S/N 26660N4316RMarston Charles T · New Bern, NCBuilt 1974 · S/N 17263069N4317QPerera Nandana L · Logan, OHBuilt 1971 · S/N 17260217
Back to AD 87-20-03 R2