The north’s largest housing association has called for a collective effort to tackle record waiting lists across the sector.