Some of the record from a particular table in global search are not returning any results while others do return results when searching from global search using the record number
Jakarta , Kingston , London
Before the global search return anything to the user first it goes to the defined search group and filters the record based on the filter condition. In this case the filter condition was set to active = true and this record had active = false.
Check if the record fulfills the filter condition of the table in the search group and adjust accordingly based on the requirement.
Go through below documentation on how to create a search group.