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.
N608ECEmbraer EMB-135BJ · S/N 14501128N979PFEmbraer EMB-135BJ · S/N 14500979N665PFEmbraer EMB-135BJ · S/N 14501165N305PGEmbraer Executive EMB-500 · S/N 50000319N671EEEmbraer EMB-135BJ · S/N 14501171N314PGHewitt R O/Hewitt D O KITFOX IV-1200 · S/N ADU148N558XLLiberty Aerospace LIBERTY XL-2 · S/N 0048N597XLLiberty Aerospace LIBERTY XL-2 · S/N 0076N599XLLiberty Aerospace LIBERTY XL-2 · S/N 0078N677XLLiberty Aerospace LIBERTY XL-2 · S/N 0143N970ECEmbraer EMB-135BJ · S/N 14500970N507XLLiberty Aerospace LIBERTY XL-2 · S/N 0004N509XLLiberty Aerospace LIBERTY XL-2 · S/N 0006N8453PPiper PA-24-250 · S/N 24-3687N750TJBornhofen Bob TWINJET 1500 · S/N 001N2931CPiper PA-34-200T · S/N 34-7970386N28571Grumman American Avn. AA-5B · S/N AA5B0687N40306Guinn Edward T RANS S-12 · S/N 0293377N602FTPiper PA-28-161 · S/N 2841196N505XLLiberty Aerospace LIBERTY XL-2 · S/N 0002N506XLLiberty Aerospace LIBERTY XL-2 · S/N 0003N604FTPiper PA-28-161 · S/N 2841197N612FTPiper PA-28-161 · S/N 2841235N615FTPiper PA-28-161 · S/N 2841238N7784Chepolis William M CHALLENGER II · S/N CH-2-0496-B-1484N683XLLiberty Aerospace LIBERTY XL-2 · S/N 0149N680XLLiberty Aerospace LIBERTY XL-2 · S/N 0146N681XLLiberty Aerospace LIBERTY XL-2 · S/N 0147N684XLLiberty Aerospace LIBERTY XL-2 · S/N 0150N674XLLiberty Aerospace LIBERTY XL-2 · S/N 0140N937DMEmbraer-Empresa Brasileira De EMB-500 · S/N 50000136N120KMcfee E Donald MCFEE SPECIAL · S/N EDF4N678XLLiberty Aerospace LIBERTY XL-2 · S/N 0144N679XLLiberty Aerospace LIBERTY XL-2 · S/N 0145N385FTPiper PA-28-161 · S/N 28-8216214N671XLLiberty Aerospace LIBERTY XL-2 · S/N 0137N673XLLiberty Aerospace LIBERTY XL-2 · S/N 0139N675XLLiberty Aerospace LIBERTY XL-2 · S/N 0141N672XLLiberty Aerospace LIBERTY XL-2 · S/N 0138N2136Aero Commander 520 · S/N 520-119N517XLLiberty Aerospace LIBERTY XL-2 · S/N 0012N275FTPiper PA-28-161 · S/N 28-8216204N8830VBellanca 17-31A · S/N 3244N451FTPiper PA-28-161 · S/N 28-8216220N3518VCessna 150M · S/N 15076532N418FTPiper PA-28-161 · S/N 28-8216217N3719WPiper PA-32-260 · S/N 32-632N5832WPiper PA-28-150 · S/N 28-2153N255EEEmbraer Executive EMB-500 · S/N 50000255N670HTCessna 310F · S/N 3100002
Back to Melbourne, FL