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.
N67146Bell 206B · S/N 5114N67242Bell 206B · S/N 5127N128BHHyde William R HELICYCLE · S/N 1-21B-1-27BN156PAConvair 240 · S/N 324N305FLCasaudoumecq Jose H ECO 2 · S/N JC062015N489AAMcdonnell Douglas DC-9-82(MD-82) · S/N 49682N70SWCessna 500 · S/N 500-0236N8746ZBell Helicopter Textron Canada 505 · S/N 65277N6941GCessna 150L · S/N 15072441N8939FPiper PA-28-151 · S/N 28-7715295N202HCPiper PA-31T · S/N 31T-7820036N390USBoeing 737-3B7 · S/N 23312N9403WMcdonnell Douglas DC-9-83(MD-83) · S/N 53139N51283Thrush S2R-T34 · S/N T34-516N400DYGates Learjet 35A (C-21A) · S/N 557N271FXMesserschmitt-Boelkow-Blohm-Gm BO-105C · S/N S-718N803WAMcdonnell Douglas DC-9-82(MD-82) · S/N 49507N524FACessna 402C · S/N 402C0485N954UMcdonnell Douglas DC-9-82(MD-82) · S/N 49426N888PBBritish Aerospace BAE 125 SERIES 800A · S/N 258022N714FCBoeing 707-321 · S/N 17592N2563BNorthrop C-125 · S/N 48621N181LMCirrus Design SR22 · S/N 1675N2548LCessna 172H · S/N 17255748N337TTCessna 337 · S/N 337-0032N74833Douglas B-26B · S/N 44-35439N230LCBell 412EP · S/N 36382N618TFMcdonnell Douglas MD-11F · S/N 48777N757SXCessna 152 · S/N 15279978N777TNPiper PA-31-310 · S/N 31-7401261N5293Textron 208B · S/N 208B5293N26ZZSchweizer 269C · S/N S1412N428HPTextron 208B · S/N 208B5568N167ASMcdonnell Douglas DC-9-87 · S/N 49414N487AAMcdonnell Douglas DC-9-82(MD-82) · S/N 49680N624SWBoeing 737-3H4 · S/N 27934N630WNBoeing 737-3H4 · S/N 27705N110MLBoeing 747-406 · S/N 24201N775BCMcdonnell Douglas MD-11F · S/N 48775N776MLMcdonnell Douglas MD-11F · S/N 48776N258RJCessna 310R · S/N 310R0202N31ABeech E-90 · S/N LW-281N989PTCessna 650 · S/N 6500129N36TAero Commander 680 · S/N 680-600-235N391SWBoeing 737-3H4 · S/N 27378N386SWBoeing 737-3H4 · S/N 26601N350KWEurocopter AS 350 B3 · S/N 3832N61KKAerospatiale AS332L · S/N 2131N8748PBell Helicopter Textron Canada 505 · S/N 65276N69355Cessna 340A · S/N 340A0203
Back to Miami, FL