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.

N551GJanes Christopher D · Columbia, KYBuilt 1968 · S/N D-8772N551JACalderon Gustave P · Carlsbad, CABuilt 1978 · S/N E 1424N551JBValiair Lc Trustee · Casper, WYBuilt 1975 · S/N 21061129N551TN551t LLC · Hesston, KSBuilt 1977 · S/N D-10013N551USFar Side Aero LLC · Santa Maria, CABuilt 2005 · S/N 29-0351N5522COswald Ron · Eden Prairie, MNBuilt 1986 · S/N 21064973N5522TBeechcraft Heritage Museum Inc · Tullahoma, TNBuilt 1978 · S/N TK-79N5523YSimmons Scott · Anchorage, AKBuilt 1981 · S/N 21064236N5524VRamsey Jarrod Ross · Chicago, ILBuilt 1989 · S/N E-2505N5525USheriffs Department · Oakland, CABuilt 1979 · S/N U20605311N5527AMokiy LLC · Aurora, ORBuilt 1985 · S/N P21000861N5528VTrusler William L · Magnolia, TXBuilt 1990 · S/N CE-1426N5529DKanieski Maximilian M · New Canaan, CTBuilt 1989 · S/N CE-1403N5529VCandlestick Aviation Services LLC · Lewes, DEBuilt 1984 · S/N T30300303N552BWinkelbauer Kim G · Sun City, AZBuilt 1967 · S/N D-8524N552BBFrench Don Robles · Glendale, AZBuilt 1970 · S/N TE-800N552CDDirect Internet Inc · Harsens Islands, MIS/N 0922N552CMCm552 LLC · Katy, TXBuilt 2000 · S/N E-3337N552WTMaierhoffer Henry F Jr · Sylvania, GABuilt 1967 · S/N TE-486N552ZSTuolumne Ridge LLC · Modesto, CABuilt 1983 · S/N EA-343N5530ERovey Land & Cattle Co · Parker, AZBuilt 1979 · S/N 18503989N5530XFaulhaber Orlin W · North Platte, NEBuilt 1989 · S/N E-2504N5533KVan Nostran Michael T · Lake Havasu City, AZBuilt 1968 · S/N D-8905N5534RHanson David J · Charlotte, NCBuilt 1990 · S/N E-2576N5535WGpd LLC · Saint Louis, MOBuilt 1990 · S/N E2540N55367Mammoth Toys Inc · Santa Ana, CABuilt 1990 · S/N E2537N5536LAdvance Air LLC · Wichita, KSBuilt 1990 · S/N EA-502N5537CM G Aviation · Tyler, TXBuilt 1979 · S/N 21063785N5537VWheelzup LLC · San Carlos, CABuilt 1990 · S/N EA-506N5537XKelly Douglas E · Lake Ozark, MOBuilt 1990 · S/N E-2531N5538XBeartooth Air LLC · Cody, WYBuilt 1989 · S/N CE-1373N5538YTeton View Aircraft Leasing LLC · Grass Valley, CABuilt 1981 · S/N 21064241N5539SLm Air Patrol Service Inc · Wink, TXBuilt 1966 · S/N 188-0039N553CDMhz Management LLC · Wilmington, DEBuilt 2005 · S/N 1638N553LPMontana Aircraft Trust Inc Trustee · Bozeman, MTBuilt 1978 · S/N 414A0092N553SWHeritage Air LLC · Grove, OKBuilt 1981 · S/N 414A0614N5545AWhelan Peter A · Kettering, OHBuilt 1985 · S/N P21000864N5546Forster Sebastian Alexander · Elberta, ALBuilt 1979 · S/N EA-53N5546FCe-1382 LLC · Point Clear, ALBuilt 1989 · S/N CE-1382N5549AGeoterra Inc · Eugene, ORBuilt 1979 · S/N 21063491N554CCAmg/Sherfick Aviation LLC · Noblesville, INBuilt 1982 · S/N 421C1228N554CLLacy Clay · Groveland, CABuilt 1966 · S/N TE-99N554DDMhr Holdings LLC · Indian Hills, COBuilt 1973 · S/N TE-943N554LRCenterline Holdings · Camden, DEBuilt 1969 · S/N TE-738N554PMCrosswind Aviation LLC · Lititz, PABuilt 2007 · S/N E-3821N554TMLamar Aviation LLC · Paris, TXBuilt 1992 · S/N E-2688N5550YSteiner Paul R · Boerne, TXBuilt 1981 · S/N 21064245N5551VRegistered aircraftBuilt 1991 · S/N E-2637N5552Rosenlof Dean F · Tempe, AZBuilt 1969 · S/N CJ-15N5552XJjs Aero LLC · Middletown, DES/N E-2521
Back to AD 86-13-04 R3