Results 1 to 7 of 7

Thread: Flight History based on DEP/ARR Airport

  1. #1
    Passenger
    Join Date
    Sep 2014
    Posts
    3

    Flight History based on DEP/ARR Airport

    Hey Guys, I saw there is an option to see the flight history by date based on flight number or even based on Airline.
    I am looking for an option to see flight history base on Departing Aerodrome and Destination Aerodrome.

    e.g. I want to see all the flight that departed from VTBS to VTSP (all airlines that did this route) on a certain date or in the past month or even in general
    to show me all the flights that did this route.

    how can one do so?

    Thanks.
    Last edited by Akila; 2014-09-02 at 09:59.

  2. #2

  3. #3
    Passenger
    Join Date
    Sep 2014
    Posts
    3
    1st of all thanks for your reply.
    But I don't understand, how does this help?
    you gave me only a Destination APT or a Departure APT.
    not a combination of both. on big airports it could take ages to correlate, especially if I am going few days back in time.
    also I didn't see there the flight history, route history , etc. just the schedule.
    I am looking for Flight history the same you can get by Airline.

    e.g.
    http://www.flightradar24.com/data/fl...k-airways-bkp/
    http://www.flightradar24.com/data/fl...pg274/#41c13f3

  4. #4
    Super Moderator
    Join Date
    May 2011
    Location
    T-NZCH1, PP:PH New Zealand
    Posts
    5,028
    In short you can't. The data used to make the boards/schedules here is imported based on lookups on the flight number the aircraft transmit when in the air. (and only full adsb capable ones at that) The only way is to compare the 2 and correlate. So I gave the direct links to both departure and destination to show both are individually listed as a starting point.

    If you want to know point to point data, You either manually need to match them. Or contact the airlines and ask for their flight numbers used between the ports.

    However if you look at the source of those generated tables the data is pulled from - flightstats.com, they do have a basic to/from lookup.

  5. #5
    Passenger
    Join Date
    Sep 2014
    Posts
    3
    Question.
    if there is an option to search flight history based on flight number like in the links I posted above and the flight history
    has the departing APT and Arrival APT in it, why can't the site have a simple code that can search the DB that one could perform
    a Flight History based on Dep/Arrv or even based only by APT, when FilghtRadar24 has that info already in it's DB?
    Of course I am not expecting on getting results on none ADS-B equipped aircraft(s) that flew that route, etc.
    if it is an SQL Data base, I am more then happy to write the script for you and even the HTML code that calls that SQL Query.
    then you can design the site with this option.
    it is not that complicated as you already have that data.

    here is an example from your site using the "flight history" option of a flight that took place on August 15th.
    as you can see you have the full data in place, including DEP/ARRV Airports and details data like speed , altitude and even the duration of flight.
    it is very easy to create a query of "show me all airlines that departed from BKK and arrived to HKT at august 15th" the data is populated in the DB tables already.

    Last edited by Akila; 2014-09-03 at 06:13.

  6. #6
    Team FR24 Mike's Avatar
    Join Date
    Feb 2010
    Location
    Sweden
    Posts
    3,110
    http://www.flightradar24.com/data/ this is what we are offering today.

  7. #7
    Captain Birdie's Avatar
    Join Date
    Dec 2012
    Location
    Changi Airport
    Posts
    645
    Quote Originally Posted by Mike View Post
    http://www.flightradar24.com/data/ this is what we are offering today.

    Mike, Thanks for the hard work.

    Kindly re-arrange them into Alphabetical order.

    Currently, it is difficult to read and search for the wanted airline - the mind seems to align itself in alphabetical order, LOL.
    F-WSSS1 - Cats refused to Pee & Pooh on RadarBox - Running a FR24 Receiver & DVB-T Dongle 24/7 to piss off The Chief Thief.

Posting Permissions

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