Pembroke Pines, FL
Cancelled registrations · 232
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 = 'PEMBROKE PINES' 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 = 'PEMBROKE PINES' 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.
N3229PPiper PA-23 · S/N 23-1172N522NMAgustawestland Philadelphia AW119MKII · S/N 14968N20113Textron T182T · S/N T18209192N6272ZArnold J/Jones D L AIR CAM · S/N AC014N748CEPiper PA-31-310 · S/N 31-397N934JPCessna 402B · S/N 402B0934N4629XCessna 150G · S/N 15064679N281AMAircraft Mfg & Development CH 2000 · S/N 20-1042N4904HCessna 152 · S/N 15284012N505JGAero Commander 680-F · S/N 680F-938-10N498AAMcdonnell Douglas DC-9-82(MD-82) · S/N 49736N356AEFouga CM 170 MAGISTER · S/N 356N402RZCessna 402C · S/N 402C0414N7CVFolland GNAT T 1 · S/N FL594N821CXPiper PA-28-161 · S/N 28-8216166N4349PPiper PA-28-161 · S/N 28-8416069N45333Grumman American Avn. AA-5B · S/N AA5B1260N9663HPiper PA-18-125 · S/N 18-552N6590XAerostar International RAVEN S57-A · S/N S57A-3032N4662Beech 95-55 · S/N TC-126N2803SCessna 150G · S/N 15066703N4477UCessna 150D · S/N 15060477N7130YPiper PA-30 · S/N 30-152N599PCBritten-Norman BN-2A-3 · S/N C-1064N421XBeech 65 · S/N LC-17N299PCBritten-Norman BN-2A-3 · S/N C-1062N399KGPiper PA-23-250 · S/N 277954019N399PCBritten-Norman BN-2A-3 · S/N C-1063N899PCBritten-Norman BN-2A-3 · S/N C-1066N629PCBritten-Norman BN-2A-3 · S/N C-1070N199PCBritten-Norman BN-2A-3 · S/N C-1038N710XCessna 310Q · S/N 310Q0536N707BTPiper PA-34-200T · S/N 34-7570110N147EDCessna U206F · S/N U20603138N8917NPiper PA-32-300 · S/N 32-40709N733QECessna 172N · S/N 17268459N62950Cessna 414 · S/N 414-0086N1045UPiper PA-34-200 · S/N 34-7250029N1393LCessna 337H · S/N 33701885N6219WPiper PA-28-140 · S/N 28-20258N25516Cessna 152 · S/N 15280709N5288ECessna 172N · S/N 17271817N388ESCessna 172R · S/N 17280116N519AACessna 550 · S/N 5500053N15VGPiper PA-28-161 · S/N 288316047N27WLBeech 58 · S/N TH-485N559PCBritten-Norman BN-2A-3 · S/N C-1069N929PCBritten-Norman BN-2A-3 · S/N C-1071N345BAPiper PA-34-200 · S/N 34-7250116N71950Douglas DC-7C · S/N 45207
Back to Pembroke Pines, FL