The extensive daily statistics of aerosol properties, cloud properties, and their mutual correlations provide crucial information for better assessing future climate change. In this paper, 14 years (2010–2023) of data from the Moderate Resolution Imaging Spectroradiometer (MODIS) are analyzed over the northern part of Arabian Sea (Latitude: 21°–25° N and Longitude: 62°–68° E) to assess the characteristics of aerosols and clouds and their relationships under different meteorological conditions. When aerosol optical depth (AOD) is less than ∼ 0.7, the observations exhibit a positive correlation between AOD and cloud droplet effective radius (CDR) but negative correlations between AOD and cloud droplet number concentration (CDNC), between AOD and cloud optical depth (COD), between AOD and cloud liquid water path (CLWP), and between AOD and cloud geometrical thickness (H). The corresponding aerosol-cloud correlations change signs when the AOD values are larger than 0.7. However, the single folded positive AOD-cloud fraction (CF) relationship is observed in both AOD regimes. Similar correlations are also observed between precipitable water vapor (PWV) and CDR, CDNC, COD, H, CF and CLWP, together with a positive correlation between PWV and AOD. Further isolation of the environmental effects from aerosol effects by stratifying AOD and cloud data into different LTS and PWV bins shows that the signature of the well-known Twomey effect is observed under high LTS-high PWV conditions, while an opposite effect (anti-Twomey) is observed under low PWV conditions, regardless of LTS values. Additionally, negative correlations between AOD and COD, AOD and CLWP, and AOD and H are observed under low LTS, regardless of PWV conditions, with a slight positive correlation when AOD >0.4 under high LTS and PWV conditions.