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.
N264BCPiper PA46-500TP · S/N 4697518N197ALBoeing 737-2E1 · S/N 20300N4733BCessna 152 · S/N 15283605N61139Cessna 150J · S/N 15070830N4083SBell 412 · S/N 33028N971JXBritish Aerospace BAE JETSTREAM 3201 · S/N 971N7644UBoeing 727-222 · S/N 20038N13820Piper PA-23-250 · S/N 27-4465N3802QCessna 172L · S/N 17259902N813HABoeing 737-300 · S/N 27285N57KCPiper PA-31T2 · S/N 31T-8166076N39288Reims CESSNA FT337GP · S/N P0001N2685WDouglas DAKOTA 4 · S/N 16262/33010N20253Textron 172S · S/N 172S12018N20271Textron 172S · S/N 172S12019N2203YFirefly Balloons FIREFLY 9 · S/N F9-2004N511PEBoeing 727-232 · S/N 20634N206ZTBell 206B · S/N 2906N16519Piper PA-32-260 · S/N 32-7300029N94939Cessna 152 · S/N 15285817N50918Cessna 150J · S/N 15069641N183WAAeronca 7AC · S/N 7AC-4741N2510RSwearingen SA226TC · S/N TC292N265USBoeing 727-251 · S/N 19984N729AABoeing 727-227 · S/N 20736N630NHBell Helicopter Textron Canada 407 · S/N 54661N40212Piper PA-23-250 · S/N 27-7305010N2052UTextron 560XL · S/N 560-6230N128NKDouglas DC-9-21 · S/N 47307N1803Mcdonnell Douglas DC-8-62 · S/N 45895N4935CMcdonnell Douglas DC-8-63 · S/N 45931N816BEBeech 1900C · S/N UB57N893AFDouglas DC-8-52 · S/N 45619N105HDRockwell International NA-265-80 · S/N 38039N426FBDouglas DC-8F-54 · S/N 45667N5819XCessna 310F · S/N 310-0119N616SEDouglas DC-6A · S/N 44070N211NWMcdonnell-Douglas DC-10-30 · S/N 46868N3669FEurocopter AS 350 B2 · S/N 1495N505FBDouglas DC-8-51 · S/N 45410N5323PCessna 152 · S/N 15284914N55FBDouglas DC-8F-55 · S/N 45678N7285GCessna 172K · S/N 17258985N7806MFairchild FH-227 · S/N 515N8704SCessna 150F · S/N 15062004N952VVMcdonnell Douglas DC-9-21 · S/N 47303N323SPCessna 411 · S/N 411-0238N722MPPinedo Marcos AVENTURA HP · S/N APHP0011N5450YPiper PA-23-250 · S/N 27-2532N1808EDouglas DC-8-62 · S/N 46105
Back to Miami, FL