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.

N6ZQHarrelson William C · Port Saint Lucie, FLBuilt 2012 · S/N SB2N70006Colorado Red LLC · Dillon, COBuilt 1971 · S/N 18501886N7000KCohen Phillip A · Hopkinton, MABuilt 1978 · S/N 210-62553N7000LHalstead Michael J · Gresham, ORBuilt 1975 · S/N U20602907N70022Linford Robert M · Spokane, WABuilt 1971 · S/N 18501897N70026Stephens Brandon J · North Pole, AKBuilt 1971 · S/N 18501901N7002NBfr Racing Inc · Monticello, ARBuilt 1967 · S/N D-8613N70037Bancroft Contracting Corporation · South Paris, MEBuilt 1971 · S/N 18501905N70048Trident Resources LLC · Chino Valley, AZS/N 18501917N7005NRizzo Joseph A · Akron, NYBuilt 1967 · S/N CE-184N70063Welch Thomas R DBA · Modesto, CABuilt 1974 · S/N 18801827TN70070Bay Air Inc · Dillingham, AKBuilt 1971 · S/N 18501939N70071Bender Charles A Jr · Orrstown, PABuilt 1971 · S/N 18501940N7007VTurk James H · Mesa, AZBuilt 2001 · S/N 0082N70083Air Pacific LLC · Port Angeles, WABuilt 1971 · S/N 18501950N70084Bridges Pamela J · Calais, MES/N 18501951N70085Embley Kenneth · Anchorage, AKS/N 18501952N70091Franke Gordon D · Anchorage, AKBuilt 1972 · S/N 18501964N700BTHogan Christopher S · Colorado Springs, COBuilt 1966 · S/N D-8076N700DCSwanson David R · Isanti, MNBuilt 1977 · S/N E-1132N700DKFlysix Oregon LLC · Salem, ORBuilt 1980 · S/N 340A1038N700EDMcd Aviation Inc · Wilmington, DEBuilt 1972 · S/N D-9372N700HBLucky7 Air LLC · Lenoir, NCBuilt 1982 · S/N 414A0810N700HGAerosphere LLC · Cedar City, UTBuilt 2005 · S/N 1506N700KBrenner Gary Lynn · Mission Viejo, CABuilt 1981 · S/N TH-1321N700PGoree John A · Iowa City, IABuilt 2004 · S/N 0791N700RCUniversal Aviation LLC · Decatur, ARBuilt 1991 · S/N E-2606N700RSTransavia LLC · Wilmington, DEBuilt 1981 · S/N P21000716N700RTLipton Jack · Cottonwood, AZBuilt 1996 · S/N 29-0097N700SSBullard Franklin C · Ormond Beach, FLS/N E-1248N700TTriplat Douglas P · Rosamond, CABuilt 1969 · S/N E113N700VRMountain & Vine LLC · Park City, UTBuilt 1979 · S/N TJ-194N70104Duclos Paul R III · Anchorage, AKBuilt 1972 · S/N 18501992N70112Piper Meridian LLC · Mesa, AZBuilt 1972 · S/N 18501995N70141Priewe Flying Service LLC · Como, MSBuilt 1974 · S/N 18801847TN70148Panting Edwin Allan · Anchorage, AKBuilt 1972 · S/N 18502020N7014CAct Aviation LLC · Oxford, MSBuilt 1979 · S/N CE-883N7014ESkinner Norman D · Osceola, IABuilt 1964 · S/N 21058334N70162Nwops LLC · Woodinville, WABuilt 1972 · S/N 18502028N7016NN7016n LLC · Columbia, MOBuilt 1967 · S/N D-8649N7017NSalinas Nursery Inc · Fresno, CABuilt 1967 · S/N TE-484N70183Cranford Billy J · Wasilla, AKS/N 18502039N7018NLawless Van N Jr · Mooresville, NCBuilt 1967 · S/N D-8618N70194Jelinek Spencer T · Erie, COBuilt 1972 · S/N 18502047N70195Registration Pending · Anchorage, AKRegistration pendingBuilt 1972 · S/N 18502048N70199Motonaga Gregg K · Soldotna, AKBuilt 1972 · S/N 18502052N701CDQualitair LLC Trustee · MichelstadtBuilt 2001 · S/N 0006N701CJCenturion Aviation Ltd · Salina, KSBuilt 1968 · S/N 401A0022N701MDDel Mar Aviation LLC · Algona, IABuilt 1980 · S/N 21064007N701PMJedi Flight Training LLC · Boerne, TXBuilt 2001 · S/N 0007
Back to AD 86-13-04 R3