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.
N3309LDouglas DC-9-14 · S/N 45704N59367Bell UH-1B · S/N 229N600GSConvair 340 · S/N 113N400DABoeing 727-232 · S/N 21144N4BLBeech 65-B80 · S/N LD-273N2906RCessna 310G · S/N 310G0106N5608DBeech E18S · S/N BA-314N28HWEnstrom F-28A · S/N 111N3924BAshurst Ka ES W KR-2 · S/N ASHURST 1N550USPiper PA-23-250 · S/N 27-4212N223FBDouglas DC-8-52 · S/N 45985N37511Switzer BENSEN B-8KSB · S/N SB001N5209YPiper PA-23-250 · S/N 27-2257N612GCMcdonnell Douglas DC-10-30F · S/N 47840N9204QCessna 172R · S/N 17281611N9205QCessna 172R · S/N 17281612N10437Curtiss Wright C-46A · S/N 347096N105ECessna 310 · S/N 35479N3589DPiper PA-31-350 · S/N 31-8052135N4656PPiper PA-23-250 · S/N 27-179N198CHRobinson Helicopter R22 BETA · S/N 3974N25218Cessna 152 · S/N 15280536N25412Cessna 152 · S/N 15280640N25703Beech 95-B55 (T42A) · S/N TC-1610N3389SCessna 210J · S/N 21059189N3482BBeech D18S · S/N A-982N3505GBeech C-45H · S/N AF-370N4327CAeronca 7EC · S/N 7EC336N846TWBoeing 727-31 · S/N 18753N9876HCessna T-50 · S/N 4521N2782GDouglas C-47 · S/N 43-48843N3244RCessna 411 · S/N 411-0244N3317SCessna 210J · S/N 21059117N5153ACessna P210N · S/N P21000832N9090HCessna T-50 · S/N 2264N91496Ryan NAVION · S/N NAV4291N5085JCessna 310R · S/N 310R0205N6904CLockheed 1049-54 · S/N 4018N72206Wsk-Pzl Meilec PZL M18B · S/N 1Z026-28N309SLPiper PA-23-250 · S/N 27-2232N66193Cessna T-50 · S/N 3632N90410Cessna 182RG · S/N R18201445N914BVDouglas DC-8-61 · S/N 45912N4948PCessna 152 · S/N 15284855N53589Cessna 172S · S/N 172S9408N2536NPiper PA-38-112 · S/N 38-79A0905N323LBSwearingen SA226TC · S/N TC-323N59030Cessna T-50 · S/N 2512N60145Cessna T-50 · S/N 5173N60497Boeing PT-27 · S/N 753871
Back to Miami, FL