2025-04-15     2025-04-16     2025-04-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