wv-gov-flights 🏛️🛩️

a website (built w/ Next.js (v15)) to display trip, passenger, and invoice data from a SQLite(3) database in an enriched way -- with support for basic text searches and recorded flight path visualizations using Leaflet -- of aircraft owned & operated by the State of West Virginia's Aviation Division

https://wv-gov-flights.pages.dev

License

This project is released into the public domain via Creative Commons Zero. See the LICENSE file.

Questions & Comments

See the Frequently Asked Questions in the repo wiki. Public questions & comments also available via email mailing list at ~abs/[email protected].

Data

Information has been sourced from public records and legal requests made under W.Va. Code § 29B-1-1 (WVFOIA)). The intent is to keep the database updated on a semiannual basis as information is released.

Current data includes 2,031 trips spanning from Jan 7, 2017 to Apr 1, 2025 totaling 5,831 flight hours. See data/schema.sql for the database schema.

trips by aircraft

tail_no total_trips min_date max_date N1WV 394 2017-01-13 2025-04-01 N2WV 44 2017-01-31 2021-05-05 N3WV 520 2017-02-03 2025-02-25 N5WV 338 2017-01-11 2024-06-14 N6WV 296 2017-02-10 2025-04-01 N890SP 281 2017-01-07 2025-03-21 N895SP 158 2018-06-18 2024-11-18 View SQL Query ```sql SELECT tail_no, COUNT(*) AS total_trips, MIN(date) AS min_date, MAX(date) AS max_date FROM trips GROUP BY tail_no ORDER BY tail_no ASC, total_trips DESC ``` </details>