You're right !

The air column in the bottleneck act as a one-sideclosed pipe resonator. The peak frequency is the one of the quarter wavelength standing wave.

The formula used is :

Cair = 4 f0 (L + 0,61xD)

I was insired by this paper :

https://aapt.scitation.org/doi/10.1119/1.5145480

And of course, once the bottle is open and some wine has been drunk, one can use the formula of the Helmotz resonnator instead ! May be i will add it in a few days !

Here is a result with a test tube.

The air column in the bottleneck act as a one-sideclosed pipe resonator. The peak frequency is the one of the quarter wavelength standing wave.

The formula used is :

Cair = 4 f0 (L + 0,61xD)

I was insired by this paper :

https://aapt.scitation.org/doi/10.1119/1.5145480

And of course, once the bottle is open and some wine has been drunk, one can use the formula of the Helmotz resonnator instead ! May be i will add it in a few days !

Here is a result with a test tube.