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.

N3518YMcaninch Shawn R · Albia, IAFirst renewal noticeBuilt 1962 · S/N 18254418N35191West Monte D · Coldspring, TXBuilt 1975 · S/N 17702255N35192Huffman Robert V · Washington, DCBuilt 1975 · S/N 17702256N35193Mccormack Duncan M · Sunfield, MIS/N 17702257N35196Courtney Marshall Duchesne · Mission Hills, CABuilt 1975 · S/N 17702260N35199Global Aerials Inc · Pembroke Pines, FLBuilt 1975 · S/N 17702261N3519DLebold Mary Ann · Hubbard, ORBuilt 1955 · S/N 27062N3519VVanderpool Kenneth J · Portsmouth, NHBuilt 1974 · S/N 15076533N3519YWeber Larry F · New Paltz, NYBuilt 1962 · S/N 18254419N351GPSelby Chris A · Monticello, ARBuilt 1968 · S/N 17256918N351JKeltz Bennie J · Hillsdale, INBuilt 1968 · S/N 188-0468N35203Sky Views Aviation LLC · Red Lodge, MTBuilt 1975 · S/N 17702263N35205Riley John Roland · Ouray, COBuilt 1976 · S/N 177RG1046N3520CWallingford David P · Kenai, AKBuilt 1954 · S/N 26563N3520FWood Forrest B · Cookson, OKBuilt 1966 · S/N 18257520N3520JHart Robert J · Clarksville, MDBuilt 1965 · S/N 15061220N3520LGregory Austin · Bothell, WABuilt 1965 · S/N 15062320N3520SBrosnan James M · Staten Island, NYBuilt 1963 · S/N 17250720N3520USchioppo Joseph · Boynton Beach, FLBuilt 1963 · S/N 18254920N3520VHarrell Erick C · Sedona, AZBuilt 1977 · S/N R1722256N35211Ballester Alexis R · Mayaguez, PRBuilt 1975 · S/N 17702267N35213Aviation Adventure LLC · Munster, INBuilt 1975 · S/N 17702268N35216Dairy Air Inc · Wyoming, PABuilt 1976 · S/N 177RG1047N35218Chessare Gary M · Caledonia, ILBuilt 1975 · S/N 17702270N35219Nelson Laurel L · Renton, WABuilt 1975 · S/N 17702271N3521JGoldbeck Kenneth J · Moreland, GABuilt 1965 · S/N 15061221N3521LBiorn Howard L · Brooklyn Center, MNS/N 15062321N3521YSportsman Airpark Inc · Newberg, ORS/N 18254421N35220Spoor John B Jr · Sandwich, ILBuilt 1975 · S/N 17702272N35225Nguyen Ricky L · Honolulu, HIS/N 17702275N3522DWaiwood Michael F · Strongsville, OHS/N 27065N3522EKilgore William B · Eureka, CAS/N 17271572N3522JMontgomery Robert L · Port Angeles, WABuilt 1965 · S/N 15061222N3522LTyler Clark D · Fort Wayne, INS/N 15062322N3522QRamirez Jose Marcos · Casa Grande, AZBuilt 1973 · S/N 17261661N3522UDfs · Bountiful, UTBuilt 1963 · S/N 18254922N3522YBohlen Thomas R · Hudson, WIBuilt 1962 · S/N 18254422N35231Dressler David S · Bend, ORBuilt 1976 · S/N 177RG1048N35238Williams E E · Atlanta, GABuilt 1975 · S/N 17702283N3523CRinio Tyson S · Ester, AKBuilt 1954 · S/N 26566N3523QRed Crest Aviation LLC · Columbus, OHBuilt 1975 · S/N 17702278N3523UCharlson Aaron H Jr · Forest City, IABuilt 1963 · S/N 18254923N35242Dlss Inc · Caro, MIBuilt 1975 · S/N 17702286N35244Richardson Barry T · Butler, TNBuilt 1975 · S/N 17702288N35247Dwyer John R · Orange Park, FLBuilt 1975 · S/N 17702289N3524JRobinson Jimmy T · Cohutta, GABuilt 1965 · S/N 15061224N3524SFagersten Richard B · Sparta, NJBuilt 1963 · S/N 17250724N3524UHudson George R · Hueytown, ALBuilt 1963 · S/N 18254924N35259Gately Brian P · Brooklyn, NYBuilt 1975 · S/N 17702293N3525CBrann Paul A · West Gardiner, MES/N 26568
Back to AD 87-20-03 R2