Plantation, FL
Cancelled registrations · 173
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 = 'PLANTATION' 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.
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 = 'PLANTATION' ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N341AFDiamond Aircraft Ind DA 40 · S/N 40.1041N576SWEmbraer EMB-120ER · S/N 120345N978AXMcdonnell Douglas DC-9-41 · S/N 47628N965Piper PA-23-250 · S/N 27-7554010N962AXDouglas DC-9-41 · S/N 47768N816QBeech 65 · S/N LC-38N4TRPiper PA-23-250 · S/N 27-3111N552PRDehavilland DH 114 HERON 2X · S/N 14088N9887ZBeech C-45H · S/N AF-533N8BDBede BD-8 · S/N 8-0001N584PRDehavilland DH 114 HERON 2X · S/N 14142N216SWEmbraer EMB-120 · S/N 120.285N4789CDehavilland DH 114 HERON 2X · S/N 14080N582JDRaytheon 58 · S/N TH2034N603SJBeechcraft G58 · S/N TH-2375N292KCRobinson Helicopter R22 BETA · S/N 2257N115QSRaytheon 400A · S/N RK-383N745MLHawker Beechcraft B200GT · S/N BY-28N973AXMcdonnell Douglas DC-9-41 · S/N 47511N6796Vertol H21B · S/N 53-4334N943AXMcdonnell Douglas DC-9-31 · S/N 47528N88745Aeronca 7AC · S/N 7AC-366N965AXMcdonnell Douglas DC-9-41 · S/N 47498N966AXDouglas DC-9-41 · S/N 47510N969AXMcdonnell Douglas DC-9-41 · S/N 47464N974AXMcdonnell Douglas DC-9-41 · S/N 47623N949AXDouglas DC-9-31 · S/N 47325N900AXDouglas DC-9-32 · S/N 47380N957AXDouglas DC-9-41 · S/N 47759N963AXMcdonnell Douglas DC-9-41 · S/N 47780N8594MCessna T337G · S/N P3370006N193YVEmbraer EMB-120RT · S/N 120.193N6698LLake LA-4-200 · S/N 461N6104TCessna 150E · S/N 15060804N221YVEmbraer EMB-120RT · S/N 120.221N4624SCessna TR182 · S/N R18201359N965PGBoeing 727-232 · S/N 20639N83BBensen B-7MC · S/N 1N4XZCessna T310R · S/N 310R1538N928AXMcdonnell Douglas DC-9-32 · S/N 47392N924AXDouglas DC-9-31 · S/N 47403N937AXDouglas DC-9-31 · S/N 47074N8091MCessna T210K · S/N 21059411N736BXCessna R172K · S/N R1722407N500HWAero Commander 500 · S/N 661N968AXMcdonnell Douglas DC-9-41 · S/N 47499N609PBeech D-50 · S/N DH-83N954AXMcdonnell Douglas DC-9-41 · S/N 47612N984AXDouglas DC-9-32 · S/N 47258N100LVPiper PA-34-220T · S/N 348233176
Back to Plantation, FL