Flight BI: Flight Data

U.S. related flight data from Jan 01, 2018 to today


The flight dataset contains all flights tracked by the Federal Aviation Administration (FAA).

This dataset can be used to
– Calculate the market size
– Understand growth by origin airport and market
– Observe traffic patterns by weekday, departure windows, aircraft type, and trip length
– Monitor a carrier’s operations
– Evaluate an airline’s on-time performance
– Benchmark carriers’ performance
– Benchmark airport’s performance
– Study airport congestion
– Track aircraft history

Tables included:
– Flight: all commercial and general aviation flights
– GA_Flight: general aviation flights
– Business_Flight: business aviation flights (turboprop & jet only)

Fields included:
– Origin airport
– Destination airport
– Airline
– Aircraft ID
– Aircraft category
– Seats
– Date
– Gate departure
– Departure time
– Arrival time
– Flight time
– Block time
– Miles of the segment
– 22 additional fields

On top of that, there are 8 more fields are available for the Flight table.

Expected workflow:
– Customers provide subscription months and FlightBI grants permissions during that period
– Customers subscribe to a web application developed by FlightBI then use it to get charts and dashboards of flight data stored in Snowflake

Data sources:
The Federal Aviation Administration (FAA), FlightBI

About the Provider:

Flight BI is a Business Intelligence (BI) solution provider for the global aviation industry. We build data warehouse products and web applications to help airlines, airports, aircraft manufacturers, and other travel-related businesses make data-driven strategic and operational decisions intuitively.

Get access to the Flight BI: Flight Data Listing in Snowflake


Already a Snowflake customer?
Access this listing directly from your Snowflake account.