Winter Garden, FL
Cancelled registrations · 42
Query with SQL
duckdb -csv -c "SELECT d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code WHERE d.registrant_state = 'FL' AND d.registrant_city = 'WINTER GARDEN' ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id"
Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code WHERE d.registrant_state = 'FL' AND d.registrant_city = 'WINTER GARDEN' ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N4TVEurocopter AS 350 B2 · S/N 2936N914HGEurocopter AS 350 B2 · S/N 1924N93DBeech B100 · S/N BE-23N8743ZCessna P206D · S/N P206-0543N1855WBeech 95-B55 (T42A) · S/N TC-1557N97PCPiper PA-31T · S/N 31T-8020034N3339AAerostar International S-66A · S/N S66A-3035N50566Aerostar International AEROSTAR S60H · S/N S60H-3002N7098ZAerostar International RX 8 · S/N RX8-3223N7106FAerostar International RXS-8 · S/N RXS8-3054N6332ZRaven Industries RALLY RX7 · S/N RX7-3238N5277RAerostar International RX-9 · S/N RX9-3019N52507Aerostar International RXS-8 · S/N RXS8-3099N7086WAerostar International RXS-8 · S/N RXS8-3028N612ZKDJI PHANTOM 3 PROFESSION · S/N P77DCE19010325N5163RAerostar International RX-9 · S/N RX9-3018N5230GAerostar International RX-9 · S/N RX9-3024N898TBeech 58 · S/N TH-35N5414QCessna 150L · S/N 15073314N36405Piper PA-34-200T · S/N 34-7870329N2453UPiper PA-28-181 · S/N 28-8090047N4844HCessna 152 · S/N 15283984N436KRTomlinson John L KR2S · S/N 8903436N49919Cessna 152 · S/N 15281393N46059Cessna 152 · S/N 15282991N714QECessna 150M · S/N 15079344N757YECessna 152 · S/N 15280103N9188FAir Tractor AT-401 · S/N 401-0918N8035ZBowersox & Bivens CHRISTEN EAGLE II · S/N 0001N25443Cessna 152 · S/N 15280663N6387VCessna 172RG · S/N 172RG0650N6416VCessna 172RG · S/N 172RG0678N25212Cessna 152 · S/N 15280531N13517Cessna 172M · S/N 17262813N21ESBeech 58 · S/N TH-1123N13018Cessna 172M · S/N 17262447N53947Harris B-8M · S/N 1N4867BCessna 152 · S/N 15283682N1986ZCameron Balloons US V-77 · S/N 5242N9278UCessna 150M · S/N 15078228N38384Piper J3F-65 · S/N 6995N34449Aeronca 65-CA · S/N CA14591
Back to Winter Garden, FL