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.

N8430HPiper PA-32R-301T · S/N 32R8129099Cancelled May 16, 1991 · Exported to Luxembourg · Atlantic Aircraft Sales IncN253FTPiper PA-28-161 · S/N 288216202Cancelled May 8, 1991 · Exported to United Kingdom · Florida Institute Of TechnologyN429FTPiper PA-28-161 · S/N 288216218Cancelled May 8, 1991 · Exported to United Kingdom · Florida Institute Of TechnologyN73699Cessna T337C · S/N 3370815Cancelled Apr 26, 1991 · Triennial form not returned · Evonetics IncN49PPost Russell H MONI MOTORGLIDER · S/N 34Cancelled Aug 24, 1986 · Second triennial mailing, no response · Post Russell HN38729Piper PA-28-140 · S/N 28-7725253Cancelled Dec 23, 1981 · F I T Aviation IncN56731Piper PA-28-140 · S/N 28-7425027Cancelled Nov 23, 1981 · Florida Institute Of TechnologyN31115Ingham GYROCAT-II · S/N 1Cancelled Oct 13, 1981 · Ingham Jerry ON8971LGrumman American Avn. AA-1B · S/N AA-1B-0421Cancelled Oct 10, 1980 · Sebastian Communication IncN207DMMunroe Daryl E QUICKIE · S/N 207Cancelled Oct 2, 1980 · Built 1980 · Munroe Daryl EN11508Beech TC-45J · S/N 029661Cancelled May 5, 1975 · Florida Institute Of TechnologyN5930JCessna A150L · S/N A1500230Cancelled Apr 5, 1974 · Melbourne Aviation IncN5296SPiper PA-28-140 · S/N 2826944Cancelled Mar 14, 1974 · F I T Avaition IncN6086GCessna 150K · S/N 150-71586Cancelled Dec 10, 1973 · Melbourne Aviation IncN22306Cessna 150H · S/N 15068206Cancelled May 29, 1973 · Mclaughlin Martin JN15069Piper PA-32-300 · S/N 32-7340008Cancelled Nov 1, 1972 · Exported to Kenya · Air Convoy IncN4586TPiper PA-34-200 · S/N 34-7250109Cancelled May 15, 1972 · Exported to Kenya · Air Convoy IncN4462TPiper PA-34-200 · S/N 34-7250101Cancelled Apr 19, 1972 · Exported to Kenya · Air Convoy IncN4582TPiper PA-28-180 · S/N 28-7205188Cancelled Apr 12, 1972 · Exported to Kenya · Built 1972 · Air Convoy IncN4385TPiper PA-32-300 · S/N 32-7240074Cancelled Apr 5, 1972 · Exported to Kenya · Air Convoy IncN4960SBensen B-8M · S/N RHB-1Cancelled Dec 7, 1971 · Bloomfield Robert HN14130Piper PA-23-250 · S/N 27-4698Cancelled Nov 22, 1971 · Exported to Kenya · Built 1971 · Air Convoy IncN1976TPiper PA-28-235 · S/N 28-7110025Cancelled Nov 16, 1971 · Exported to Kenya · Air Convoy IncN2704UCessna 172D · S/N 17250304Cancelled Oct 13, 1971 · Iba RobertN14049Piper PA-23-250 (6PCLM) · S/N 27-4661Cancelled Jul 21, 1971 · Exported to Kenya · Air Convoy IncN14022Piper PA-23-250 (6PCLM) · S/N 27-4635Cancelled May 26, 1971 · Exported to Kenya · Air Convoy IncN14026Piper PA-23-250 (6PCLM) · S/N 27-4638Cancelled May 26, 1971 · Exported to Kenya · Air Convoy IncN14030Piper PA-23-250 · S/N 27-4644Cancelled May 4, 1971 · Exported to Kenya · Air Convoy IncN14033Piper PA-23-250 (6PCLM) · S/N 27-4645Cancelled May 4, 1971 · Exported to Kenya · Air Convoy IncN14034Piper PA-23-250 (6PCLM) · S/N 27-4646Cancelled May 4, 1971 · Exported to Kenya · Air Convoy IncN8586NPiper PA-28-235 · S/N 28-7110007Cancelled Apr 7, 1971 · Exported to Kenya · Built 1971 · Air Convoy IncN9131QBeech 95-B55 · S/N TC-1377Cancelled Mar 29, 1971 · Exported to Kenya · Built 1971 · Air Convoy IncN8618NPiper PA-32-300 · S/N 32-7140010Cancelled Mar 2, 1971 · Exported to Kenya · Air Convoy IncN4453PPiper PA-23-160 · S/N 23-1970Cancelled Apr 14, 1970 · Martys Flying Service IncN9253MMooney M20E · S/N 1200Cancelled Feb 12, 1968 · Built 1966 · Martys Flying Service IncN5469WPiper PA-28-160 · S/N 28-550Cancelled Jan 17, 1968 · Sal Acarpello And Or Virginia ScarpelloN80298Culver V · S/N V-217Cancelled Nov 28, 1960 · Ristine Paul EN44302Taylorcraft BC12-D1 · S/N 10102Cancelled Oct 21, 1955 · Robbins Victor LN10839Stinson JR. S · S/N 8032Cancelled Jul 16, 1948 · Benson Fred JN2062PPiper PA-23 · S/N 23649Cancellation date not recorded · Westchester Airport Inc
Back to Melbourne, FL