Flight Number Query

[Canonjohns40D]

The Yahoo SbS group has the following comment

I've been noticing some discrepancies with some logs, specifically with
the flight numbers. For example:
 From Middlesborough:
 80043D JAI229 VT-JWP A332 39025 34700 22/03/2009 05:26:43
 But from Bangor:
80043D JAI228 VT-JWP ... Jet Airways 2009/03/22 05:29:25

In fact the Bangor source seems to be showing up more different flight
 numbers than the other sources, but I emphasise I have not checked other
 sources....the only thing I do really notice is that Bangor uses AirNav,
whereas Middlesborough and all the other ones I cross checked this
registration against, used SBS-1.

 Does this mean that AirNav could be 'mis-translating' flight numbers?

I am the Bangor source referred to. Any thoughts on this is my information accurate?

[Canonjohns40D]

And this one posted same site.

From: [email protected] [mailto:[email protected]] On Behalf Of
Steve Kelly
Sent: 23 March 2009 20:41
To: [email protected]
Subject: RE: [Mode_S] Flight number query

The aircraft doesn't need to overfly, it could be 200 miles south of
Middlesbrough and still be received. That particular report looks plausible.

What 'may' be happening with Bagnor is the database has the previous days
flight number in memory and simply allocates that. I think PP does/or did
something similar on first contact, before changing to the correct callsign
once received live. (The callsign doesn't always appear immediately.) This
aircraft seems to alternate JAI229/230 on alternate days which seems to
support this reasoning.

It will be interesting to see what 23/03/09 JAI229 80043A gets picked up as
in today's reports. I'll predict Middlesbrough has JAI229 and Bagnor has
JAI230

Wrong

I had this:

Hi

The Bangor log for 23/3/09 shows

80043A as JAI226 VT-JWL A330-202

Start 5.24.27at N55.24.6 W007.38.7

End 5.34.05 at N54.52.8 W005.05.0

What is happening, any thoughts?

John

[AirNav Support]

Its not mistranslating flight numbers.

RB in the logs only shows one flight per aircraft. So if an aircraft did BAW123 and BAW124 on the way back. It will only show one of them on the report log (can't remember off by heart whether its first or last one)

Customers have requested to have the all flights as well in the next version which we hope to do.

[Canonjohns40D]

Thanks Airnav I thought it was rich the opposition assuming it was the Radarbox which was wrong. I look forward to the new version when it's released. This tool still rocks for any aviation enthusiast.

John

[jgrloit]

If you look in Mylog you will see against the Aircraft ALL flights that it has been seen operating.

Maybe a change in the log script could produce ALL flights seen on the reporting day!!!

[tarbat]

See http://www.airnavsystems.com/forum/index.php?topic=2190.msg18924#msg18924

Using the scripts provided in that thread, you'll get all the Flight IDs for the day.  Example attached.

[Canonjohns40D]

Cheers guys I'll give this a go. here is the latest tfrom the other site

Today was a "Follow my leader" day, as shown below, picked up from
Chelmsford, Essex:-

JAI226 09.54.16-10.08.41, 51.50-51.66, 279.9-275.1 (roughly west) VT-JWQ
JAI228 09.59.59-10.12.40, 51.47-51.20, 282-251.2 (roughly wnw-wsw)
VT-JWK
JAI230 09.51.56-10.05.48, 51.49-51.65, 272-274.7 (roughly west) VT-JWP


> My log for 23/3/09 shows
>
> 80043A as JAI226 VT-JWL A330-202
>
> Start 5.24.27at N55.24.6 W007.38.7
>
> End 5.34.05 at N54.52.8 W005.05.0
>
>
>
> Any thoughts?

[Canonjohns40D]

Hi the discussion continues

And looking at KjM's, combined SBS & AirNav logs, you can see loads of
errors in the flight numbers....So, is it SBS-1 or AirNav that's causing
the problem?

Whomever it is, needs to sort out the bug in their software at
once...after all they are charging big bucks for something that does not
work! Besides, the other company works fine, so it shows it is possible.

Alexis

Alan Cooper wrote:
> Hi All
> Looking at the few logs that have appeared so far this evening for
> today(23/3/09),
> JA1226,228 and 230 were operated by VT-JWQ,K and P respectively.
> This is what three SBS logs from Southend,Romford and South Cheshire shows.
> It is also what ACARSD shows.
> However a Radarbox log from East Devon shows VT-JWK and JWQ operated JAI228.
> Is there a Radarbox problem?
> More logs later and tomorrow may reinforce this theory.
> I didn't switch my machine (SBS) on until 1200 today so can't add my log for
> comparison.

[jgrloit]

Suspect that the flight numbers are sort key order differences.
If you run the ALL flights scripts - you should see ALL flights on the day by aircraft.
The problem occurs when you only give one flight per day per aircraft - do you choose the first or the last, what happens if there is more than one return flight?

[tarbat]

Its already been explained that the log from Radarbox doesn't show all the flight numbers from that day.  What it shows is only the first Flight ID from that aircraft.

The scripts I posted earlier correct this error, and show all the Flight IDs used that day.  If someone explains what layout/format they need this in for the Yahoo SBS group, I'll modify the script to provide what you need.  It currently produces this - http://www.tarbat.gofreeserve.com/data.html

So, on that report, look at G-EUPW.  The report in Radarbox just shows Flight Id SHT18C.  But my new scripted report shows Flight IDs SHT19U at 10:15am, SHT18C at 14:13pm, SHT19A at 15:57pm, SHT18V at 19:00pm, and SHT19W at 20:25pm.

Hopefully v2.10 will fix this.

SQL used for this report:

SELECT DISTINCT 
  Aircraft.Registration AS "Reg",
  Flights.Callsign AS "Flight ID",
  Flights.Route AS "Route",
  Aircraft.AircraftTypeSmall AS "ICAO Type",
  Aircraft.Airline AS "Airline",
  Aircraft.AircraftTypeLong AS "Aircraft",
  substr(Flights.EndTime,1,16) AS "Flight Ended",
  Aircraft.ModeS AS "Mode S"
FROM
 Aircraft
 LEFT OUTER JOIN Flights ON (Aircraft.ModeS=Flights.ModeS)
WHERE
  ((date('now','-1 day') = substr(Aircraft.LastTime,1,4)||"-"||substr(Aircraft.LastTime,6,2)||"-"||substr(Aircraft.LastTime,9,2)) AND 
  (Flights.StartTime IS NULL)) OR 
  ((date('now','-1 day') = substr(Flights.EndTime,1,4)||"-"||substr(Flights.EndTime,6,2)||"-"||substr(Flights.EndTime,9,2)))
ORDER BY
  Aircraft.Registration,
  Flights.EndTime,
  Aircraft.ModeS

[Canonjohns40D]

HI Tarbat I'm running your script for my own purposes and it works well. I have decided to withold my reports from the other group at least until V2.10 kicks in.

John

[Jollygreen]

Tarbat .. have amended the sql to include Start & End Position so as to determine direction since I cannot see how to extract Heading from the underlying data. When I look at the new output report I can see some flights appearing several times. An example is UAE39 from yesterday 24th March.

It shows Start / End Pos of N51 23.3 E002 12.0 N51 45.1 W000 07.3  with an end time of 11.30.

it also shows a Start / End Pos of N51 21.7 E002 16.0 N51 45.1 W000 07.3 . Also with an end time of 11.30.

Any help appreciated as  original extract from RB Reporter has grown from 765 aircraft listed to over 1200.

MTIA Nigel, based in Chelmsford

[tarbat]

Adding start/end positions will give duplicates, particularly if the flight had a gap in coverage, or if your PC has been in standby, for example.  That's why I excluded start/end positions in the first place.  Is that something the Yahoo SBS group requires?  If so, you could try increasing your timeout settings in Radarbox to stop new flight records being started when coverage is lost.

What format listing do you need for posting in the Yahoo SBS group?

[Jollygreen]

Thanks for the reply Tarbat. It is not for any group posting more for my own records as the SQL returns the correct flight data.

Nigel

[jgrloit]

If you need to loose the extra lines.  you could use an old DOS sort that would delete duplicate records.
You would probably want to sort descending on :-
Mode-S, Flight, End-Time, Start-time
then Sort ascending on :-
Mode-S, Flight, End-Time
If used on files without headers the second sort would drop the earlier start-time records.
Mail me if you need the Sort, as I will have to locate it on the old BBS system!!! where I used it in various batch files.