Airport Flight Data Excel Report

Заказчик: AI | Опубликовано: 25.09.2025

I need a clean, ready-to-use Excel workbook that shows every movement in and out of six specified airports over the last 365 days, limited only to these aircraft types: Cessna 210, Cessna 208 caravan, C404, C402, Cessna Conquest, PC-12, Piper Lance. B200 Kingair and B58 Baron. All raw information can be sourced from FlightRadar24 (or another live-tracking tool with comparable historical coverage). Airports in Australia YPDN, YPTN, YBAS, YPGV, YTNK, YPKU For each recorded flight I must have: departure time arrival time (local) aircraft registration Registered operator Please arrange everything by airport—one sheet per field works well—so I can compare activity quickly. Within each sheet, feel free to sort chronologically or add simple filters; the key requirement is that the dataset remains easy to pivot or chart later. If you normally use Python, R, Excel Power Query, or similar scraping/ETL tools, mention it in your proposal so I know how you plan to automate the pull and minimise gaps. Accuracy matters more than speed; I will spot-check against the original tracker before signing off.