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.
N162PABeech 200 · S/N BB-232N2118XNorth American SNJ-6 · S/N 112322N236TACessna 206H · S/N 20608350N39FSmith SMITH MINIPLANE · S/N DSA-50-1N7046HDouglas DC-8F-54 · S/N 46011N914LFDouglas DC-9-14 · S/N 45695N5224CCessna T206H · S/N T20608386N68AFBoeing 737-222 · S/N 19058N739RPCessna 172N · S/N 17270747N92718Cessna 172M · S/N 17261607N9526QCessna 172R · S/N 17280457N7922QCessna 401B · S/N 401B0022N6548NCessna 210N · S/N 21063104N690BCDehavilland DH 114 HERON 2X · S/N 14066N74ARAero Commander 680 · S/N 680-455-125N8040YCurtiss Wright C-46A · S/N 30.323N21748Douglas DC3A · S/N 2106N2290LDouglas DC3C-S1C3G · S/N 12289N3482WPiper PA-32-260 · S/N 32-359N35NPiper PA-31-310 · S/N 31-7401226N37163Cessna 404 · S/N 404-0126N4167VCessna 170 · S/N 18500N64324Boeing 727-231 · S/N 20099N720GSBoeing 707-321C · S/N 19370N757LACessna 152 · S/N 15279814N808EDouglas DC-8-51 · S/N 45646N869JHCessna 152 · S/N 15283065N12681Grumman JRF-5 · S/N 34089N234ACCessna 402B · S/N 402B0922N727DHBoeing 727-228 · S/N 20204N7377UCessna T210R · S/N 21064965N814GBDouglas DC-8-61 · S/N 45913N82256Piper PA-44-180T · S/N 44-8107004N888ZPiper PA-24-250 · S/N 24-310N110XSHawker Siddeley GNAT · S/N XS110N1976PDouglas DC-8-21 · S/N 45435N3235GPilatus Britten-Norman BN-2B-27 · S/N C2111N71903Robinson Helicopter R44 · S/N 1290N4525Cessna 310A · S/N 38044N6787CBeech C18S · S/N 44-47212N68041Mcdonnell Douglas DC-10-10 · S/N 46900N738XBCessna 172N · S/N 17270308N206VAMitsubishi YS-11-100 · S/N 2006N256ADBeech 58 · S/N TH-424N463USBoeing 727-51 · S/N 18799N490ACRockwell International 690B · S/N 11521N5265YCessna T210N · S/N 21064143N6182YPiper PA-23-250 · S/N 27-3408N93RTTrickel R/Trickel R A TRI-RT 1 · S/N 001N508DCDouglas DC-8-51 · S/N 45935
Back to Miami, FL