This small nodejs application takes a ForeFlight or Garmin Pilot logbook CSV export, and along with the FAA database of airports, performs the data processing necessary to translate it into a CSV for use on kepler.gl for mapping.

The code presently only works for US-based airports, as I am using an FAA sourced airport lookup table.

• Node.js v15 or greater
• FAA Airport Database from FAA Open Data - https://adds-faa.opendata.arcgis.com
• One of:
  • ForeFlight Logbook CSV Export - you can get this from your personal portal at https://plan.foreflight.com.
  • Garmin Pilot Logbook CSV Export - you can get this from your FlyGarmin portal under the Setup | Export to Spreadsheet button at https://fly.garmin.com/fly-garmin/logbook/#/setup.

• (optional) Update the USA airport database at data/airports.csv directory with the latest version from the FAA.
• Place your exported logbook as data/logbook.csv in the data directory.
• Run npm install to install dependencies.
• Execute node main.js.
• Take the out.csv that was generated and import at kepler.gl.
• Adjust map styles and such as required.

"Fun Mode" - open this project in Visual Studio Code with the Geo Data Viewer Extension, select your out.csv file, and view the map from directly inside VSCode.

• Only available for US Airports
• The script right now depends on a particular format for the "Route" field which I look for spaces or dashes between waypoints. It does a best-case lookup to see if there's an airport match for an identifier. If a VOR and ID match (i.e. CTY VOR, CTY Airport), the script can't tell if it's the VOR or you landed there. I may update this later to require some delimiter like MyFlightBook.com does.

ForeFlight is a trademark of the Boeing company. There is no connection between this app and the ForeFlight application or company. I am just a big fan and user that depends on the great software they make to ensure the safety of myself and my passengers when we fly. Thank you to the whole ForeFlight team for making such a great application! Please visit them at foreflight.com, buy their software, and get out and fly!

Garmin Pilot is a trademark of Garmin and again, there is no connection between the app and that awesome team. A fellow pilot encouraged me to adapt the code to work for their logbooks as well, and I was happy to. EFB's make flying safer and easier. Go out and get the one that works best for you!

Please see the LICENSE file in this repository for details.

Contributions are welcome and encouraged. This was a fun project to create. I am sure there are others out there who can do it better. Please submit pull requests and improve it for everyone!