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.
N2395Van Hoten BENSEN B-8 · S/N 7429VN1392GCessna 310R · S/N 310R1217N421DABoeing 727-232 · S/N 21274N58CRPiper PA-31-350 · S/N 31-7305033N633Lockheed 18-56 · S/N 2614N6419YPiper PA-23-250 · S/N 27-3703N6451ZPiper PA-25 · S/N 25-601N6454PPiper PA-24-250 · S/N 24-1569N6465CConsolidated Vultee PBY-6A · S/N 64104N64734Cessna 150L · S/N 15072454N64737Cessna 150L · S/N 15073585N14232Piper PA-23-250 · S/N 27-4790N319ATAerospatiale SA319B ALOUETTE III · S/N 2008N6137PPiper PA-24-250 · S/N 24-1237N6259DAero Commander 680 · S/N 680-527-197N6311LAmerican AA-1A · S/N AA1A-0311N6823Boeing 727-223 · S/N 19701N701CFAeropro CZ EUROFOX LSA · S/N 237 07N221RMPiper PA-23-250 · S/N 27-7954031N510FACessna 172RG · S/N 172RG0048N5246BCessna 152 · S/N 15283815N64940Cessna 152 · S/N 15281488N125GUBoeing 737-2H6 · S/N 23849N133VCessna 401A · S/N 401A0098N14018Piper PA-23-250 · S/N 27-4632N2493FConvair HC-131A · S/N 52-5783N28JCPiper J3C-65 · S/N 22945N2980PConsolidated Aeronautics LAKE LA-4-200 · S/N 951N342CCCessna 680 · S/N 680-0342N42ACessna 421A · S/N 421A0135N4899JBeech 95-C55 · S/N TE-340N6161MDouglas DC-8F-55 · S/N 45762N84BLDouglas DC-6B · S/N 43739N71HCPiper PA-23-250 · S/N 27-3610N9106SBeech 58TC · S/N TK-5N912DAAero Commander 1121B · S/N 147N81450Cessna 208B · S/N 208B5031N695BBeech A35 · S/N D-1698N40567Piper PA-23-250 · S/N 27-7405308N47950Piper PA-28-181 · S/N 28-7890155N7333HPiper J3C-65 · S/N 20593N7451TCessna 172A · S/N 47051N475PLAero Commander 500 · S/N 767N501LPitts SPECIAL · S/N L-1N550RCPiper PA-31-325 · S/N 31-8212020N5758YPiper PA-23-250 · S/N 27-2884N580JCDouglas DC-8-21 · S/N 45594N7150QCessna 172L · S/N 17260450N200TADouglas DC3 · S/N 19998N2656XBeech H-18 · S/N BA-677
Back to Miami, FL