Home

About the Flight Recorder Database

The Flight Recorder is a personal aircraft spotting logbook application implemented using .NET Core. It has the following components:

Name	GitHub	Comments
FlightRecorderDb	FlightRecorderDb	Business logic, entities and database implementation
FlightRecorder.Api	FlightRecorder.Api	REST API for reading and writing to the database
FlightRecorder.Mvc	FlightRecorder.Mvc	ASP.NET MVC UI for accessing the database via the service

The application provides facilities for recording and querying the following data:

• Sighting details (date, location, aircraft altitude)
• Flight details (route, airline)
• Aircraft details (registration details, manufacturer, model)
• Sightings-based reports

It also provides facilities for exporting sightings and related data and supports external API integration (currently AeroDataBox) for external data lookup.

The database layer supports the following database types:

Type	Purpose
In Memory	In-memory database for transient storage and targetted at unit testing
SQLite	Permanent storage in a SQLite database