Yes
select rid from routes where dst_apid in ( select apid from airports where country = 'United States' ) and src_apid in ( select apid from airports where country = 'United States' )