In this work, a novel multipurpose Faujasite (FAU) zeolite composite membrane was fabricated by in‐situ hydrothermal method to separate different solute molecules such as vanillic acid, phenol, and brilliant green from the aqueous solution. The coal fly ash based ceramic substrate was synthesized and used as substrate for preparing the zeolite composite membrane. The X‐ray diffraction (XRD) pattern confirmed the crystalline nature of membranes and the presence of Quartz and hematite in the composite membrane. The presence of Si‐O and Al‐O in zeolite coated composite membrane was confirmed by Fourier Transform infrared spectroscopy (FTIR) analysis. Scanning electron microscope (SEM) analysis showed the porous structure and 8.34 μm thickness of zeolite coating on membrane. The isoelectric point of composite membrane was observed at pH 2.07 through zeta potential analysis. Brunauer‐Emmett‐Teller (BET) surface area, average pore volume and pore diameter of zeolite composite membrane were estimated as 6.406 m2/gm, 0.0070 cm3/gm, and 4.371 nm, respectively. The hydraulic pore radius and porosity of composite membranes were 27.7 nm and 20.1%. The maximum separation efficiency of FAU zeolite composite membrane towards vanillic acid, phenol and brilliant green was estimated as 78.67%, 89.13%, and 94.28%, respectively, for 200 mg/L feed concentration at 276 kPa applied pressure. The results obtained in this study reveals that the multipurpose FAU zeolite composite membrane fabricated in this study can be effectively used for separation of various solutes molecules present in the wastewater.