OpenAirDocs.org
AD 87-20-03 R2

Registered aircraft · 54,015

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.

N7736GKnudson Aviation LLC · Bozeman, MTS/N 17259436N7736KValiair Lc Trustee · Casper, WYBuilt 1979 · S/N P21000420N7736LSimmons David · Fremont, NEBuilt 1976 · S/N 17702603N7736UWatson Marshall · Sublette, KSS/N 17251736N7736XSutton Aircraft Salvage LLC · Palmer, AKBuilt 1960 · S/N 17248236N7737FChapman John · San Antonio, TXBuilt 1966 · S/N 15063837N7737UMast Elroy T · Crawford, MSBuilt 1964 · S/N 17251737N7738GCurioso Enrique Martin · Irvine, CAFirst renewal noticeS/N 17259438N7738UGibson Nathaniel A · Cross Lanes, WVBuilt 1964 · S/N 17251738N7738XSutter William R · Hobart, WAS/N 17248238N7739GFlyguys 172 LLC · Liberty, NCBuilt 1970 · S/N 17259439N773AKKlausler Andrew T · New Market, MNBuilt 1972 · S/N 17260810N773DSHotchkiss Anita E · Cody, WYBuilt 1973 · S/N 18262402N773DWWalerius Dennis · Sylvania, OHBuilt 1976 · S/N U20603202N773PAir Data Solutions LLC · Natchitoches, LABuilt 1964 · S/N U206-0309N773SBQuinn Vita Lyn · Palatka, FLBuilt 1969 · S/N 15070665N773WSPerez Valentino · Sinajana, GUBuilt 1969 · S/N A1500058N7740XAnderson Vance K · Eugene, ORBuilt 1960 · S/N 17248240N7741ATalaheim Air Service LLC · Willow, AKBuilt 1956 · S/N 32638N7741FHatch Donna L · Ballston Spa, NYBuilt 1966 · S/N 15063841N7741GCaviness Dewayne · Chico, CABuilt 1970 · S/N 17259441N7742FKovac Kenneth K · Mer Rouge, LABuilt 1966 · S/N 15063842N7742THelmuth Allen · Powell Butte, ORBuilt 1960 · S/N 47342N7742XMoore John W · Blue Earth, MNS/N 17248242N7743AHarden Harry B · English, INBuilt 1956 · S/N 32640N7743GVaughn Investment Services LLC · New Plymouth, IDS/N 57046N7744FThoren Patrick · Tenino, WABuilt 1966 · S/N 15063844N7744UArnold David L · Portland, ORBuilt 1964 · S/N 17251744N7745GSuperhawk N7745g Owners' Group LLC · Bend, ORBuilt 1970 · S/N 17259445N7745UHodges Charles E · Grain Valley, MOBuilt 1964 · S/N 17251745N7746GMissionaire · Temple, TXBuilt 1974 · S/N 18263328N7746TWilson Steven C · Raleigh, NCBuilt 1960 · S/N 47346N7746XHennings Noran E · Des Moines, WABuilt 1961 · S/N 17248246N7747GKelley Aircraft LLC · Weyers Cave, VABuilt 1970 · S/N 17259447N7747UCoastal Zoom LLC · Davenport, FLBuilt 1964 · S/N 17251747N7748GSchilling Erik D · Cumming, GABuilt 1973 · S/N 15074724N7749APrins Dennis A · South Lake Tahoe, CAS/N 32646N7749KParshall Stephen T · Olympia, WABuilt 1976 · S/N 18052717N7749LDouble Bridges Aviation LLC · Enterprise, ALBuilt 1970 · S/N 17259015N7749UN833tx LLC · Little Rock, ARBuilt 1964 · S/N 17251749N774CSWyo Ventures LLC · Buffalo, WYBuilt 1976 · S/N 21061359N774JA&A Airlines LLC · New Boston, NHBuilt 1974 · S/N 18262887N774MDecker Royce B · Deridder, LABuilt 1977 · S/N 15079345N774MCDe Camargo Marcelo A · Richmond, TXBuilt 1976 · S/N 18264897N774MGPs Aviation Inc · Jackson, MNS/N 17269250N774PDTump Christopher · Hartland, WIBuilt 1968 · S/N 17701281N774RDDemuth Roger C Trustee · Valley View, TXBuilt 1974 · S/N 21060229N7750GVitt Edward J · Sewell, NJBuilt 1970 · S/N 17259450N7750UCoke Hartwell F · Quinton, VABuilt 1964 · S/N 17251750N7750XBurklund Joel H · Minneapolis, MNS/N 17248250
Back to AD 87-20-03 R2