Not quite the same as your suggestion but SFO has a Sky Terrace pre-security that you can go and watch planes from.