Context. The local census of very low-mass stars and brown dwarfs is crucial to improving our understanding of the stellar-substellar transition and their formation history. These objects, known as ultra-cool dwarfs (UCDs), ...