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.

N201YXMooney M20J · S/N 24-0531Cancelled Feb 1, 2013 · Registration expired, pending cancellation · Built 1978 · Hart Richard AN8538BTiffany Dresden P HUMMER-A · S/N 0038ACancelled Jan 30, 2013 · Sale reported, pending cancellation · Built 1981N396FTPiper PA-28-161 · S/N 28-8216215Cancelled Jan 14, 2013 · Sale reported, pending cancellation · Built 1982N10153Embraer Executive EMB-500 · S/N 50000286Cancelled Dec 21, 2012 · Exported to Panama · Embraer Executive Aircraft IncN10200Embraer Executive EMB-500 · S/N 50000306Cancelled Dec 21, 2012 · Embraer Executive Aircraft IncN682XLLiberty Aerospace LIBERTY XL-2 · S/N 0148Cancelled Oct 29, 2012 · Third renewal notice · Liberty Aerospace IncN676XLLiberty Aerospace LIBERTY XL-2 · S/N 0142Cancelled Oct 24, 2012 · Third renewal notice · Liberty Aerospace IncN235BWShaw Alan ATLANTICA 235 FG · S/N 001Cancelled Oct 18, 2012 · Registration expired, pending cancellation · Built 2002 · Shaw G AlanN2875Bloomfield B2P GYROCOPTER · S/N RHB-2Cancelled Sep 24, 2012 · Registration expired, pending cancellation · Bloomfield Robert HN33DZZdunczyk Richard J ZENITH · S/N 2-425Cancelled Sep 10, 2012 · Sale reported, canceledN5638NMonocoupe CABURE · S/N 100Cancelled Aug 27, 2012 · Revoked, canceled · Built 1954 · Monocoupe Aircraft Of Florida InN8394BPiper PA-28-161 · S/N 28-8116237Cancelled Aug 1, 2012 · Built 1981 · Echo Kilo LLCN472DPiper PA-31-350 · S/N 31-8152017Cancelled Sep 7, 2011 · Exported to Canada · Built 1980 · Communications Laboratories IncN573XLLiberty Aerospace LIBERTY XL-2 · S/N 0058Cancelled May 31, 2011 · Exported to Indonesia · Built 2007 · Liberty Aerospace IncN574XLLiberty Aerospace LIBERTY XL-2 · S/N 0059Cancelled May 31, 2011 · Exported to Indonesia · Built 2007 · Liberty Aerospace IncN594XLLiberty Aerospace LIBERTY XL-2 · S/N 0064Cancelled May 31, 2011 · Exported to Indonesia · Built 2007 · Liberty Aerospace IncN84476Piper PA-28-161 · S/N 28-8216029Cancelled Apr 18, 2011 · Built 1981 · Echo Kilo LLCN668XLLiberty Aerospace LIBERTY XL-2 · S/N 0135Cancelled Sep 7, 2010 · Exported to Poland · Built 2010 · Liberty Aerospace IncN669XLLiberty Aerospace LIBERTY XL-2 · S/N 0136Cancelled Sep 7, 2010 · Exported to Poland · Built 2010 · Liberty Aerospace IncN663XLLiberty Aerospace LIBERTY XL-2 · S/N 0131Cancelled Aug 20, 2010 · Exported to China · Liberty Aerospace IncN659XLLiberty Aerospace XL-2 · S/N 0128Cancelled Aug 18, 2010 · Exported to China · Liberty Aerospace IncN660XLLiberty Aerospace XL-2 · S/N 0129Cancelled Aug 18, 2010 · Exported to China · Liberty Aerospace IncN661XLLiberty Aerospace XL-2 · S/N 0130Cancelled Aug 18, 2010 · Exported to China · Liberty Aerospace IncN63339Cessna 150M · S/N 15077248Cancelled Aug 5, 2010 · Exported to Brazil · Built 1975 · Covenant Technologies Group LLCN664XLLiberty Aerospace LIBERTY XL-2 · S/N 0132Cancelled Aug 5, 2010 · Exported to Poland · Liberty Aerospace IncN665XLLiberty Aerospace LIBERTY XL-2 · S/N 0133Cancelled Aug 5, 2010 · Exported to Poland · Liberty Aerospace IncN667XLLiberty Aerospace LIBERTY XL-2 · S/N 0134Cancelled Jul 22, 2010 · Exported to Poland · Built 2010 · Liberty Aerospace IncN2904XPiper PA-34-200T · S/N 34-7970346Cancelled Jul 20, 2010 · Exported to Colombia · Built 1979 · Covenant Technologies Group LLCN651XLLiberty Aerospace LIBERTY XL-2 · S/N 0121Cancelled Jul 9, 2010 · Exported to Japan · Built 2008 · Liberty Aerospace IncN506BCBeech A36 · S/N E-1024Cancelled Apr 13, 2010 · Triennial form not returned · Built 1977 · Blue Heron Aviation Sales LLCN1329QCessna 150L · S/N 15072629Cancelled Mar 23, 2010 · Exported to Peru · Built 1971 · Mannion Dennis MN91DEDavidson H D / Evans A PT-2 · S/N 1127Cancelled Aug 24, 2009 · Triennial form not returned · Davison Harold DN650XLLiberty Aerospace LIBERTY XL-2 · S/N 0120Cancelled Jun 4, 2009 · Exported to Malaysia · Liberty Aerospace IncN655XLLiberty Aerospace LIBERTY XL-2 · S/N 0125Cancelled Jun 4, 2009 · Exported to Malaysia · Liberty Aerospace IncN8569EPiper PA-28-140 · S/N 28-7625141Cancelled May 19, 2009 · Registration revoked · Built 1976 · Barge Tony BaxterN8086FHunter John JETFOX · S/N 062Cancelled May 18, 2009 · Exported to Malaysia · Built 2006 · Berman Anthony JN8086PHunter John JETFOX · S/N 061Cancelled May 18, 2009 · Exported to Malaysia · Built 2006 · Berman Anthony JN613FTPiper PA-28-161 · S/N 2841236Cancelled May 11, 2009 · Built 1989 · F I T Aviation LLCN623XLLiberty Aerospace LIBERTY XL-2 · S/N 0095Cancelled May 6, 2009 · Exported to China · Built 2008 · Liberty Aerospace IncN624XLLiberty Aerospace LIBERTY XL-2 · S/N 0096Cancelled May 6, 2009 · Exported to China · Built 2008 · Liberty Aerospace IncN620XLLiberty Aerospace LIBERTY XL-2 · S/N 0092Cancelled Feb 12, 2009 · Exported to Australia · Built 2007 · Liberty Aerospace IncN635XLLiberty Aerospace XL-2 · S/N 0106Cancelled Feb 12, 2009 · Exported to Australia · Built 2008 · Liberty Aerospace IncN622XLLiberty Aerospace LIBERTY XL-2 · S/N 0094Cancelled Jan 22, 2009 · Exported to Australia · Built 2008 · Liberty Aerospace IncN21UAUrban Air Sro UFM-13 LAMBADA · S/N 115/13Cancelled Jan 14, 2009 · Exported to Costa Rica · Built 2008 · Bostik Industries LLCN557XLLiberty Aerospace LIBERTY XL-2 · S/N 0047Cancelled Nov 13, 2008 · Exported to Germany · Built 2008 · Liberty Aerospace IncN612XLLiberty Aerospace LIBERTY XL-2 · S/N 0088Cancelled Oct 10, 2008 · Exported to Germany · Liberty Aerospace IncN267GTSocata TB-20 TRINIDAD · S/N 2167Cancelled Aug 25, 2008 · Exported to Australia · Built 2002 · Provestment International LLCN640XLLiberty Aerospace XL-2 · S/N 0111Cancelled Jun 24, 2008 · Exported to Australia · Liberty Aerospace IncN641XLLiberty Aerospace XL-2 · S/N 0112Cancelled Jun 24, 2008 · Exported to Australia · Liberty Aerospace IncN633XLLiberty Aerospace LIBERTY XL-2 · S/N 0104Cancelled Apr 18, 2008 · Exported to Australia · Liberty Aerospace Inc
Back to Melbourne, FL