About This File
Random Flight Database is a program that will allow you, depending on one or more criteria, to choose a flight corresponding to existing flights.
These flights are extracted from a database more than 1,200,00 lines, available in the program. This database is updated in summer 2019.
You also have a user base that will allow you to share your data files (.XLS) between users to add even more choices.
Part of it is also dedicated to importing data from the website: https://developer.flightstats.com/
You must create an account on this site in order to extract (limited to about 6 airports in total for 1 account)
This import is made 7 days from the moment you make this import.
Once this import is done, you can import it directly into your user database and / or export it in XLS format for sharing with other users.
Files are available for free on the org.
The criteria for choosing your flights are:
- Airlines
- Departure airport
- Arrival Airport
- Type of plane
- Day of the week
- Multiple generation (generates a number of flights determined by the user)
- flight time (choice of a flight time interval, minimum flight time <X <maximum flight time, where X is the random flight chosen by the random flight database)
- Continuous (must be associated with Multiple Generation to function, allows to take back the airport of arrival as airport of departure for each generated line)
2 options are also available to choose a random flight from flightradar 24.
If you have any comments or improvements, please contact me.
If you have problems launching the application
go to the folder C\ Program Files\Random Flight Database\
Delete the 2 files concerned BASE_Utilisateur.fic and BASE_Utilisateur.ndx
Run Random Flight Database as an administrator.
For quick update run the shortcut "Check Update Random Flight Database" place on your desktop with the old version
Windows Only
Sorry if the translation is not correct.
I am French and the translation is not finished Google Translate
https://mikoulprostgrandprix.wixsite.com/randomflightdatabase
En Français :
Random Flight Database est un programme qui vous permettra, en fonction d'un ou de plusieurs critères, de choisir un vol correspondant aux vols existants.
Ces vols sont extraits d'une base de données de 1 262 465 lignes, disponibles dans le programme. Cette base de données est actualisée en hiver 2018/2019.
Vous disposez également d'une base d'utilisateurs qui vous permettra de partager vos fichiers de données (.XLS) entre utilisateurs afin d'ajouter encore plus de choix.
Une partie de celle-ci est également dédiée à l'importation de données du site Web: https://developer.flightstats.com/
Vous devez créer un compte sur ce site afin de pouvoir extraire (limité à environ 6 aéroports au total pour 1 compte)
Cette importation est faite à 7 jours à partir du moment où vous effectuez cette importation.
Une fois cette importation effectuée, vous pouvez l'importer directement dans votre base de données d'utilisateurs et / ou l'exporter au format XLS pour le partager avec d'autres utilisateurs.
Les fichiers sont disponibles gratuitement sur l'org.
Les critères de choix de vos vols sont:
- Compagnie
- Aéroport de départ
- Aéroport d'arrivée
- Type d'avion
- Jour de la semaine
- Génération multiple (génère un nombre de vols déterminé par l'utilisateur)
- temps de vol (choix d'un intervalle de temps de vol, temps de vol minimum <X <temps de vol maximum, où X est le vol aléatoire choisi par la base de données de vols aléatoires)
- Continu (doit être associé à Multiple Generation pour fonctionner, permet de reprendre l'aéroport d'arrivée comme aéroport de départ pour chaque ligne générée)
2 options sont également disponibles pour choisir un vol au hasard sur le site flightradar 24.
Si vous avez des commentaires ou des améliorations à apporter, contactez-moi, s'il vous plaît.
Executer Random Flight Database en administrateur
Pour mise à jour rapide executer le raccourci "Check Update Random Flight Database" placer sur votre bureau avec l'ancienne version
Windows Seulement
https://mikoulprostgrandprix.wixsite.com/randomflightdatabasehttps://youtu.be/mgC7q9rpBnA
What's New in Version 2.4.8 See changelog
Released
2.4.8 :
Replace winter by summer 2019:
Air Serbia
easyJet Europe
easyJet Switzerland
easyJet
Icelandair Cargo
Qatar Airways Cargo
Qatar Airways
SAS Scandinavian Airlines
Seaborne Airlines
Silver Airways
Wideroe
2.4.7 :
Replace winter by summer 2019:
Aegean Airlines
Azores Airlines
Belavia
Condor
Euro Atlantic Airways
Nesma Airlines
Olympic Air
Private Wings
Privilege Style
Rhein-Neckar Air
SATA Air Acores
Transavia France
Transavia
TUI Airways UK
TUI fly Netherlands
TUI fly
2.4.6 :
Corrected minor bug
2.4.5 :
Replace winter by summer 2019:
Air Cairo
Avanti Air
BA CityFlyer
Bluebird Airways
British Airways
Ellinair
La Compagnie
Sundair
2.4.4 :
Replace winter by summer 2019:
SalamAir
Scoot
SilkAir
Singapore Airlines Cargo
Singapore Airlines
Vistara
2.4.3 :
Replace winter by summer 2019:
Braathens Regional Airlines
Middle East Airlines
Air Burkina
Air Transat
AlMasria Universal Airlines
Royal Air Philippines
2.4.1:
Replace winter by summer 2019:
Jet2.com
Nouvelair
2.4.0 :
Optimization of the code performed. Precious seconds of winning.
In the "Random Flight Database" window :
All lists interact with each other.
Passing green color of the lists to validate the choice
New combinations available
Replace winter by summer 2019:
Air Marshall Islands
Air North
Air Tahiti Nui
Arkia Israeli Airlines
Blue Air
Corendon Airlines Europe
Corendon Airlines
Corendon Dutch Airlines
El Al Israel Airlines
Ernest
Gulf Air
Israir Airlines
Laudamotion
Ryanair Operations
Ryanair Sun
Ryanair
Satena
2.3.9 :
Correction bug User database with ICEAITRAFFIC
Bug fix with user base
Reactivate the database you want to use
Delete in application folder :
- BASE_Utilisateur.fic
- BASE_Utilisateur.ndx
In the future :
Code optimization
Continuing updating of summer schedules in the internal database
2.3.7 :
Replace winter by summer 2019 :
Air Malta
American Airlines
American Eagle
Chair Airlines
Delta Air Lines
Delta Connection
Ifly Airlines
Southwest Airlines
Tailwind Airlines
United Airlines
United Express
2.3.6 :
Replace winter by summer 2019 :
JetSmart Argentina
JetSmart
Volaris Costa Rica
Volaris
2.3.5 :
Replace winter by summer 2019 :
Cabo Verde Airlines
Icelandair
Nesma Airlines
Add :
Creating multiple user databases with name input
Changing the active user base in:
Random Flight Database
User base
In Extraction of scheduled flights and random choice in the list:
Export to the base of your choice
In User Base
Import XLS file to the database of your choice
Current base of a green color
2.3.4 :
Replace winter by summer 2019 :
Albawings
AMC Aviation Poland
Badr Airlines
Blue Panorama Airlines
Bulgaria Air
Bulgarian Air Charter
Ruili Airlines
TAROM
Wizz Air UK
Wizz Air
2.3.3 :
Replace winter by summer 2019 :
UPS Airlines
Volotea
2.3.2 :
Replace winter by summer 2019 :
Eritrean Airlines
2.3.1 :
Replace winter by summer 2019 :
Air Moldova
Albastar
ASL Airlines France
Freebird Airlines Europe
Freebird Airlines
2.3.0 :
Replace winter by summer 2019 :
Air Do
Alaska Airlines
All Nippon Airways
Amakusa Airlines
ANA Cargo
ANA Wings
FlyOne
Ibex Airlines
Peach Aviation
PenAir
Skymark Airlines
Solaseed Air
Starflyer
TAP Air Portugal
TAP Express
TUI fly Belgium
Vanilla Air
Wamos Air
2.2.9 :
Replace winter by summer 2019 :
Allegiant Airlines
2.2.8 :
Added in "Extraction of scheduled flights and random choice in the list" :
- search entry box
Added in "Random Flight Database"
- Search ICAO
2.2.7 :
Added in "Extraction of scheduled flights and random choice in the list" :
- Flight Aware Live Airline (Longest Extraction, Extraction of flights in progress, No Codeshare Preview)
- Flight Aware Live Aircraft (Longest Extraction, Extraction of flights in progress, No Codeshare Preview)
2.2.6 :
Replace winter by summer 2019 :
Evelop Airlines
Neos
Orbest
Added Check Update on startup
2.2.5 :
Replace winter by summer 2019 :
Cyprus Airways
Flyadeal
Flynas
Frontier Airlines
GetJet Airlines
Saudia Cargo
Saudia
SkyUp Airlines
Uzbekistan Airways Cargo
Uzbekistan Airways
Improved code for extracting data from Flightpedia and FlightAware sites
Added in "Extraction of scheduled flights and random choice in the list" :
- Flight Aware Departure (Longest Extraction, 3 Day Extraction, No Codeshare Extract)
- Flight Aware Departure (Longest Extraction, Last Week's Flight Extraction, No Codeshare Preview)
- Flight Aware Arrival (Longest Extraction, 3 Day Extraction, No Codeshare Extract)
- Flight Aware Arrival (Longest Extraction, Last Week's Flight Extraction, No Codeshare Preview)
2.2.2 :
Added Flight Aware extraction last week on 7 days in "Extraction of scheduled flights and random choice in the list"
2.2.1 :
Replace winter by summer 2019 :
Air Bucharest
Air Cote d'Ivoire
Air Greenland
My Way Airlines
Plus Ultra
Wings of Lebanon
Bug fix merging files when opening RFD
Added Flight Aware in "Extraction of scheduled flights and random choice in the list"
Add in "About" :
Website button
Button to find all my downloads
Correction Check Update Bug
2.2.0 :
Replace winter by summer 2019 :
Air Djibouti
Air Senegal
Arik Air
Bek Air
China Express Airlines
Hawaiian Airlines
Ibom Air
Interjet
Luxair
Ohanaby Hawaiian
Passion Air
Qingdao Airlines
Spirit Airlines
2.1.9:
Correction bug import xlsx in user database
Add summer 2019 :
Armenia Airways
EZ Air
Fly All Ways Spring 2019
FlyArystan
Ibom Air
Skyaviatrans
2.1.7 :
Add Shortcut Check update for simply update version.
2.1.3 :
- Extraction of scheduled flights and random choice in the list:
2 extraction websites of the day's timetable for the chosen airport (Flightstats or Flightpedia)
Add User Base button (to add extractions to the User database)
Export to Excel button (to allow you to share your extractions with other users)
- User base:
Addition of a box allowing to replace by batch the names of the aircraft types with the same names as the default database or the Aircraft database.
Possibilities to select multiple rows in the table and no longer one. This allows you to delete multiple lines at a time.
- Random flight database:
If only one option is checked (Company or ICAO DEP or ICAO ARR or Airplanes or Days) or the combination thereof with batch generation:
Ability to do a random search on part of the word entered in the text boxes. (Request sql before "=", now "Like% xxxxxx%")
Example:
I selected ICAO DEP, in the box I enter "LF" only. The random result will be on all airports containing "LF".
I selected Airline and batch generation, in the box Airline I enter "Air" only. The random choice will be on all Airlines containing "Air" in their names and will display the number of lines chosen.
2.1.2 :
- Update database with summer 2019 for :
Air Albania
Air Baltic
Air Horizont
Bahamasair
Citilink
Eastar Jet
Fly Egypt
Garuda Indonesia
Jeju Air
Montenegro Airlines
NAM Air
SCAT Airlines
Silk Way Airlines
Silk Way West Airlines
Sriwijaya Air
T'Way Air
TransNusa
TUIfly Nordic
Ukraine International Airlines
Windrose Airlines
- Add windows Airport extraction of your choice in real time over 3 hours (Beta)
2.1.1 :
- Correction version number
- Correction compilation
2.1.0 :
- Update database with summer 2019 for :
Africa's Connection STP
Air Bridge Cargo
Air Busan
Air Iceland Connect
Air Kiribati
Air Leap
Air Seoul
Air St. Kitts & Nevis
Air Tetiaroa
Air Travel
Airwing
Alliance Airlines
Aloha Air Cargo
Alsie Express
Asiana Airlines Cargo
Asiana Airlines
Atlantic Airways
ATRAN
Bamboo Airways
Bhutan Airlines
CargoLogicAir
Cargolux Italia
Cargolux
Copenhagen Air Taxi
Cyprus Airways
DHL Aero Expreso
Donghai Airlines
Druk Air
Enter Air
FedEx Express
Fleet Air International
Fly Baghdad
FlyBosnia
FlyPelican
Golden Myanmar Airlines
Great Dane Airlines
Jettime
Korea Express Air
Maersk
Maximus Air Cargo
Northern Air Cargo
Novair
NovoAir
Proflight Zambia
Qantas
Qantaslink
Qazaq Air
Raya Airways
Real Tonga Airline
SaudiGulf Airlines
Sepehran Airlines
Sky Airline Peru
Sky Airline
Somon Air
Talofa Airways
Tibet Airlines
Tigerair Australia
Tus Airways
Vensecar Internacional
Virgin Australia Cargo
Virgin Australia Regional
Virgin Australia
Viva Aerobus
- Deleting duplicate in default database
- improved loading time for first opening or when adding / deleting data in the user database (before 352 sec on HDD / now 203 sec on HDD)
- deleting 7z and zip files. Only the exe remains because easier for the user during updates