don't have duplicates for icao/iata airport codes

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

select featureclass,alternatename.name,alternatename.namelocale from alternatename,geoname where featureclass='H' and geoname.geonameid=alternatename.geonameid and alternatename.namelocale in ('faac','icao','iata') and (isformername is null or not isformername) and alternatename.name<>'EDDB' and featurecode not in ('CHN','HBR','BAY') group by featureclass,alternatename.name,alternatename.namelocale having count(*)>1

seaplanes

featureclass	name	namelocale