Skip to content

SQLite-based aircraft sightings logbook implemented in C# with separate REST API and ASP.NET MVC UI

License

Notifications You must be signed in to change notification settings

davewalker5/FlightRecorder

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

FlightRecorder

Build Status GitHub issues Coverage Status Releases License: MIT Language Language GitHub code size in bytes

About

FlightRecorder implements a SQL-based aircraft sightings logbook. An ASP.NET WebAPI provides access to the business logic and data access layer while an ASP.NET MVC UI provides the user interface.

Sightings

Each sighting consists of the following data:

  • Flight details
    • Flight number
    • Embarkation airport IATA code
    • Destination IATA code
    • Airline
  • Aircraft details
    • Registration details
    • Manufacturer
    • Model
  • Sighting details
    • Date
    • Altitude when sighted
    • Location

A register of airport codes by country is used to validate airport IATA codes.

Search

Sightings may be searched by:

  • Route, specified as airport IATA codes
  • Flight number
  • Airline name
  • Aircraft registration number
  • Date

Reporting

The following reports can be generated and exported to CSV format files:

  • Airline statistics
  • Flights by month
  • Location statistics
  • Manufacturer statistics
  • Aircraft model statistics

Data Export

The following data can be exported in CSV format:

  • Sightings
  • Airport code and country list

Getting Started

Please see the Wiki for configuration details and the user guide.

Authors

  • Dave Walker - Initial work

Credits

Implementation of authentication using JWT in the REST API is based on the following tutorial:

The Flight Recorder MVC project uses the Gijgo JavaScript controls library:

Feedback

To file issues or suggestions, please use the Issues page for this project on GitHub.

License

This project is licensed under the MIT License - see the LICENSE file for details