Ocala, FL

Cancelled registrations · 183

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 = 'OCALA'
  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.

N28109Piper J3L-65 · S/N 4584Cancelled Jun 21, 1993N3754UCessna 182G · S/N 18255154Cancelled Jun 18, 1993 · Triennial form not returned · Carr Carl L SrN7165ZMadison Richard THORP T18 · S/N 105Cancelled Apr 29, 1993 · Madison RichardN630JLPiper PA-32RT-300 · S/N 32R7885174Cancelled Apr 13, 1993 · Lacey Romanzo AN30306Cessna 177A · S/N 17701183Cancelled Feb 19, 1992 · Triennial form not returned · Sherer William JN10SNCessna 310R · S/N 310R1563Cancelled Jan 9, 1992 · Exported to Namibia · Donald Woodis Enterprises Inc DBAN1855HBeech C90 · S/N LJ995Cancelled Aug 21, 1991 · Exported to Brazil · Boyd Roy T JrN404MWCessna 404 · S/N 4040690Cancelled Jul 15, 1991 · Exported to Germany · Donald Woodis Enterprises Inc DBAN32308Rearwin 175 · S/N 1517Cancelled Feb 12, 1991 · Exported to United Kingdom · Lebrecht Charles EN871JVVander Mey James E JEV-1 · S/N 0001Cancelled Nov 29, 1989 · Triennial form not returned · Vander Mey James EN42037Piper PA-28-140 · S/N 28-21154Cancelled Jul 7, 1982 · Exported to Canada · Built 1966 · Dutton AdamN79010Cessna 172K · S/N 17257807Cancelled Oct 14, 1981 · Harrison E GainesN224MABeech F50 · S/N FH-72Cancelled May 4, 1981 · Built 1957 · Florida Lime & Dolomite Co IncN20240North American HARVARD MKII · S/N 81-4128Cancelled Jan 21, 1981 · Exported to Venezuela · Built 1943 · Leeward James KN222CPCessna 401 · S/N 4010029Cancelled Oct 28, 1980 · Exported to Chile · Built 1966 · Lloyd Aero CorpN20RLPiper PA-31 · S/N 31-7401208Cancelled Sep 6, 1977 · Exported to Canada · Lee RobertN5189Caldwell TEENIE TWO · S/N 510203Cancelled Jan 26, 1977 · Caldwell Howard DN23595Bell TH-13T · S/N 3606Cancelled Dec 2, 1975 · Sale reported, pending cancellationN6153FCessna A150L · S/N A1500430Cancelled Jun 12, 1975 · Skyway Of Ocala IncN3472SCessna 182H · S/N 18255872Cancelled Jun 6, 1974 · Exported to Bolivia · Eugene RobertsN87501Republic RC-3 · S/N 53Cancelled May 24, 1973 · Norris Cattle CoN46948Fairchild M-62A · S/N T42-1433Cancelled May 24, 1971 · Marion County Board Of Public InstructionN78SRDouglas DC3 · S/N 12580Cancelled Feb 19, 1971 · Exported to Iran · Leeward & Pfaff CoN4778SCulp John W K R 2 · S/N 8801Cancelled Jun 23, 1970 · Harold F CheekN3083ZPiper PA-18A 150 · S/N 18-7137Cancelled Mar 14, 1968 · Exported to Canada · Florida Game And Fresh Water Fish CommissionN313SBeech TC-45G · S/N AF123Cancelled Sep 7, 1967 · Exported to Panama · Wholesale Aircraft IncN2752MPiper PA-12 · S/N 12-1244Cancelled May 21, 1965 · Piel Donald JN2999Beech D18S · S/N A-811Cancelled Mar 25, 1964 · South Central Airlines IncN88621Piper J3C-65 · S/N 16249Cancelled May 31, 1949 · Central Florida Flying ServiceN46928Aeronca 0-58B · S/N 13824Cancelled Jan 12, 1949 · Henry H Richardson JrN15618Piper E-2 · S/N 298Cancelled May 15, 1941 · Built 1925 · Scroggin Cullen BryantN881YSavage Ulmer ALL AMERICAN MODEL A · S/N 895Cancelled Feb 23, 1934 · Savage UlmerN653WAeronca C-2 · S/N 33Cancelled Feb 2, 1933 · Adams P W
Back to Ocala, FL