Viral vectors based on recombinant adeno-associated virus (rAAV) have become the most widely used system for therapeutic gene delivery in the central nervous system (CNS). Despite clinical safety and efficacy in neurological applications, a barrier to adoption of the current generation of vectors lies in their limited efficiency, resulting in limited transduction of CNS target cells. To address this limitation, researchers have bioengineered fit-for-purpose AAVs with improved CNS tropism and tissue penetration. While the preclinical assessment of these novel AAVs is primarily conducted in animal models, human induced pluripotent stem cell (hiPSC)-derived organoids offer a unique opportunity to functionally evaluate novel AAV variants in a human context. In this study, we performed a comprehensive and unbiased evaluation of a large number of wild-type and bioengineered AAV capsids for their transduction efficiency in hiPSC-derived brain organoids. We demonstrate that efficient AAV transduction observed in organoids was recapitulated in vivo in both mouse and non-human primate models following cerebrospinal fluid (CSF) delivery. In summary, our study showcases the utilization of brain organoid systems for the pre-screening of novel AAV vectors. Additionally, we report data for novel AAV variants that exhibit improved CNS transduction efficiency when delivered via the CSF in in vivo preclinical models.