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.

N29595Delta Fox Corp · Schaumburg, ILBuilt 1968 · S/N 17700980N29596Murray Charles W · Reno, NVBuilt 1968 · S/N 17700981N2959DWatson Frank H · Central Point, ORBuilt 1955 · S/N 26902N2959JJones Eugene B Jr · Pflugerville, TXBuilt 1966 · S/N 15065759N2959SCobb Patricia J Trustee · North Las Vegas, NVS/N 15066859N2959XCiochetti David · Kimberly, ORBuilt 1967 · S/N 17700359N295APTupelo Aeronautics Inc · Tupelo, MSS/N 7836N295FAStationair Amphib LLC · Jefferson City, MOBuilt 1980 · S/N U20605482N295GTMedina-Solla Edwin O · Carolina, PRBuilt 1966 · S/N 18257799N295THHowser Anthony J · Batavia, OHS/N 15072736N2960AGallman Alexander C · Livingston, TXBuilt 1953 · S/N 30160N2960JGlinsky Edward Jr · Rhome, TXBuilt 1966 · S/N 15065760N2960SDewitt Daniel · Camarillo, CABuilt 1967 · S/N 15066860N2960UMedford Mark A · Mantua, OHBuilt 1963 · S/N 17250560N29617Abbott Barry · Tempe, AZS/N 17700994N29619Loudenslager Donald F · Collinsville, OKBuilt 1968 · S/N 17700996N2961AMerrill Richard C · Chuckey, TNBuilt 1953 · S/N 30161N2961DWilliwaw Ventures LLC · Anchorage, AKBuilt 1955 · S/N 26904N2961FNilssen Carl J · Cameron, WIBuilt 1966 · S/N 18257061N2961JFrey Jerry P · Fallon, NVBuilt 1979 · S/N T18803581TN2961SInternational Air Services Inc Trustee · Carson City, NVBuilt 1967 · S/N 15066861N2961XLaurina Peter · Knoxville, TNBuilt 1967 · S/N 17700361N2961YGarcia Kale B · Covington, WABuilt 1962 · S/N 18253961N29625Sale Reported · Fort Myers, FLSale reportedBuilt 1968 · S/N 17700998N2962AKapsner Mark W · Willow, AKBuilt 1953 · S/N 30162N2962DBlanchard Stephanie T · Seldovia, AKS/N 26905N2962EPaulisue Aviation LLC · East Saint Louis, ILBuilt 1978 · S/N 17271388N2962FMcclevey Landon Kole · Dilley, TXBuilt 1966 · S/N 18257062N2962XRomine John M · Broken Arrow, OKBuilt 1967 · S/N 17700362N29631Registered aircraftBuilt 1973 · S/N 21059873N2963CMcmillian Tommy D · Wasilla, AKBuilt 1954 · S/N 30863N2963FConnell Gary A · Anchorage, AKS/N 18257063N2963SDougherty Paul · Bethel, PABuilt 1967 · S/N 15066863N2963XWayner Ronald P · Sutton, AKBuilt 1967 · S/N 17700363N2963YMoretti Larry · Monroe, MIBuilt 1962 · S/N 18253963N29643Campbell Robert A · Dayton, TXS/N 17701005N29645Borgman Dale A · Rescue, CABuilt 1968 · S/N 17701006N2964FHunt Stuart J · Lynn Haven, FLBuilt 1966 · S/N 18257064N2964SRichardson David M · Dwight, ILBuilt 1967 · S/N 15066864N2964VPlane Awesome LLC · Plymouth, MAS/N 15076335N2964YVanderwel Paul · Woodinville, WABuilt 1962 · S/N 18253964N29651Geurs John Z · Ossian, INBuilt 1968 · S/N 17701009N2965CBauer Joachim · Rhome, TXFirst renewal noticeBuilt 1954 · S/N 30865N2965FFrank Paul R · Waukesha, WIBuilt 1966 · S/N 18257065N2965UPatterson John R · Leeds, ALBuilt 1963 · S/N 17250565N2965XLynch Thomas L · Fort Collins, COBuilt 1967 · S/N 17700365N29664Tyree William B · Arlington, TXBuilt 1974 · S/N 17264119N29667Viles Timothy · Bartlett, TNBuilt 1968 · S/N 17701016N2966ACroffut David P · Anchorage, AKBuilt 1953 · S/N 30166N2966DTruman Michael · Warner Robins, GABuilt 1955 · S/N 26909
Back to AD 87-20-03 R2