OpenAirDocs.org
AD 86-13-04 R3

Registered aircraft · 18,497

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.

N4730QLindsey Brad A · Dubois, WYBuilt 1966 · S/N 185-1184N4733MNelson Steven L · Hampton, MNBuilt 1978 · S/N TH-927N4733VEdwards James W · Del Norte, COBuilt 1967 · S/N 30066N4734MMiller Carl J · San Dimas, CABuilt 1978 · S/N E-1257N4735PMarchman & Assosiates Inc · Krum, TXS/N P21000092N4736VRegistered aircraftBuilt 1967 · S/N 30067N4737FJelm Gordon E · Aguila, AZBuilt 1978 · S/N 18503552N4738MRetter Christpher · Lynn, INBuilt 1978 · S/N E-1258N4738QNeal Tyler W · Dufur, ORBuilt 1967 · S/N 185-1192N4739FEberwine David B · Lucas, TXBuilt 1966 · S/N P206-0339N473BCWaite Aviation LLC · Xenia, OHS/N 1658N473CDGrupinski Stephen · Wimberley, TXBuilt 2005 · S/N 1564N4740FSkydive Ricks LLC · Petersburg, OHBuilt 1966 · S/N P206-0340N4740QFitzpatrick D L III · Whitefish, MTBuilt 1966 · S/N 185-1194N4741KCrosswind Solutions Inc · Medford, ORBuilt 1979 · S/N P21000272N4741XRessel Erik P · Lakewood, COBuilt 1980 · S/N U20605529N47428Nei Jeffrey G · Bemidji, MNBuilt 1966 · S/N 185-1196N4742UProtocol Enterprises LLC · Holdrege, NEBuilt 1983 · S/N 21064810N4743CFour Three Charlie LLC · Andover, MABuilt 1979 · S/N 21063608N4743QHabersetzer Brian D · Brush Prairie, WABuilt 1967 · S/N 185-1197N4743XAerotech Mapping Inc · Las Vegas, NVBuilt 1980 · S/N U20605530N4744CDesert Aviation LLC · Kingman, AZBuilt 1979 · S/N 21063609N4744K4744k LLC · Mesa, AZBuilt 1979 · S/N P21000275N4744VSettle David A · Lyons, KSBuilt 1967 · S/N 30073N4745VFiecke Rodney J · Cokato, MNS/N 30074N4746U4746u LLC · Sherman Oaks, CABuilt 1979 · S/N U20605079N4747CAlfred Joseph T · Pagosa Springs, COBuilt 1979 · S/N 21063611N4747JKavie Andrew J · Blaine, MNBuilt 1967 · S/N M-1019N4747KFloyd Don B · Snohomish, WAFirst renewal noticeBuilt 1979 · S/N P21000278N4747VRegistered aircraftBuilt 1967 · S/N 30036N474AWCenturion Aviation LLC · Ada, MIBuilt 1981 · S/N P21000652N474CDNiagara Airways LLC · Orchard Park, NYBuilt 2005 · S/N 1573N474DBMr Restore Services Inc · Vero Beach, FLBuilt 1976 · S/N 310R0822N474DLPrasad Sanjeev K · Las Vegas, NVBuilt 1976 · S/N 310R0704N4750FSouth Dakota Skydivers Inc · Sioux Falls, SDBuilt 1966 · S/N P206-0350N4750QDelaware C Plane Inc · Wilmington, DES/N 185-1204N4751QHofer Bruce L · Freeman, SDBuilt 1976 · S/N 18802508N4752KAraiza Fernando A · Tucson, AZBuilt 1979 · S/N P21000283N4752QBrown Timothy L · Liberty Lake, WABuilt 1978 · S/N 18503553N4753FRobertson Robin L · Murfreesboro, TNBuilt 1966 · S/N P206-0353N4753MPalotas Anne Marie · Napa, CABuilt 1978 · S/N CE-780N4753UTurchan Robert H · Scottsdale, AZBuilt 1983 · S/N 21064811N4754AIndigo Air LLC · Gulf Breeze, FLBuilt 1980 · S/N 340A1024N47557M & M Aircraft LLC · Cresson, TXBuilt 1977 · S/N 34-7770414N4755KPhilmar LLC · Oshkosh, WIBuilt 1979 · S/N P21000286N4755QCook Alfred M · Juneau, AKBuilt 1967 · S/N 185-1212N4756CTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 21063613N4756EAero Missions Inc · Sylacauga, ALBuilt 1979 · S/N 18503862N4757FMulcaire Jess E · Camp Verde, AZBuilt 1966 · S/N P206-0357N4757KGirard Gregory M · Tucson, AZBuilt 1979 · S/N P21000288
Back to AD 86-13-04 R3