Miami, FL
Cancelled registrations · 5,508
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 = 'MIAMI' 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 = 'MIAMI' 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.
N9232ZDouglas DC-6A · S/N 44915N9241YPiper PA-31-310 · S/N 31-313N92453Cessna 172N · S/N 17261578N9288HCessna 172M · S/N 17266069N132LAAero Commander 1121B · S/N 133N245HGDouglas DC-8-53 · S/N 45662N896JBLockheed PV-1 · S/N 5500N90447Douglas C-118A · S/N 44608N90766Bell 47D5A · S/N 51-13974N9109VMooney M20F · S/N 690025N8592TCessna 182C · S/N 52492N86427North American TB-25N · S/N 44-29121N872ADouglas DC3A · S/N 7403N8751PPiper PA-24-250 · S/N 24-3682N87ZNorth American B-25J · S/N 44-86873AN880WAConvair 22 · S/N 51N410JRBoeing 757-29J · S/N 27204N587LMDouglas C-117D · S/N 43369N8215HDouglas DC-7C · S/N 45212N8218HDouglas DC-7C · S/N 45191N44UADouglas DC-8F-54 · S/N 45800N48192Henry BENSEN B-8M · S/N 44824N8021GCessna 177RG · S/N 177RG0021N818UJCessna 421B · S/N 421B0003N821FDouglas DC-8-21 · S/N 45433N8CWBeech J50 · S/N JH-165N6115UCessna T210R · S/N 21064904N63MUGulfstream Aerospace G-IV · S/N 1152N8338JCessna 150G · S/N 15066238N924LDouglas DC-9-32 · S/N 47324N2558XCessna P206 · S/N P206-0058N3900NBeech 35 · S/N D-1146N77ACCessna 421A · S/N 421A0078N780BPAero Commander 690 · S/N 11052N7947YPiper PA-30 · S/N 30-1043N7437LPiper PA-31-310 · S/N 31-824N74902Piper PA-31-350 · S/N 31-7305031N75033Piper PA-32R-300 · S/N 32R-7680247N75338Curtiss Wright C-46A · S/N 26814N7589UCessna 150M · S/N 15077756N76JTPiper PA-23-250 · S/N 27-503N76KWDouglas DC3C · S/N 9397N6608YPiper PA-23-250 · S/N 27-4393N725CABoeing 707-321 · S/N 17603N738PQCessna 172N · S/N 17270134N73958Cessna 172N · S/N 17267764N73SAPiper PA-28-140 · S/N 28-7125623N83DWPiper PA-31-310 · S/N 31-7612104N6003JCessna A150L · S/N A1500303N721ZCPiper PA-31-310 · S/N 31-81
Back to Miami, FL