Page 11 of 12 FirstFirst ... 9101112 LastLast
Results 101 to 110 of 111

Thread: Discussion about Flightradar24 database

  1. #101
    Super Moderator
    Join Date
    May 2011
    Location
    T-NZCH1, PP:PH New Zealand
    Posts
    4,890
    Don't think we can make the assumption it's built on Reg without seeing the background architecture. (and likely being laughed at for doing so)

    I can think of a way where a non indexed/not-unique key could be looked up using joins to produce apparent bad data in a produced output table. For instance...

    dbasemaybe.JPG

    If you had 2 current tables merging the stored and live data with unique key, searchable on all aspects, and you look for REG, chances are you get as good as it comes in current form. But if that also did a lookup for associated HEX OR registration. And then further historic join lookups for same record

    One badly written from/group statement. Boom. The 'current' results you get are not from a single line but merged data of varied age and potentially duplicate/over-lapped

    I've done it in error on my daily log table by using group by instead of most recent and so on. Big ol mashup of old vs new records leaving a head scratch


    Guess the point is, we may never know.
    Posts not to be taken as official support representation - Just a helpful uploader who tinkers

  2. #102
    Passenger
    Join Date
    Apr 2019
    Posts
    2
    I'm doing research on predicting fuel consumption and flight delay length using some machine learning techniques. My professor suggested I should take a look on flightradar24.com but I cannot find historic data like from 2010-2017 about air flight information like (when, where, number of passenger, type of plane, age of plan ... weather ...) how can I obtain these information ? (I heard from professor that we have to pay for a fee to get these information, it's ok, the problem is data, the cost is not a problem). Thanks, hope some one guide me a little bit.

  3. #103
    Super Moderator
    Join Date
    May 2011
    Location
    T-NZCH1, PP:PH New Zealand
    Posts
    4,890
    Quote Originally Posted by chickensoup View Post
    I'm doing research on predicting fuel consumption and flight delay length using some machine learning techniques. My professor suggested I should take a look on flightradar24.com but I cannot find historic data like from 2010-2017 about air flight information like (when, where, number of passenger, type of plane, age of plan ... weather ...) how can I obtain these information ? (I heard from professor that we have to pay for a fee to get these information, it's ok, the problem is data, the cost is not a problem). Thanks, hope some one guide me a little bit.
    The database for historical logging only really took off after 2012 I think. And for the most part only stretches 365 days

    https://www.flightradar24.com/premium/

    Sent from my EML-L09 using Tapatalk
    Posts not to be taken as official support representation - Just a helpful uploader who tinkers

  4. #104
    Passenger
    Join Date
    Apr 2019
    Posts
    2
    Thank you very much

  5. #105
    Super Moderator
    Join Date
    May 2011
    Location
    T-NZCH1, PP:PH New Zealand
    Posts
    4,890
    Got bored.
    So - Slight improvement to my code to detect HEX out of normal expected range

    (after a few hrs of frustration attempting to flag 0/Null values which ended up as simple as reporting when the 'Country' was blank..)

    http://hexlookup.epizy.com/hex.php?search=CBA9A9 (an addition someone posted with Spanish EC- reg)

    Decodes to binary, flips 1/0s. Converts back to hexadecimal and gives the suggested alternate it *SHOULD* be

    Vs good result. Which does conversions still, but hides the alternates

    http://hexlookup.epizy.com/hex.php?search=345656

    /edit and I just noticed a spelling mistake and it gets server issues
    Last edited by Oblivian; 2019-04-19 at 10:11.
    Posts not to be taken as official support representation - Just a helpful uploader who tinkers

  6. #106
    Captain
    Join Date
    Nov 2011
    Location
    Vergiate Italy
    Posts
    3,462
    To the person that makes decisions

    Remember how you lost lots of Chinese uploaders because of military aircraft and we lost the MLAT facility? Well the good news is that China has started equipping its military aircraft with upgraded transponders and they are now visible on FR24 again Variflight sensibly blocks these codes so they don't appear. Maybe FR24 should keep up too?

  7. #107
    Passenger
    Join Date
    Feb 2019
    Posts
    4
    AEL101, AEL107 callsigns are helicopters (206's) not airplanes, can you please change the icon to match

  8. #108
    Captain
    Join Date
    Feb 2013
    Posts
    5,715
    Just having a look at the tie up 7CFA6A A23-053. Its curious because the PC9 codes appear to range from 7CFA37 - 7CFA70.
    7CFA34 is the last of the BE350's
    7CFA71 is the first of the Falcon 700.

    That makes for 58 codes for PC9 aircraft and as I understand it there are currently 58 aircraft. From the original 67 aircraft 3 have crashed
    and 6 have been sold off. If you list each aircraft with what you would expect to be its code. ie 1st aircraft and 1st code, then 7CFA6A should
    be A23-058. Now I am not saying that its wrong just that it does not appear to tie up. I gave up trying to sort these PC9's out some time
    back and since they are soon to be withdrawn didn't think they were worth worrying about

    Chrs

  9. #109
    Flight attendant
    Join Date
    Apr 2018
    Posts
    67
    Cant be 100% sure, i pulled hex from my ADSB then cross checked with https://www.live-military-mode-s.eu/...p?DGCountry=AU which gave aircraft type. Then had results returned from hex search from https://www.radarbox24.com/data/regi...053#1301649309 which gave Registration. Cross checked Registration/Serial on http://www.adf-serials.com.au/3a23.htm.

    Would line up correctly if 7CFA43, A23-013, PC9 is correct but you cant be totally sure.

    Would be happy with just icon amended from unknown to just aircraft type.

    Same applies with the Returned results for HAWKS.

    Hex from my ADSB then cross checked with https://www.live-military-mode-s.eu/...p?DGCountry=AU which gave aircraft type.

    Hex checked online and results also returned from https://www.radarbox24.com/data/mode-s/7CF856 then
    Cross checked on http://www.adf-serials.com.au/3a27.htm

    I am unsure if Serial is Const/No. DT12 or RAF serial which is not listed for this aircraft.

    Let me know as i have another 4 hawks details to add if they are correct.

    Cheers
    Coxy

  10. #110
    Captain
    Join Date
    Feb 2013
    Posts
    5,715
    As I said there are 58 aircraft and 58 codes for PC9 aircraft.
    I don't believe any of these following aircraft were allocated
    codes as they had either crashed or had been withdrawn from
    service prior to the decision to fit ADSB equipment to the aircraft.


    If you removed these aircraft from the list
    A23-004 Sold
    A23-029 Crashed
    A23-035 Crashed
    A23-039 Crashed
    A23-043 Sold
    A23-055 Sold
    A23-059 Sold
    A23-066 Sold
    A23-067 Sold
    Then list the remaining 58 against the 58 codes you get:

    7CFA43 A23-014
    7CFA6A A23-058

    This of course assumes that the first code is 7CFA37 and the last
    7CFA70.

    I can't reconcile the hawks as I have 32 codes and 33 aircraft. So its not possible
    to be certain of the code allocations. Hawk serials run from A27-001 to A27-034 however
    A27-025 was a test frame only leaving 33 aircraft.
    You are correct the with the serial numbers they are DT01 through DT34

    7CF83B is the last of the C130J aircraft

    7CF83C should be first hawk A27-001

    7CF856 should be hawk A27-028 not A27-012

    7CF85B should be A27-033
    7CF85C should be last hawk A27-034 however

    7CF85C is BBJ A36-001

    Good luck with it.

    chrs

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •