Okeechobee, FL

Cancelled registrations · 70

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

N83633Aeronca 7DC · S/N 7AC-2311Cancelled Apr 10, 1984 · Administratively canceled · Broome Frank DN92603Cessna 172M · S/N 17261592Cancelled Oct 9, 1975 · Grace L GarlandN1365PPiper PA-23 · S/N 23-414Cancelled Apr 22, 1974 · Brown Flying School IncN6474SCessna 150H · S/N 15067274Cancelled Jun 26, 1973 · Brown Flying School IncN60137Cessna 150J · S/N 15070098Cancelled Feb 1, 1972 · Christopher H HN609RBeech 50 · S/N H-1Cancelled Oct 28, 1971 · Okeechobee Air Transport Service IncN55704Cessna T-50 · S/N 2618Cancelled Jun 21, 1971 · Revoked, pending cancellation · Miller Charles WN4981CSnow S2A · S/N 1024Cancelled Mar 25, 1971 · Rucks Jonathan Earl JrN9460RSnow S2A · S/N 1094ACancelled Mar 19, 1971 · Rucks Jonathan E JrN30750Piper J3C-65 · S/N 5085Cancelled Jan 19, 1971 · Christopher H HN3304NPiper J3C-65 · S/N 22501Cancelled Jan 18, 1971 · Built 1946 · Christopher H HN2183MPiper J3C-65 · S/N 20972Cancelled Dec 4, 1970 · Brown LeroyN41068Piper J3C-65 · S/N 7694Cancelled Oct 15, 1970 · Christopher H HN52970Boeing A75N1 · S/N 75-331Cancelled Sep 23, 1970 · Built 1940 · Christopher Clyde SN68770Stinson L-5B · S/N 03931Cancelled Jul 7, 1970 · Christopher Dusting Service IncN23127Piper J3L · S/N 2912Cancelled Oct 8, 1958 · Christopher H HN6283Travel Air 4000 · S/N 722Cancelled Aug 28, 1956 · Brown LeroyN66556Boeing E75 · S/N 75-8569Cancelled Mar 14, 1956 · Built 1943 · Thomas C A/Conrad L L/Parkerson J PN41338Piper J5A · S/N 1316Cancelled Oct 13, 1948 · Built 1941 · Davis J S WN7319VBellanca 17-30 · S/N 30187Cancellation date not recorded · Jones Lewis V
Back to Okeechobee, FL