Lufthansa still flies a 747-8 between FRA and SFO.

https://www.flightaware.com/live/flight/DLH454

I booked it once when I couldn’t find a direct flight from AMS to SFO.