About

ua-fleet is a public dashboard for browsing and visualizing the United Airlines fleet — every active mainline tail, every retired one back to 2011, and every UAX partner aircraft.

How it's built

• Source data: 11 curator-maintained Excel files, ingested nightly.
• ETL: Python (pandas + openpyxl + psycopg + pydantic).
• Database: Supabase Postgres 17 with RLS for per-user favorites.
• Frontend: Astro static site on Cloudflare Pages.
• Schema: 30 aircraft types × 51 subfleet variants × ~2,725 tails.

What's next

• Per-tail special-livery surfacing (Spirit of UA, Her Art Here, Wrexham, …)
• Polaris mod-location tracking (Xiamen / Hong Kong / Pudong)
• Saved views and email digest of fleet changes

Source: github.com/asfbay-bit/ua-fleet