2025-09-09     2025-09-10     2025-09-11

iata code format

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

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

geonameid	name	namelocale