OpenAirDocs.org
AD 86-13-04 R3

Registered aircraft · 18,495

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.

N8386M213tz LLC · Hailey, IDBuilt 1978 · S/N U20604520N8386QLe Tourneau University · Longview, TXBuilt 1976 · S/N U20603247N8388GTrombly Daniel · Franklin, NHBuilt 2003 · S/N 0470N8389NSav Aviation LLC · Jacksonville, TXBuilt 1968 · S/N D-8774N838CDQualitair LLC Trustee · MichelstadtBuilt 2002 · S/N 0339N838EBTurpin Time LLC · Helena, MTBuilt 2008 · S/N E-3838N8391NWolfpack Division LLC · Phoenix, AZBuilt 1968 · S/N TE-560N8392NCoats James Michael · Murrieta, CABuilt 1968 · S/N D-8775N8393NJa Mar Flight Services Inc · Anderson, INS/N D-8776N8395NLarocco John Jr · Michigan City, INBuilt 1968 · S/N D-8765N8395QN8395q LLC · Ketchum, IDBuilt 1978 · S/N 18503680N8397QSeattle Seaplanes LLC · Seattle, WABuilt 1976 · S/N U20603258N839HFFour Boys Flying LLC · Kalispell, MTBuilt 1980 · S/N P21000633N839WXBezner Partners LLC · Texline, TXBuilt 2004 · S/N 1154N83AVEllis Andrew N · Cocoa Beach, FLBuilt 1983 · S/N TH-1385N83CEElsner Kelly J · Menahga, MNBuilt 1980 · S/N P21000578N83CTFeliz Belize LLC · Pinetop, AZS/N E-370N83DLake Placid Flying Service Inc · Lake Placid, NYBuilt 1981 · S/N 414A-0615N83GGCec Aviaiton Services LLC · Windsor, CABuilt 1983 · S/N E-2101N83GHTebow William · Bunkie, LABuilt 1978 · S/N 310R1285N83JTLewis Thomas · Belton, TXBuilt 1976 · S/N 414-0835N83KKLowe Aviation Co · Macon, GABuilt 1996 · S/N TH-1781N83KPMulligan Gary · Kingston, NYBuilt 1990 · S/N CE-1435N83PBHyannis Air Service Inc DBA · Hyannis, MABuilt 1980 · S/N 402C0350N83RBBerning Ron D · Lino Lakes, MNBuilt 1980 · S/N 18504069N83RGKattchee Phillip A · Chappell Hill, TXBuilt 1987 · S/N CE-1205N83RJMckenzie Aviation Corp · Port Orange, FLS/N 29-0185N83SSSomd Seaplanes LLC · Lexington Park, MDBuilt 1973 · S/N 18502166N83WTTurrentine Mark W Md · Indianapolis, INBuilt 1993 · S/N E-2802N8400NPhillips Roger Dale II · Westfield, NCBuilt 1968 · S/N D-8767N8400QSpillman Aviation LLC · Colorado Springs, COS/N 18503682N8401ACommercial Property Services Group LLC · Wichita, KSBuilt 1977 · S/N 421C0443N8401NN8401n LLC · Cambridge, NEBuilt 1968 · S/N CE-215N8401QJoseph Kenneth W DBA · Canton, OHBuilt 1978 · S/N 18503683N8402NJones Dale H · Cookeville, TNBuilt 1968 · S/N D-8769N8403QWallace Andrew M · Salt Lake City, UTBuilt 1978 · S/N 18503684N8404NHidy Claude W · Stratton, NEBuilt 1968 · S/N D-8770N8405NSpaziani Thomas F · Flagstaff, AZBuilt 1968 · S/N D-8771N8405QVan Pelt Matthew · Challis, IDBuilt 1976 · S/N U20603265N8409QFrey David G Jr · Grand Rapids, MIBuilt 1976 · S/N U20603269N840DElusive Aviation Inc · Pflugerville, TXBuilt 1987 · S/N 4608076N840PRegistration Pending · Onsted, MIRegistration pendingBuilt 1968 · S/N D-8797N8414QSkywaggin LLC · Wilmington, DEBuilt 1978 · S/N 18503689N8419NSachau David W · Olathe, KSBuilt 1968 · S/N D-8784N841CBrown'S Aviation LLC · Whitesburg, GAS/N 0409N841JLMarks Stephen M · Monument, COBuilt 1967 · S/N T210-0330N841RQMueller Steven L · Osceola, WIBuilt 1976 · S/N U20603273N841TWMorton Mark H · Granbury, TXBuilt 1994 · S/N E2881N841ZSSilver Stephen E · Cincinnati, OHBuilt 1979 · S/N CE841N8420NHardy Robert C · Austin, TXS/N D-8773
Back to AD 86-13-04 R3