`Vehicle.where(vin_status: :invalid).where('vin in (?)', reload_vins)`.

Vehicle.where(vin_status: :invalid)
       .joins("
               join temp_cars.reload_cars tcar
               on tcar.vin = vehicles.vin
               where tcar.registration_id is not null
       ")