OpenAirDocs.org
AD 86-13-04 R3

Registered aircraft · 18,495

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:86-13-04-R3')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3')
  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.

N9355RSkyline Aviation LLC · Lewistown, MTBuilt 1975 · S/N 18802254TN93563Mdn Industries · Forsyth, MTBuilt 1973 · S/N 73-30597N9356YParsons Bruce W Trustee · Costa Mesa, CABuilt 1981 · S/N 21064483N9357KCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1982 · S/N 18803937TN93586Malacara Erasmo F · Edinburg, TXBuilt 1973 · S/N 73-30612N9358NHarvey Kandace A · Snohomish, WABuilt 1981 · S/N 18504339N93591Pischl John · Yorkville, ILBuilt 1973 · S/N 73-30593N935CDRussell Ronald W · Auburn, ALBuilt 2003 · S/N 0454N93619Bradberry Charles G · Iowa Park, TXBuilt 1973 · S/N 74-30644N9361Q61q LLC · Brookfield, WIBuilt 1971 · S/N CE-359N93622Dionne Jason · Madison, SDS/N 73-30582N93623Lausevic Daniel · Rancho Cordova, CABuilt 1974 · S/N 74-30718N93625Stewart Richard Lynn · Birmingham, ALBuilt 1973 · S/N 73-30570N93626Ham Erol M Jr · Augusta, GABuilt 1973 · S/N 74-30618N9363QPearson James Clyde · Lake Junaluska, NCS/N CE-360N93671Dorrance John Christian · Washington, DCS/N 74-30677N93675Rose Gary A · Brighton, TNBuilt 1974 · S/N 74-30706N93698Shealey Burnet D Jr · Landrum, SCBuilt 1974 · S/N 74-30689N9369YBk Aviation Services LLC · Yorba Linda, CABuilt 1981 · S/N 21064488N936ACBiggs Aircraft East LLC · Deland, FLBuilt 1971 · S/N CE-336N936DWTreeline Aviation LLC · Grimes, IABuilt 2003 · S/N 40070N936GCampbell Merle W · Ponte Vedra, FLBuilt 2007 · S/N E-3816N936HBRubyco Inc Trustee · Wilmington, DEBuilt 2010 · S/N E-3937N936JBHunt Air LLC · Anderson, SCBuilt 1977 · S/N 340A0263N936KCLive Right Travel LLC · Pagosa Springs, COBuilt 2001 · S/N 0068N936MKanig Stephen · Albuquerque, NMS/N 93-301019N936SIrving Holdings LLC · Greensboro, NCBuilt 1999 · S/N E-3258N936SAHalpin Cuyler · Lewisville, TXBuilt 1999 · S/N E-3277N936VN936v LLC · Knoxville, TNBuilt 1975 · S/N E-686N936WDCorporate Velocity Inc · Pawleys Island, SCBuilt 1997 · S/N E-3130N9370QS & L Skyview Aviation LLC · Wilmington, DEBuilt 1972 · S/N CE-361N93714Sprunger Air Services Div Of · Dalton, OHS/N 74-30627N9371QAshe Industries LLC · Murrieta, CABuilt 1972 · S/N D-9309N9372VFendley Bobby G · Fair Play, SCS/N 700013N93743Leonards Exchange Portrait Studio Inc · Saint Augustine, FLBuilt 1973 · S/N 73-30569N93759Billingsley Rod A · Las Vegas, NMBuilt 1973 · S/N 73-30573N93769Sourdough Air Service Inc · Fairbanks, AKBuilt 1977 · S/N 18503241N93777Arbach Enterprises Inc · Watertown, SDBuilt 1977 · S/N 18503243N93797Lattin Travis W · Beloit, KSBuilt 1976 · S/N 18503247N9379QSale Reported · Pottsboro, TXSale reportedBuilt 1972 · S/N E-305N9379YFitzgerald Aviation LLC · Bluffton, SCBuilt 1981 · S/N 21064491N937DJBank Of Utah Trustee · Salt Lake City, UTBuilt 1976 · S/N CE-626N937WB7wb LLC · Middletown, DEBuilt 1989 · S/N CE-1421N937WHLakemere Farms LLC · Spirit Lake, IAS/N 46-8508036N9380NAlaska Department Of Public Safety · Anchorage, AKBuilt 1981 · S/N 18504344N9380QRegistered aircraftBuilt 1972 · S/N CE-363N9380RFarm Air Inc · Astoria, ILBuilt 1975 · S/N 18802268N93814Haltmann Sven · Fairbanks, AKS/N 18503250N93827State Of Colorado Department Of Natural Resources · Denver, COBuilt 1977 · S/N 18503253N93836Clarkson Michael D · Anniston, ALBuilt 1974 · S/N 21060426
Back to AD 86-13-04 R3