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.
N8121LBell UH-1H · S/N 73-21856N8122EBell UH-1H · S/N 74-22501N201DKAvia ACCORD 201 · S/N A-33-00-005N43RCEmbraer Executive EMB-505 · S/N 50500118N589XLLiberty Aerospace LIBERTY XL-2 · S/N 0073N12328Bell UH-1N · S/N 135117N8239EBell UH-1H · S/N 72-21564N462WRBoeing CH-46E · S/N 156462N808WNBoeing CH-46E · S/N 154808N693AWBoeing CH-46E · S/N 157693N701WNBoeing CH-46E · S/N 157701N860AWBoeing CH-46E · S/N 154860N560EEEmbraer Executive EMB-505 · S/N 50500560N443QSEmbraer Executive EMB-505 · S/N 50500570N4553XPiper PA-34-200T · S/N 34-7670069N8514VAir Tractor AT-802 · S/N 802-0132N709LGPegasus PEGASUS QUANTUM · S/N 7735N735ZYDJI PHANTOM 3 ADVANCED · S/N P76DCI25A26331N410EEEmbraer Executive EMB-500 · S/N 50000410N683WRBoeing CH-46E · S/N 157683N786EPDJI S1000+ · S/N 02Q0020704N469DACirrus Design SR20 · S/N 1745N676EEEmbraer Executive EMB-550 · S/N 55000076N671RPDJI PHANTOM 3 PROFESSION · S/N P76DCE16140146N671TPDJI INSPIRE 1 · S/N W13DCF06040392N668WCBell UH-1H · S/N 73-21668N22762Piper J4 · S/N 4-447N668PADJI PHANTOM 2 VISION + · S/N PH 645 487 159N669PADJI SPREADING WINGS S900 · S/N 0370061880N729ASCessna 337H · S/N 33701938N998ASCessna T337G · S/N P3370289N994AWBoeing CH-46E · S/N 153994N210FTPiper PA-28-161 · S/N 2841208N448WCBell UH-1 · S/N 74-22448N636WWBell UH-1H · S/N 72-21636N637WNBell UH-1H · S/N 7221637N786AWBell UH-1H · S/N 73-21786N276WRBell UH-1V · S/N 70-16276N9198Air Tractor AT-802 · S/N 8020072N545MBEmbraer S A EMB-545 · S/N 55010012N53304Cessna 152 · S/N 15283531N312HHFreefly Systems ALTA · S/N 732473N350EEEmbraer Executive EMB-505 · S/N 50500450N9822TCessna 172A · S/N 47622N451WCBoeing CH-46E · S/N 156451N587XLLiberty Aerospace LIBERTY XL-2 · S/N 0071N650WNBoeing CH-46E · S/N 157650N590XLLiberty Aerospace LIBERTY XL-2 · S/N 0074N15144Piper PA-28R-200 · S/N 28R-7335028N7365QCessna 150L · S/N 15073265
Back to Melbourne, FL