2025-08-15     2025-08-16     2025-08-17

icao code format

number of errors=0
number of warnings=0
Group=ckgGrpAirpIcao

select geonameid,name,namelocale from alternatename where namelocale='icao' and (not name ~ '[0-9A-Z]{4}' or length(name)<>4)

geonameid	name	namelocale