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.
N636XLLiberty Aerospace XL-2 · S/N 0107N630XLLiberty Aerospace LIBERTY XL-2 · S/N 0102N629XLLiberty Aerospace LIBERTY XL-2 · S/N 0101N610XLLiberty Aerospace LIBERTY XL-2 · S/N 0086N616XLLiberty Aerospace LIBERTY XL-2 · S/N 0089N617XLLiberty Aerospace LIBERTY XL-2 · S/N 0090N621XLLiberty Aerospace LIBERTY XL-2 · S/N 0093N625XLLiberty Aerospace LIBERTY XL-2 · S/N 0097N626XLLiberty Aerospace LIBERTY XL-2 · S/N 0098N204XLSTW Composites LIBERTY XL-2 · S/N 0001N606XLLiberty Aerospace LIBERTY XL-2 · S/N 0082N607XLLiberty Aerospace LIBERTY XL-2 · S/N 0083N203XLSTW Composites LIBERTY XL-2 · S/N 0002PN508XLLiberty Aerospace LIBERTY XL-2 · S/N 0005N598XLLiberty Aerospace LIBERTY XL-2 · S/N 0077N580XLLiberty Aerospace LIBERTY XL-2 · S/N 0066N596XLLiberty Aerospace LIBERTY XL-2 · S/N 0065N20956Cessna 172S · S/N 172S9564N584XLLiberty Aerospace LIBERTY XL-2 · S/N 0069N586XLLiberty Aerospace LIBERTY XL-2 · S/N 0070N970BWHughes Helicopters 369FF · S/N 0006FN511XLLiberty Aerospace LIBERTY XL-2 · S/N 0008N551XLLiberty Aerospace LIBERTY XL-2 · S/N 0041N719JMMiller Jon W EXEC 162F · S/N 6155N2355LBeech 23 · S/N M-193N168WAAerospatiale/Aeritalia ATR 42-320 · S/N 168N5503ZBellanca 8KCAB · S/N 419-78N609FTPiper PA-28-161 · S/N 2841219N9817WPiper PA-28-140 · S/N 28-23319N24126Berman Anthony FIRE STAR II · S/N 001N1647JPiper PA-28-140 · S/N 28-24039N948RMBeech 65-A90 · S/N LJ121N83144Piper PA-34-200T · S/N 34-8170071N1178RRaven Industries RX6 · S/N RX6-233N4314YBeech 95-B55 (T42A) · S/N TC1021N7239CCessna TU206G · S/N U20606316N3027PConsolidated Aeronautics LAKE LA-4-200 · S/N 964N861BXBoeing 707-338C · S/N 19293N55QDDriggers Q E 532 COMMANDER ELITE · S/N 1N4115JBoeing 707-338C · S/N 19295N4131GBoeing 707-338C · S/N 19622N6546LBoeing 707-338C · S/N 19296N55589Piper PA-34-200 · S/N 347350230N473FTPiper PA-28-161 · S/N 288216222N84WRRoper William C DRAGONFLY · S/N 375N8938PPiper PA-24-260 · S/N 244394N21693Svehla Barry E CHALLENGER II · S/N CH204890417N78XRCessna R172K · S/N R1722043N9377ZCessna U206G · S/N U20606443N297FTPiper PA-28-161 · S/N 288216206
Back to Melbourne, FL