So, I thought I'd do a list of Famicom RPGs and adventure games which were translated up to this point. It's largely based on Garret's list, with some additions and changes. Perhaps this list is gonna help some folks out (haven't noticed any list like that on the site, but I might've missed it). I'm not 100% sure if all of them can be considered RPGs or adventure games, but oh well. If anyone knows whether any patches for the untranslated games are in the works, it would be good to mention it here, so as to update the list further on.
RPGsTranslated (FC):
AD&D: Dragons of Flame (DvD Translations)
Akuma-kun: Makai no Wana (KingMike, snark)
Bloody Warriors (ded)
Chaos World (AGTP)
Columbus (aishsha)
Dark Lord (AGTP)
Deep Dungeon 3 (KingMike)
Deep Dungeon 4 (KingMike)
Destiny of an Emperor 2 aka Tenchi wo Kurau 2 (Magic Destiny)
Digital Devil Story Megami Tensei (Esperknight, Stardust Crusaders)
Doraemon Giga Zombie no Gyakushuu (WakdHacks)
DBZ Gaiden (Twilight Translations)
DBZ 1 (Twilight Translations)
DBZ 2 (Twilight Translations + Gyroballer)
DBZ 3 (Twilight Translations)
Double Moon Densetsu (Stardust Crusaders)
Dragon Ball Daimaou Fukkatsu (Stardust Crusaders)
Dragon Scroll: Yomigaerishi Maryuu (KingMike)
Dream Master (aishsha)
Elysion (Tenshigami)
Esper Dream 2 (AGTP)
Famicom Jump (two translations - Pacnsacdave and BlackPaladin)
Final Fantasy 2 (Demi)
Final Fantasy 3 (Multiple)
Fire Emblem (Quirino)
Fire Emblem Gaiden (Artemis251, Shimizu Hitomi)
Ganbare Goemon Gaiden (Adventurous Translations)
Ganbare Goemon Gaiden 2 (Adventurous Translations)
Ganso Saiyuuki: Super Monkey Daibouken (GAFF Translations)
Gegege no Kitarou 2: Youkai Gundan no Chousen (Djinn, aishsha)
Glory of Heracles (DvD Translations)
Glory of Heracles 2 (Spoony Bard)
Grand Master (aishsha, Stardust Crusaders)
Hydlide 3 (pacnsacdave)
Indora no Hikari (KingMike)
Jajamaru Gekimaden (Stardust Crusaders, aishsha)
Jajamaru Ninpou Chou (Stardust Crusaders)
Jikuu Yuten: Debias (Gil Galad)
Juvei Quest (aishsha, Stardust Crusaders)
Kaijuu Monogatari (KingMike)
Karakuri Kengoden Musashi Lord (aishsha, Stardust Crusaders)
Kawa no Nushi Tsuri (pikachumanson, MrRichard999)
King Kong 2: Ikari no Megaton Punch (DvD Translations)
Kouryu Densetsu Villgust Gaiden (Supper, TheMajinZenki, cccmar)
Lagrange Point (AGTP)
LaSalle Ishii no Child's Quest (Polinym)
Magic Candle (Stardust Crusaders)
Maharaja (snark)
Majin Eiyuuden Wataru Gaiden (Hubz)
Minelvaton Saga (aishsha)
Mirai Shinwa Jarvas (Stardust Crusaders, aishsha)
Momotarou Densetsu (KingMike)
Mouryou Senki Madara (AGTP)
Musashi no Bouken (Gaijin)
Niji no Silkroad (Gaijin)
Ninja Rahoi (aishsha, Stardust Crusaders)
Otaku no Seiza/Constellation Nerdulus (Stardust Crusaders, Tom)
Outlanders (Pluvius, EienNiHen, Filler)
Radia Senki (dreamless, Jair, [cx])
Romancia (DvD Translations)
RPG Jinsei Game (Nebulous Translations)
Saint Seiya: Ougon Densetsu Kanketsu Hen (Djinn, aishsha)
Sansara Naga (aishsha, Stardust Crusaders)
SD Gundam Gaiden: Knight Gundam Monogatari (Stardust Crusaders)
SD Keiji Blader (aishsha, Stardust Crusaders)
Shadow Brain (aishsha, Stardust Crusaders)
Shinsenden (aishsha)
Silva Saga (aishsha)
Spelunker 2 (Stardust Crusaders)
STED (J2E)
Super Chinese 3 (Tom, DDS)
SWAT: Special Weapons and Tactics (Psyklax, filler)
Sweet Home (Gaijin)
Tao (snark)
Ushio to Tora: Shinen no Daiyou (BlackPaladin)
Ys (David Mullen)
Ys 2 (David Mullen)
Ys 3 (Vice Translations)
Untranslated (FC):
Artelius
Bikkuriman World
Dragon Ball 3
Dungeon Kid
Famicom Jump 2
Ginga no Sannin
Hissatsu Doujou Yaburi
Hokuto no Ken 3 (Spanish translation available - wave)
Hokuto no Ken 4
Hoshi o Miru Hito (partially translated)
Hyakki Yakou
Kagerou Densetsu
Kyonshies 2 (translated - needs script insertion)
Last Armageddon
Momotarou Densetsu Gaiden
Monster Maker
Rokudenashi Blues
Sanada Juu Yuushi
Satomi Hakkenden
SD Gundam Gaiden: Knight Gundam Monogatari 2
SD Gundam Gaiden: Knight Gundam Monogatari 3
SD Gundam: Gundam Wars
Shin Satomi Hakkenden: Hikari to Yami no Tatakai
Square no Tom Sawyer
Tenkaichi Bushi: Keru Naguuru
Ultraman Club 2: Kaette Kita Ultraman Club
Ultraman Club 3: Mata Mata Shiyutsugeki!! Ultra Kyoudai
Zoids 1
Zoids 2: Zenebasu no Gyakushuu
Translated (FDS):
BodyConQuest I (DvD Translations)
Cleopatra no Mahou (DvD Translations)
Dandy: Zeuon No Fukkatsu (Super Roboprotector)
Deep Dungeon (KingMike)
Deep Dungeon 2 (KingMike)
Esper Dream (mute)
Ginga Denshou (Chris M. Covell)
Kalin no Tsurugi (KingMike)
Lutter (mute)
Seiken Psycho Caliber: Maju no Mori Densetsu (Spoony Bard)
Sylviana (mute)
Untranslated (FDS):
Aspic
Magma Project Hacker
Marchen Veil
Ultraman Club: Chikyuu Dakkan Sakusen
Adventure GamesTranslated (NES):
Akira (Dank-Trans)
Ankoku Shinwa: Yamato Takeru Densetsu (snark)
Dai Meiro: Meikyuu no Tatsujin (filler, KingMike's Translations)
Idol Hakkenden (Supper, TheMajinZenki, cccmar)
Jesus: Kyoufu no Bio Monster (Stardust Crusaders)
Kaguya Hime Densetsu (snark)
Kujaku Ou (snark)
Kujaku Ou II (snark)
Labyrinth: Maou no Meikyuu (Suicidal Translations)
Maharaja (snark)
Metal Slader Glory (Stardust Crusaders)
Mississippi Satsujin Jiken (GAFF Translations)
Oishinbo: Kyukyoku no Menu 3bon Syoubu (snark)
Portopia Renzoku Satsujin Jiken (DvD Translations)
Ripple Island (Supper, TheMajinZenki, cccmar)
Sanma no Meitantei (Supper, TheMajinZenki, cccmar)
Seirei Gari (snark)
Takeshi no Chousenjou (KingMike's Translations)
Untranslated (NES):
Akagawa Jirou no Yuurei Ressha
Be-Bop Highschool
Business Wars
Erika to Satoru no Yume Bouken
Gozonji
Hissatsu Shigoto Nin
Hokkaidou Rensa Satsujin
Jarinko Chie
Kyouto Hana no Misshitsu - Satsujin Jiken
Kyouto Ryuu no Tera - Satsujin Jiken
Marusa no Onna (partial patch exists)
Masuzoue Yoichi
Meiji Ishin
Meitantei Holmes - Kiri no London Satsujin Jiken
Meitantei Holmes - M kara no Chousenjou
Mindseeker
Nishimura Kyoutarou Mystery - Blue Train Satsujin Jiken
Nishimura Kyoutarou Mystery - Super Express Satsujin Jiken
Osomatsu-kun
Pro Yakyuu Satsujin Jiken
Satsui no Kaisou
Sekiryuou
Shounen Ashibe
Time Stranger
TM Network
Touhou Kenbun Roku
Yamamura Misa Suspense Series
Translated (FDS):
Dead Zone (Stardust Crusaders)
Famicom Tantei Club: Kieta Kōkeisha (first part) (official Switch remake in English)
Famicom Tantei Club: Kieta Kōkeisha (second part) (official Switch remake in English)
Famicom Tantei Club Part II: Ushiro ni Tatsu Shōjo (first part) (official Switch remake in English)
Famicom Tantei Club Part II: Ushiro ni Tatsu Shōjo (second part) (official Switch remake in English)
Nakayama Miho no Tokimeki High School (FCAndChill)
Samurai Sword (Mute)
Suishou no Dragon (Mute)
Tantei Jingūji Saburo: Kiken na Ninin (first part) (remake available in English)
Tantei Jingūji Saburo: Kiken na Ninin (second part) (remake available in English)
Tantei Jingūji Saburo: Shinjuku Chūō Kōen Satsujin Jiken (remake available in English)
Untranslated (FDS):
Ao no Senritsu
Mr. Gold: Kinsan in the Space
Risa no Yōsei Densetsu: Risa Tachibana
Shin Onigashima (first part)
Shin Onigashima (second part)
Time Twist: Rekishi no Katasumi de... (first part)
Time Twist: Rekishi no Katasumi de... (second part)
Yūyūki (first part)
Yūyūki (second part)