OpenAirDocs.org
Lauderdale, FL

Cancelled registrations · 26

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

N7093LCessna 402B · S/N 402B0868Cancelled Jul 8, 2013 · Registration expired, pending cancellation · Built 1975 · Kmc VentresN53329Cessna A188B · S/N 18801767TCancelled May 12, 1995 · Exported to Brazil · Southern Cross Aviation IncN4262DBell 206B · S/N 4221Cancelled May 11, 1993 · Exported to Brazil · Built 1992 · Helicraft Aviation IncN827PBeech A36 · S/N E-1751Cancelled Feb 28, 1991 · Exported to Brazil · Wagoner Aircraft Sales CorpN6141HPiper PA-32-300 · S/N 32-7840035Cancelled Aug 24, 1982 · Lauderdale Aviation IncN25234Cessna 152 · S/N 15280546Cancelled Aug 19, 1980 · Exported to United Kingdom · Built 1977 · Lauderdale AirN75576Cessna 207A · S/N 20700635Cancelled Jul 24, 1980 · Exported to Guadeloupe · Cavico Aircraft Sales IncN745WGates Lear Jet 25B · S/N 177Cancelled May 29, 1980 · Exported to Germany · Robert Graf IncN2156JCessna A188B · S/N 18803393TCancelled Sep 19, 1979 · Exported to Nicaragua · Cavico Aircraft Sales IncN6748LPiper PA-31-310 · S/N 31-603Cancelled Jun 18, 1979 · Exported to Zambia · Air Convoy IncN7573JPiper PA-28R-180 · S/N 28R-30962Cancelled Jul 18, 1977 · Bush Aviation IncN18238Cessna 150L · S/N 15073891Cancelled Mar 12, 1974 · Exported to Sweden · Sunny South Aircraft Service IncN20MLearjet 23 · S/N 094Cancelled May 29, 1973 · Zantop Howard WN3183FCessna 182 · S/N 182-57283Cancelled May 14, 1971 · Exported to Panama · Built 1966 · Sunny South Aircraft Service IncN1453MCessna U206E · S/N U206-01453Cancelled Feb 16, 1971 · Exported to Norway · Euramericair IncN6964YPiper PA-23-250 · S/N 27-4329Cancelled Feb 5, 1971 · Exported to South Africa · Built 1969 · Euramericair IncN4845JBeech V35 · S/N D-8305Cancelled Oct 7, 1970 · Aircraft Ferry Company IncN6516YPiper PA-23-250 · S/N 27-3807Cancelled Apr 28, 1970 · Exported to United Kingdom · Euramericair IncN6022YPiper PA-23-250 · S/N 27-4368Cancelled Dec 18, 1969 · Exported to Kenya · Air Convoy IncN29086Cessna U206C · S/N U206-1060Cancelled Nov 18, 1969 · Exported to Guyana · Florida Aircraft Distributors IncN8977NPiper PA-32-300 · S/N 32-40855Cancelled Oct 2, 1969 · Exported to Kenya · Built 1969 · Air Convoy IncN4251RPiper PA-32-300 · S/N 32-40619Cancelled May 28, 1969 · Exported to Kenya · Air Convoy IncN6860YPiper PA-23-250 · S/N 27-4205Cancelled May 26, 1969 · Exported to Kenya · Air Convoy IncN4249RPiper PA-32-300 · S/N 32-40616Cancelled Apr 15, 1969 · Exported to South Africa · Air Convoy IncN9462WPiper PA-28-235 · S/N 28-11185Cancelled Jan 22, 1969 · Exported to Kenya · Built 1968 · Air Convoy IncN4846JBeech V35 · S/N D-8314Cancelled Mar 14, 1967 · Exported to Australia · Aircraft Ferry Co Inc
Back to Lauderdale, FL