Menu Sign In Contact FAQ
Banner
Welcome to our forums

NOTAM statistics fun

Looking at all NOTAMs worldwide, one can create interesting statistics.

As of now there are

select count(*) from notams;
 count 
-------
 36807

active NOTAMs. Who is the most active NOTAM issuer? Every NOTAM comes from a NOTAM Office (NOF). A country usually has one but can have multiple. The list of NOFs can be found on the Eurocontrol site.

For most countries, the first two letters of the NOF correspond to the ICAO country code. Let’s rank the countries worldwide.

select substring(NOF from 1 for 2), count(*) as count from notams group by substring(NOF from 1 for 2) order by count desc limit 10;
 substring | count 
-----------+-------
 ED        |  2338
 LF        |  1956
 LI        |  1742
 UU        |  1696
 EP        |  1597
 LT        |  1256
 EG        |   970
 SB        |   968
 ZB        |   888
 LO        |   854
(10 rows)

The USA reserve the letter K and P for them, so let’s add them for fairness:

select count(*) from notams where substring(NOF from 1 for 1)='P' or substring(NOF from 1 for 1)='K';
 count 
-------
  3700
(1 row)

So we can see that the USA have the largest number of NOTAMs out there but a strong 2nd winner is Germany (ED) followed by France (LF) and Italy (LI). Russia (UU) is next, then surprisingly Poland (EP), Turkey (LT) and then with a lowly 970 NOTAMs Her Majesty’s Own Kingdom.

I think this shows that Germans like to issue NOTAMs for every BS detail while the Brits have mostly uncontrolled airspace and in general are more relaxed about when to issue a NOTAM.

A NOTAM contains a field called ItemA which is the ICAO identifier of the affecting entity, either airport or FIR. Let’s see what the scores are for FIRs:

select itema, count(*) as count from notams_itema group by itema order by count desc limit 10;
 itema | count 
-------+-------
 EDWW  |   564
 EDGG  |   532
 EPWW  |   527
 LOBA  |   410
 EDMM  |   328
 LIMM  |   256
 LIRR  |   239
 LOWW  |   238
 EFIN  |   228
 EGTT  |   202
(10 rows)

Again, Germany beats the competition by a large margin with Langen and Bremen scoring at the top, only Munich lost to the Warsaw FIR. It’s really important to mention each windmill by name and inform the public that somebody left a chewing gum on the heliport of Boondocks Municipal Hospital.

Now let’s find out how many days in average a NOTAM has been around:

select round(avg(extract(epoch from now()) - startvalidity)/(3600*24)) from notams;
 round 
-------
   205
(1 row)

What’s the average validity duration of NOTAMs in days, ignoring the ones that are marked as PERM?

select round(avg(endvalidity - startvalidity)/(3600*24)) from notams where endvalidity < 2147483647;
 round 
-------
    76
(1 row)

How many NOTAMs in the database will trigger in the future?

select count(*) from notams where startvalidity > extract(epoch from now());
 count 
-------
  5605
(1 row)
Last Edited by achimha at 06 Aug 12:16

fun

I’m not too surprised about France either
do you retrieve them all and store them in your own DB ?

ELLX (Luxembourg), Luxembourg

A good post. Needed some humour today.

I particularly like the security notams that Germany release for each country in the sand pit stating “potentially hazardous situations” . They could be efficient and publish one with applicable countries in it. Or better still recognise that people do, on occasion, turn on the news and don’t need to be reminded before each burger run that there is a war in Syria, Iraq, Iran, Lybia… bongo-bongo land

Oh and the other one I love in Germany, seen it for first time this year, are the “do not overly” notams due to “social events” in force for the summer period. E.g. over Feuchtwangen. I bet a federal politician lives there.

EDHS, Germany

I am certainly no friend of bureaucracy and such like, but if you correlate these numbers with the population density and the density of airports, airways and navaids, then the statistics will look somewhat different.

EDDS - Stuttgart

Germany: 1 NOTAM per 35 000 inhabitants
France: 1 NOTAM per 34 000 inhabitants
UK: 1 NOTAM per 66 000 inhabitants
USA: 1 NOTAM per 86 000 inhabitants

I do see strong statistical evidence here…

It’s a labour market policy to fight unemployment rate ;)

Looks fun!

How long does the data go back for? Would you be able to find out if there was an increase in the “OBSTACLE ERECTED” notams in the UK after the helicopter london incident (16 Jan 2013)?
https://en.wikipedia.org/wiki/Vauxhall_helicopter_crash

My instructor did say that he saw these pop up all over the place of the incident… but had no data to back his claim :)

If you have sleep troubles,you may exercise you brain by deciphering this:

Or,see how precautionary an airport may become ,after litigations for randomly answering PPR requests,in absence of relevant NOTAM !

LGGG

I often wondered about the bizzare opening hours of Greek Airports.

I assumed it was caused by somebody picking up the timetables for this service

and (when they finished laughing at the registration) just creating a slot of 2-3hrs around the ETA/EOBT.

And to hell with anybody else who wants to fly there… which is commercially understandable in a short-term way but not if the staff sit there all day anyway.

On this trip we did 3 small islands: Leros Kalymnos and Ikaria and getting the timetables to line up was pretty hard – especially since one of them gave us duff data (all in the writeup).

We will do the same this September but this time it will be just two islands, one of which will be Milos.

Speaking of notams, what happened to the 1952 Greek/Turkish airspace dispute which used to take up pages of notams for any flight in Greece?

Administrator
Shoreham EGKA, United Kingdom

Did you take into account that in many countries, each NOTAM is published in two languages? If not, that would cut the polish, french or german numbers in half right away as compared to the US or the UK.

BTW, Germany will stop translating NOTAMs next year, if I am correct?

Last Edited by Rwy20 at 07 Aug 16:41
26 Posts
Sign in to add your message

Back to Top