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.

N3464LMolinaro Peter · Mendota Heights, MNBuilt 1966 · S/N U206-0764N3469YGration Jonathan Scott Jr Trustee · Eagle River, AKBuilt 1975 · S/N 18502888N346BGWebstrong Aviation LLC · Conway, ARBuilt 1973 · S/N D9494N346CBKombi Brazil Inc · Fort Lauderdale, FLS/N 21060712N346CHAce Flight Center Inc · St Thomas, VIBuilt 1979 · S/N 402C0029N346DWValiair Lc Trustee · Casper, WYBuilt 1979 · S/N 340A0742N346ENorth Coast Aeronautical LLC · Cleveland, OHBuilt 1984 · S/N EA-409N346FSRichard C Reed · Snyder, TXS/N 340A0790N346MCSkyway Aviation LLC · Purvis, MSS/N 340A-0425N346RNSchroll Charles E · Tucson, AZBuilt 1969 · S/N P206-0567N346S200 Knot LLC · Amarillo, TXBuilt 1969 · S/N D-9092N3471GPage Garrett A · Rhodes, MIBuilt 1976 · S/N 310R0845N3472GLosko Patrick J · Tustin, CABuilt 1976 · S/N 310R0846N3473GThayer John P · Columbus, GABuilt 1976 · S/N 310R0847N3473WGades Gary A · Montevideo, MNBuilt 1980 · S/N 18504080N3474QLyle Timothy · Lakewood Ranch, FLFirst renewal noticeBuilt 1966 · S/N 320E-0074N3476AIsaacs Eugene E · Key West, FLS/N CE-294N3477ARagsdale Lincoln J Jr · Phoenix, AZBuilt 1969 · S/N E-183N3478QCsc Aviation LLC · Parker, COS/N 320E-0078N347ABTropical Transport Services Ltd Inc · San Juan, PRBuilt 1980 · S/N 402C0347N347CDCulkin Daniel J Trustee · Edmond, OKBuilt 2005 · S/N 1360N347JADepete Joseph G · Louisville, KYBuilt 1978 · S/N 340A0448N3485LEhalt Christopher J · Lester Prairie, MNBuilt 1967 · S/N U206-0785N3489QPlane Progress LLC · Waterloo, IABuilt 1967 · S/N 320E-0089N3489YHutchinson Earl F · Fairbanks, AKS/N 18502893N348SKoritz Iowa Properties LLC · Key Colony Beach, FLBuilt 1970 · S/N D-9125N348TFli Aero Ltd · New Lebanon, OHBuilt 1976 · S/N E-908N3491QOuter Marker Inc · Sandy, UTS/N 320E-0091N3492QLadet William D · Las Vegas, NVS/N 320E-0092N3494QRodcon Aircraft Sales LLC · Kalispell, MTBuilt 1967 · S/N 320E-0094N3495LSaqul'Aq Air LLC · Coupeville, WABuilt 1967 · S/N U206-0795N349RFPhase 2 Ventures LLC · Seattle, WABuilt 2003 · S/N ES-102-FBN349RPMiranda Gary R · Vancouver, WABuilt 1998 · S/N E-3202N34ADPremiere Aviation Inc · Concord, CABuilt 1975 · S/N 421C-0036N34ANScala Peter M · Port Orange, FLBuilt 1954 · S/N CG-4N34AWValiair Lc Trustee · Casper, WYBuilt 1976 · S/N 340A0097N34BAPrvny Pluk LLC · Houston, TXBuilt 1956 · S/N G-797N34BPAviation Insurance Managers Inc · Uniontown, OHBuilt 2014 · S/N TH-2420N34BRIndustrial Reports Inc · Raleigh, NCBuilt 1981 · S/N CE-946N34BTWilliams Charles R · Wadsworth, OHBuilt 1973 · S/N 21060130N34CDCannon David A · Magnolia, TXBuilt 2002 · S/N 0148N34DBRegistered aircraftBuilt 2003 · S/N 29-0300N34EMSpirit Rotorcraft LLC · Phoenix, AZBuilt 1955 · S/N 53-4150N34FFZwierlein Victor · Grand Prairie, TXBuilt 1976 · S/N U20603334N34FHJeffcoat Jon T · Nome, TXBuilt 1981 · S/N E-1836N34FUWatson George E · Temecula, CABuilt 1956 · S/N BG-180N34GCPhillips Stuart G · Woodside, CABuilt 1982 · S/N EA-283N34JPDakota Aircraft Inc · Pierre, SDBuilt 1973 · S/N CJ-39N34KCh Aviation LLC · Wilmington, DEBuilt 1981 · S/N 18504349N34KBReilly Donald H · Micco, FLBuilt 1978 · S/N 21062656
Back to AD 86-13-04 R3