Catalyzes the oxidation of medium and long chain aliphatic aldehydes to fatty acids. Active on a variety of saturated and unsaturated aliphatic aldehydes between 6 and 24 carbons in length (PubMed:18035827, PubMed:18182499, PubMed:22633490, PubMed:25047030, PubMed:9133646, PubMed:9662422). Responsible for conversion of the sphingosine 1-phosphate (S1P) degradation product hexadecenal to hexadecenoic acid (PubMed:22633490). {ECO:0000269|PubMed:18035827, ECO:0000269|PubMed:18182499, ECO:0000269|PubMed:22633490, ECO:0000269|PubMed:25047030, ECO:0000269|PubMed:9133646, ECO:0000269|PubMed:9662422}. This is the function of Ensembl gene identifier ENSG00000072210 (ALDH3A2, aldehyde dehydrogenase 3 family member A2).