Linked server from SQL server on AWS RDS to On premises MS SQL server database
The Implement Linked Servers with Amazon RDS for Microsoft SQL Server doc says RDS supports below options:


SQL Server (EC2 or on-premises) to RDS SQL Server
RDS SQL Server to SQL Server (RDS, EC2, or on-premises)