Query: rds_db_instance_subnets

select
  p ->> 'SubnetIdentifier' as "Subnet Identifier",
  p -> 'SubnetAvailabilityZone' ->> 'Name' as "Subnet Availability Zone",
  p ->> 'SubnetStatus'  as "Subnet Status"
from
  aws_rds_db_instance,
  jsonb_array_elements(subnets) as p
where
  arn = $1;