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.
N59523Mcdonnell Douglas DC-9-82(MD-82) · S/N 49915N5983GCessna 150K · S/N 15071483N6739LPiper PA-31-310 · S/N 31-644N367LNDouglas DC-9-31 · S/N 48117N367MNDouglas DC-9-31 · S/N 48116N367PNDouglas DC-9-32 · S/N 48133N367RNMcdonnell Douglas DC-9-32 · S/N 48132N367UDMcdonnell Douglas DC-9-31 · S/N 47570N6559YPiper PA-23-250 · S/N 27-3855N5084EQuicksilver MXII · S/N S1123N105PHPiper PA-23-250 · S/N 27-4167N222JCPiper PA-34-200T · S/N 34-8070102N237AAMcdonnell Douglas DC-9-82(MD-82) · S/N 49253N242AAMcdonnell Douglas DC-9-82(MD-82) · S/N 49255N305FEDouglas DC-10-30F · S/N 47870N62762Piper PA-23-250 · S/N 27-7754004N350ZZEurocopter AS 350 B3 · S/N 3259N80EGWsk-Pzl Warzawa-Okecie PZL-104 WILGA 80 · S/N CF21940946N8119XCessna 172B · S/N 17248619N811ALMcdonnell Douglas DC-8-71 · S/N 46099N914DAEmpson Lee E WAR F4UCORSAIR · S/N 208N672DFGrumman SCAN TYPE 30 · S/N 13N843TADouglas DC-6B · S/N 45514N844AABoeing 727-223 · S/N 20985N552XNHunting Percival P84 JET PROVOST T3 · S/N PAC/W/11807N554AECessna 402B · S/N 402B1308N57063Sankara ALISEO 1 · S/N IT-LOME 350 7E999N5715CCessna 402C · S/N 402C0024N5824AMcdonnell Douglas DC-8F-55 · S/N 45824N6147QSchweizer 269C-1 · S/N 0068N61CXMcdonnell Douglas DC-8-62 · S/N 46142N622BACessna 310R · S/N 310R1308N64PBCessna 402C · S/N 402C-0528N666MVCessna 310B · S/N 35766N477BACessna 182P · S/N 18261669N78WWPiper PA-31-325 · S/N 31-7812045N444SQDouglas DC-6B · S/N 45320N4499BPiper PA-31-350 · S/N 31-7552105N4674PPiper PA-23-250 · S/N 27-203N560FAero Commander 560-F · S/N 560F-1007-9N560MDMcdonnell Douglas DC-9-81(MD-81) · S/N 48000N69313Cessna 402B · S/N 402B0501N699GPiper PA-34-200 · S/N 34-7250338N707AWConvair 240-4 · S/N 145N4293ESolar Wings PEGASUS QUANTUM 15 · S/N 6746N29UAMcdonnell Douglas DC-8-61 · S/N 46159N381AADouglas DC-7BF · S/N 44921N390RBRaytheon 390 · S/N RB-26N3923Grumman SCAN TYPE 30 · S/N 10N40252Let L-410-UVP · S/N 841308
Back to Miami, FL