The production of cellulose-based aerogels from the conversion of cheap and rich precursors using environmentally friendly techniques is a very attractive subject in materials chemistry. In this work, we reports a facile strategy to construct flame retardant, sound-adsorption and mechanical enhancement cellulose-based composite aerogels by the incorporation of aluminum hydroxide nanoparticles (AH NPs) into cellulose gels via an in-situ sol-gel process, followed by freeze-drying to coat AH NPs on cellulose composite aerogels (AH NPs@cellulose composite aerogels). The results demonstrated that the AH NPs homogeneous dispersion within cellulose aerogel, and the presence of AH NPs did not have a remarkable influence on the homogeneous porous structure of cellulose aerogels when compared with cellulose aerogel prepared from the NaOH/urea/thiourea solution. The prepared composite cellulose aerogels showed excellent flame retardancy, the peak of heat release rate (PHRR) of the composite aerogels decreased significantly from 280 W/g of the control sample to 22 W/g, and total heat release (THR) of the composite aerogels decreased remarkably from 13.2 kJ/g to 1.6 kJ/g. Moreover, the incorporation of AH NPs composite aerogels exhibited remarkable mechanical properties, the compressive strength of the composite aerogels increased significantly from 0.08 MPa to 1.5 MPa. In addition, AH NPs composite cellulose aerogels have excellent sound absorption at high frequencies with a maximum sound absorption coefficient of 1. AH NPs composite cellulose aerogels have strong water and oil affinity. After immersing the samples in mixed silica nanoparticles, heptadecafluorononanoic, and fluoroalkyl silane solutions they became super-antiwetting, with a water contact angle (CA) larger than 150° and oil CA larger than 140°. In summary, this study provides a facile strategy to rationally construct flame retardant, mechanically robust, high-efficiency sound-adsorption and superamphiphobic cellulose-based composite aerogels, which have promising applications in the future as green engineering materials.