2025-03-03     2025-03-04     2025-03-05

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