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.

N758QCMccray B F Jr · Manchester, OKBuilt 1979 · S/N R1723267N758QEThomason Land Co · Garden City, TXBuilt 1979 · S/N R1723269N758QNCessna 172xp LLC · Wilmington, DES/N R1723277N758QPBarbee Donald L · Columbus, OHBuilt 1979 · S/N R1723278N758QVMidwest Aviation Inc · Mayfield, KYBuilt 1979 · S/N R1723284N758QX4-Gs Holding Co LLC · Cashmere, WABuilt 1979 · S/N R1723286N758QYRegistration Pending · Arlington, TXRegistration pendingBuilt 1979 · S/N R1723287N758QZDovy Aviation LLC · Houston, TXBuilt 1979 · S/N R1723288N758RCMattern Todd A · Yuma, AZBuilt 1979 · S/N R1723291N758RJWilliams Steven M · Cazenovia, NYBuilt 1979 · S/N R1723297N758RLRegistered aircraftBuilt 1979 · S/N R1723299N758RNDavis Evan · Haddonfield, NJBuilt 1979 · S/N R1723301N758RSStewart Jon L · Walker, MNBuilt 1979 · S/N R1723305N758RVLejeune Thad · Eunice, LABuilt 1979 · S/N R1723308N758RXBuss Rhonda K · Hustisford, WIS/N R1723310N758SFBauer Walter G · Neenah, WIS/N R1723318N758SYMasser Management Inc · Leck Kill, PABuilt 1980 · S/N R1723335N758TAStonehouse William L · Clovis, CABuilt 1980 · S/N R1723337N758TJSilverstein Bradley · Derby, KSBuilt 1980 · S/N R1723345N758TKBookout Samantha · Louisville, MSBuilt 1980 · S/N R1723346N758TNStevenson Aviation LLC · Harrisville, UTBuilt 1980 · S/N R1723349N758TSNiemiec Luke · Assonet, MABuilt 1980 · S/N R1723353N758TTLawson Paul L · Vancouver, WABuilt 1980 · S/N R1723354N758TVReeder Flying Service Inc · Twin Falls, IDBuilt 1980 · S/N R1723356N758TXMehn Michael J · Berlin, WIBuilt 1980 · S/N R1723357N758TY5 Star Farms · Johnson, KSS/N R1723358N758UCL&S Adventure LLC · Rocklin, CAS/N R1723362N758UHKobesky Jeffrey · Dunkirk, MDBuilt 1980 · S/N R1723367N758VPHorn Jon S · Phoenix, AZBuilt 1980 · S/N R1723397N758VSWieden Air LLC · Owasso, OKBuilt 1980 · S/N R1723400N758VUParlet Brian C · Banning, CABuilt 1980 · S/N R1723402N758VWSimon Ilene F · San Mateo, CABuilt 1980 · S/N R1723404N758WBFinity Engineering LLC · College Place, WABuilt 1980 · S/N R17203409N758XBLet The Fur Fly · Payson, AZBuilt 1981 · S/N R1723431N758XSG & A LLC · Eagle River, AKBuilt 1981 · S/N R1723446N758XWNorton Donald A · Kodiak, AKFirst renewal noticeS/N R1723450N758XZSpinde Martin R · Anchorage, AKS/N R1723453N758YSFly Sky Ads LLC · Manalapan, NJBuilt 1982 · S/N A1521017N758YTMountain Air Flying LLC · Brigham City, UTBuilt 1982 · S/N A1521018N75904Worley Dan L · Heber Springs, ARS/N 17268028N75907Rmb Leasing Inc · Dover, DEBuilt 1976 · S/N 17268031N75909Martin Michael J · Anchorage, AKS/N 17268033N7590MLucci Giacinto A Jr · Nashville, MIBuilt 1959 · S/N 55890N7590NIventosch Leonard · Mccall, IDBuilt 1977 · S/N U20603694N7590SMoody Gene M · Kingsport, TNBuilt 1976 · S/N 18265239N7590TDauteuil Rodney A · Salem, NHBuilt 1959 · S/N 47190N7590UWilson Bobby L · Murray, KYS/N 15077757N75917Abs Aviation · Lanham, MDBuilt 1976 · S/N 17268040N7591GRochez Gerald A · Jensen Beach, FLBuilt 1970 · S/N 17259291N7591NJones Michael D · Southern Pines, NCBuilt 1979 · S/N 21063240
Back to AD 87-20-03 R2