Melbourne, FL
Cancelled registrations · 340
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 = 'MELBOURNE' 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 = 'MELBOURNE' 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.
N201YXMooney M20J · S/N 24-0531N8538BTiffany Dresden P HUMMER-A · S/N 0038AN396FTPiper PA-28-161 · S/N 28-8216215N10153Embraer Executive EMB-500 · S/N 50000286N10200Embraer Executive EMB-500 · S/N 50000306N682XLLiberty Aerospace LIBERTY XL-2 · S/N 0148N676XLLiberty Aerospace LIBERTY XL-2 · S/N 0142N235BWShaw Alan ATLANTICA 235 FG · S/N 001N2875Bloomfield B2P GYROCOPTER · S/N RHB-2N33DZZdunczyk Richard J ZENITH · S/N 2-425N5638NMonocoupe CABURE · S/N 100N8394BPiper PA-28-161 · S/N 28-8116237N472DPiper PA-31-350 · S/N 31-8152017N573XLLiberty Aerospace LIBERTY XL-2 · S/N 0058N574XLLiberty Aerospace LIBERTY XL-2 · S/N 0059N594XLLiberty Aerospace LIBERTY XL-2 · S/N 0064N84476Piper PA-28-161 · S/N 28-8216029N668XLLiberty Aerospace LIBERTY XL-2 · S/N 0135N669XLLiberty Aerospace LIBERTY XL-2 · S/N 0136N663XLLiberty Aerospace LIBERTY XL-2 · S/N 0131N659XLLiberty Aerospace XL-2 · S/N 0128N660XLLiberty Aerospace XL-2 · S/N 0129N661XLLiberty Aerospace XL-2 · S/N 0130N63339Cessna 150M · S/N 15077248N664XLLiberty Aerospace LIBERTY XL-2 · S/N 0132N665XLLiberty Aerospace LIBERTY XL-2 · S/N 0133N667XLLiberty Aerospace LIBERTY XL-2 · S/N 0134N2904XPiper PA-34-200T · S/N 34-7970346N651XLLiberty Aerospace LIBERTY XL-2 · S/N 0121N506BCBeech A36 · S/N E-1024N1329QCessna 150L · S/N 15072629N91DEDavidson H D / Evans A PT-2 · S/N 1127N650XLLiberty Aerospace LIBERTY XL-2 · S/N 0120N655XLLiberty Aerospace LIBERTY XL-2 · S/N 0125N8569EPiper PA-28-140 · S/N 28-7625141N8086FHunter John JETFOX · S/N 062N8086PHunter John JETFOX · S/N 061N613FTPiper PA-28-161 · S/N 2841236N623XLLiberty Aerospace LIBERTY XL-2 · S/N 0095N624XLLiberty Aerospace LIBERTY XL-2 · S/N 0096N620XLLiberty Aerospace LIBERTY XL-2 · S/N 0092N635XLLiberty Aerospace XL-2 · S/N 0106N622XLLiberty Aerospace LIBERTY XL-2 · S/N 0094N21UAUrban Air Sro UFM-13 LAMBADA · S/N 115/13N557XLLiberty Aerospace LIBERTY XL-2 · S/N 0047N612XLLiberty Aerospace LIBERTY XL-2 · S/N 0088N267GTSocata TB-20 TRINIDAD · S/N 2167N640XLLiberty Aerospace XL-2 · S/N 0111N641XLLiberty Aerospace XL-2 · S/N 0112N633XLLiberty Aerospace LIBERTY XL-2 · S/N 0104
Back to Melbourne, FL