2025-03-26     2025-03-27     2025-03-28

airport and port or terminal

number of errors=5
number of warnings=0
Group=chkGrpUnlocode

select cc,code,name,subdiv,function,state,admincode1 from UNLOCODE20241 where geonameid is null and function is not null and function like '%4%' and (function like '1%' or function like '%3%')


cc	code	name	subdiv	function	state	admincode1	
XZ	SUU	Suursaq	null	1--4-6--	RL	null	
BS	MSK	Mastic Point Apt	null	--34----	RL	null	
FR	null	Fort-de-France = MQ FDF	null	1--45---	AF	null	
FR	null	Pointe-a-Pitre = GP PTP	null	1--45---	AF	null	
IQ	BSH	Bashur Airfield	null	--34----	RQ	null