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.

N20965Reich Aviation LLC · Loudon, TNBuilt 1974 · S/N 17263883N20966Gibson Todd W · Madisonville, LABuilt 1972 · S/N 18261327N20969Kembel Robert D · Saint Ignatius, MTBuilt 1976 · S/N 18503049N2096RBeasley Tim · Summerland Key, FLBuilt 1964 · S/N 18255296N2096ZHammons Clayton W · Salome, AZBuilt 1963 · S/N 15059896N20970Hitt James Randy · Blue Springs, MSBuilt 1972 · S/N 18261330N20972Esmiol Matthew · Marlborough, CTBuilt 1972 · S/N 18261331N20975American Union Printing Inc · Chino Valley, AZBuilt 1972 · S/N 18261333N20976Kwolik Jordan M · Mckinney, TXBuilt 1972 · S/N 18261334N20978Crosswinds Flying Club Inc · Oakland, MIBuilt 1972 · S/N 18261336N2097RWilson Wayne D · Saratoga Springs, NYBuilt 1964 · S/N 18255297N2097XSouth Carolina Forestry Commission · Columbia, SCBuilt 1965 · S/N 18256197N2097YWulff Jonathan P · Eaton Rapids, MIBuilt 1962 · S/N 17249597N2097ZSchieferecke Jeanine · Topeka, KSBuilt 1963 · S/N 15059897N20980White Duane A · Wappingers Falls, NYBuilt 1972 · S/N 18261337N20986Skylane Flying Club Inc · Omaha, NEBuilt 1972 · S/N 18261342N2098XKuefler Michael J · Saint Ignatius, MTBuilt 1965 · S/N 18256198N2098YLevel Altitude LLC · Seward, NEBuilt 1962 · S/N 17249598N20997Aerowood Aviation LLC · Monroe, NCBuilt 1964 · S/N 17251217N2099GHilten Robert W · Columbus, MTBuilt 1958 · S/N 51399N2099QTice William · Lancaster, MABuilt 1974 · S/N 177RG0499N2099XGreen Glen A · Willits, CABuilt 1965 · S/N 18256199N209DPBke Air LLC · Newnan, GABuilt 1977 · S/N 17270158N209HVAnderson Scott · Salem, ORBuilt 1979 · S/N 17272302N209KSSchneider Kerry · Alpine, WYS/N P21000560N209LJCat Agri Aviation Inc · Walnut Ridge, ARS/N 36334N209TOnele Dennis E · Central City, NES/N 15068531N20AAGrand River Aviation LLC · Kremmling, COBuilt 1968 · S/N 17256596N20AVRocco Leroy · Ceresco, MIBuilt 1976 · S/N 177RG-0888N20AXHehmann Richard J · Belleville, ILS/N 177RG1160N20BRYork Stanley A · Leetonia, OHBuilt 1955 · S/N 31563N20CNuxoll Randy G · Eagle, IDS/N P3370145N20CFFried Stephen · Plymouth, MAS/N 26217N20CHRegistered aircraftBuilt 1974 · S/N 18263453N20CTN20ctid LLC · Pocatello, IDBuilt 1978 · S/N 152-81952N20CUCosta Flying Service Inc · Painted Post, NYBuilt 1980 · S/N 172RG0323N20DEEbright Sean E · Hasty, COS/N 51334N20DKFlight Surgeon LLC · Fayetteville, ARBuilt 1976 · S/N 17266836N20FCLge Flying Club Inc · Marietta, GABuilt 1970 · S/N 18260314N20HBMontana Sky Aircraft LLC · Kalispell, MTS/N 18262945N20HLCs&P Rocky Mountain Inc · Cypress, TXS/N 21061877N20HTRed Arrow Aviation LLC · Santa Teresa, NMBuilt 1969 · S/N 17258306N20JSOyaski Michael F · Ebensburg, PABuilt 1975 · S/N 18263751N20MUOracle Aviation LLC · Omaha, NEBuilt 1978 · S/N 17271496N20RHStoltzfus John F Jr · Strasburg, PAS/N 172-68331N20RSStendal Russell M · Hollywood, FLBuilt 1970 · S/N 18501826N20WGBingham James H · Dillingham, AKS/N 33734N20WMMcdonald John P · Kennewick, WAFirst renewal noticeBuilt 1973 · S/N 17261658N21000Yunger John C · Newton, WIBuilt 1972 · S/N 18261346N21001Global Acquisitions Ltd · Davenport, IAS/N 18261347
Back to AD 87-20-03 R2