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.

N93024Ward Air Inc · Juneau, AKS/N U20604392N93025Kiesel Edward K · Juneau, AKBuilt 1976 · S/N 18503163N93027Indy Air LLC · Blaine, MNBuilt 1976 · S/N 18503164N93030Cathey Wacey D · Polson, MTBuilt 1976 · S/N 18503165N93033Kaval John P Jr · Duxbury, MABuilt 1976 · S/N 18503166N93035Des Aircraft LLC · Marianna, ARBuilt 1974 · S/N 21060232N93039Dorris Michael R · Mccall, IDBuilt 1977 · S/N 18503169N9303AYaw David Oderkirk Trustee · El Dorado Hills, CABuilt 1949 · S/N 7382N9303GBenson Steve J · Keenesburg, COBuilt 1971 · S/N 18260843N9303RCanoe Bay Outfitters LLC · Chugiak, AKBuilt 1984 · S/N U20606829N9303TBaxter Patrick L · Frisco, COS/N 50803N9303UWestover Scott A · Anchorage, AKBuilt 1976 · S/N 15078253N9303XHawaiian Airlift Company Llp · Kihei, HIS/N 18268479N9304HWischmeyer Matthew R · Hopewell Junction, NYBuilt 1975 · S/N 17266078N9304RShah Zahid · Santa Paula, CAS/N U20606830N93050Wilson Thomas Henry III · Anchorage, AKBuilt 1976 · S/N 18503172N93052Pfm 2025 LLC · Lake Forest, ILBuilt 1974 · S/N 21060244N93055Moore Joshua M · North Pole, AKBuilt 1977 · S/N 18503173N9305BStar Aero LLC · Santa Teresa, NMBuilt 1958 · S/N 55105N9305CLinn Michael A · Nisswa, MNBuilt 1955 · S/N 31703N9306CKoehrer Ernie · Palmer, AKBuilt 1955 · S/N 31704N9306GPaiva Rafael R · College Station, TXBuilt 1971 · S/N 18260846N9306HAnycomm Corp · Gold River, CABuilt 1975 · S/N 17266079N93078Black Cat Aviation LLC · Centennial, COBuilt 1981 · S/N 15285391N9307CJrs Buena Vida LLC · College Station, TXBuilt 1955 · S/N 31705N9307DAviatzone LLC · Fort Lauderdale, FLBuilt 1982 · S/N 172RG1114N9307GSchwaderer Delbert L · Stevensville, MTBuilt 1971 · S/N 18260847N9307HMoss Jon · Gridley, CABuilt 1981 · S/N 182-67929N9307YRader Drew · Avon, COBuilt 1981 · S/N 21064467N93082Schweiger Nathaniel A · Richland, WABuilt 1981 · S/N 15285394N93085Hoffsette Dianna L Trustee · Saint Catharine, MOBuilt 1981 · S/N 15285396N9308BKorn Antony · Chehalis, WABuilt 1958 · S/N 55108N9308CCameron Thomas J · Stanchfield, MNBuilt 1955 · S/N 31706N9308GBoilermaker-Warrior Express LLC · Grosse Pointe, MIBuilt 1971 · S/N 18260848N9308X5p&P LLC · Glenwood Springs, COBuilt 1961 · S/N 18253708N93096Ngumba Andrew N · Long Beach, CABuilt 1981 · S/N 15285399N93098Faeo John D · Wasilla, AKBuilt 1976 · S/N 18503179N9309GHagle Terry A · Niceville, FLBuilt 1971 · S/N 18260849N9309XRigsby R W · Salisbury, NCBuilt 1961 · S/N 18253709N9309YYecny Alan K · San Luis Obispo, CABuilt 1981 · S/N 21064469N930ASA2g International LLC · San Juan Capo, CABuilt 1976 · S/N 33701854N930GGelazin Paul J · Palm Harbor, FLBuilt 1977 · S/N 21061866N930JSDolphin Air LLC · Fairbanks, AKBuilt 1975 · S/N 15076752N930LFWanner Robin L · Lufkin, TXBuilt 1966 · S/N 21058766N9310BThrom Donald R · Parachute, COBuilt 1958 · S/N 55110N9310DRegistered aircraftBuilt 1982 · S/N 172RG1116N9310GBaldwin James C · Fruita, COBuilt 1971 · S/N 18260850N9310HLilienthal Donald W · Cyrus, MNBuilt 1975 · S/N 17266080N93112Strack Air LLC · Yorba Linda, CABuilt 1974 · S/N 21060267N93116Wichita Area Technical College · Wichita, KSBuilt 1981 · S/N 15285405
Back to AD 87-20-03 R2