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.

N6183NLewis A Everett Jr · Chico, CAFirst renewal noticeBuilt 1978 · S/N 21062954N6184CRegistered aircraftBuilt 1979 · S/N 21063824N6184QMarc Inc · Bolton, MSBuilt 1968 · S/N 320F-0034N6185BGust William J DBA · Monument, COBuilt 1978 · S/N 21062701N6185CFry Barry J · Boyce, VAS/N E-1972N61861Pulley Richard A · Chugiak, AKBuilt 1981 · S/N 18504265N6186XSaint Louis Cessna Group LLC · Saint Louis, MOBuilt 1978 · S/N 310R1325N6187FNuxoll Builders · Clarkston, WABuilt 1968 · S/N 21059087N61885Libby Stephen R Trustee · Anchorage, AKBuilt 1981 · S/N 18504269N6188RPeterson Bruce L · Brighton, COBuilt 1966 · S/N T210-0088N6188XKorotkov Dmitry V · Rocklin, CAS/N 0629N6188YLexington Enterprises Group Inc · San Jose, CABuilt 1981 · S/N 21064287N618BHTkr3 Aviation LLC · Urbandale, IABuilt 1990 · S/N E-2543N618CAHyannis Air Service Inc · Hyannis, MABuilt 1981 · S/N 402C0620N618CHHearn Caughey · Claxton, GABuilt 1970 · S/N TE-787N618MBSonic Boom Services Inc · Broad Channel, NYBuilt 2004 · S/N 1148N618MROshaughnessy Stephen M · Littleton, COBuilt 1979 · S/N 340A0653N618WWood Jim · Seminole, TXBuilt 1966 · S/N P206-0218N61919Tailspin LLC · Belle Chasse, LABuilt 1981 · S/N 18504274N6192NDolezal Todd R · San Luis Obispo, CABuilt 1978 · S/N 21062963N6192RAmbrosini Helicopters Inc · Fresno, CABuilt 1966 · S/N T210-0092N6192UKings Nw LLC · Lakewood, WABuilt 1979 · S/N U20605377N6192XSongbird Group LLC · Andover, MNBuilt 1978 · S/N 310R1329N6193FRheinbolt John N · Highmore, SDBuilt 1968 · S/N 21059093N6193QRedstar Air Shows Inc · Discovery Bay, CAFirst renewal noticeBuilt 1968 · S/N 320F-0043N61955Tommys Flying Service Inc · Sherrill, ARBuilt 1981 · S/N 18504280N6195BBoyd Edward Ayres · Coronado, CABuilt 1978 · S/N 21062705N6195FRegistered aircraftBuilt 1968 · S/N 21059095N6195QSunny Aviation LLC · Kalispell, MTBuilt 1968 · S/N 320F-0045N6195XSlc Service Leasing Company LLC · Tipton, IABuilt 1978 · S/N 310R1331N61963Grier Timothy R · Anchorage, AKBuilt 1981 · S/N 18504282N6196NMccarthy Sean P · Siloam Springs, ARBuilt 1978 · S/N 21062967N6198AEdwards Thomas M · New Tazewell, TNBuilt 1981 · S/N E-1976N6198USeldom Seen LLC · Kalispell, MTBuilt 1981 · S/N D-10388N6199FAcara Aviation LLC · Portage, MIS/N 21059099N6199RSchutte Ernest C W · Abita Springs, LAS/N T210-0099N619CDSimpson Walker Aviation LLC · Joplin, MOBuilt 2005 · S/N 1672N619CHOrion Works Limited · Denali Park, AKBuilt 1969 · S/N U206-1276N619RLPlane Addiction LLC · Hopkinton, MABuilt 2005 · S/N 1528N619VMHalberg Barri R · Yacolt, WABuilt 1981 · S/N 18504284N619WMKatz Aviation LLC · Riverwoods, ILBuilt 2005 · S/N 1447N61AJCoco Air Ltd Trustee · Wilmington, DEBuilt 1978 · S/N 421C0457N61BQEle Motorsports LLC · Dover, DEBuilt 1986 · S/N 21064987N61BSKris & B Holdings LLC · Hyrum, UTBuilt 1993 · S/N EA-544N61BWWelch William Ben · Danville, ILBuilt 2000 · S/N LIV-413N61DBBorror Sean L · Palmdale, CABuilt 1970 · S/N D-9136N61ECBald Mountain LLC · Dedham, MEBuilt 1983 · S/N 18504403N61LBBober Ronald J · La Porte, INBuilt 2003 · S/N 61N61LPRossetter Eric · Lafayette, CABuilt 1981 · S/N E-1807N61PTWings Of Faith Ministries Inc · Tustin, CABuilt 1978 · S/N U20604538
Back to AD 86-13-04 R3