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.
N162UALopez Rey A CONDOR III · S/N 83-162-3N350AKPiper PA-31-310 · S/N 31-7401240N55554Raven Industries RALLY RX7 · S/N RX7-124N6034TBeech 65 · S/N LC-172N6059Kozik RRKB8M GYROPLANE · S/N KK-1006N6060KCessna R172K · S/N R1722024N608LLockheed 18-56 · S/N 2305N6098YCessna T210N · S/N 21064249N5256YCessna T210N · S/N 21064138N16780Bell 206L · S/N 45112N5694DBeech G50 · S/N GH-103N5696YPiper PA-23-250 · S/N 27-2816N569QABeech G18S · S/N BA-606N578JCDouglas DC-8-31 · S/N 45275N58335Hughes 269C · S/N 390762N5854CBeech D18S · S/N A-588N150PYAirbus Industrie A300 B4-203 · S/N 150N20PCCessna 150J · S/N 15071116N5537GCessna 150J · S/N 15071037N5594HBeech 95-B55 (T42A) · S/N TC-1483N5652KMaule M-6-235 · S/N 7449CN931JHCessna 172N · S/N 17273826N49435Cessna 152 · S/N 15281264N502RMMohammed Ricardo R MINI 500 · S/N 0359N5240JCessna 404 · S/N 404-0621N5413YPiper PA-23-250 · S/N 27-2492N5471YPiper PA-23-250 · S/N 27-2562N54835Piper PA-23-250 · S/N 27-7554136N55TRBeech E-55 · S/N TE-1166N990ZMcdonnell Douglas DC-9-31 · S/N 47136N37573Douglas DC-6B · S/N 44897N38MSBeech D18S · S/N A-224N406VWCessna 411 · S/N 4110208N43LBeech E18S-9700 · S/N BA-228N4FBAero Commander 680V · S/N 1688-68N34ELCessna 182S · S/N 18280688N2307MThrift-Roy BENSEN B8MG · S/N RLT-003N2537NPiper PA-38-112 · S/N 38-79A0906N27012Balloon Works FIREFLY 7 · S/N 758N2965KLuscombe 8A · S/N 5692N30609Thrush S2R-T34 · S/N T34-404N14344Piper PA-23-250 · S/N 27-7304925N1501KBalloon Works FIREFLY 7 · S/N 11116N1671ECessna 172N · S/N 17271088N1037ADouglas DC3-S · S/N 43341N1045GConvair VT-29D · S/N 52-5818N617SEDouglas DC-6B · S/N 44088N24994Cessna 152 · S/N 15280501N5309TPiper PA-34-200 · S/N 34-7250248N5413GCessna 404 · S/N 404-0032
Back to Miami, FL