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.
N132JRCessna 402B · S/N 402B1363N402CACessna 402B · S/N 402B0842N3023UCessna 208B · S/N 208B5109N814EDouglas DC-8-51 · S/N 45687N58YDBeech 58 · S/N TH1427N66REBeech 65-A90 · S/N LJ-307N12756Cessna 552 · S/N 552-0002N498DNMcdonnell Douglas DC-9-83(MD-83) · S/N 49528N8122UCessna 208B · S/N 208B5131N124HRBeech C-45H · S/N AF-603N14030Consolidated Aeronautics LAKE MODEL 250 · S/N 35N301AKDouglas DC3 · S/N 19-778N37199Fairchild M-62A · S/N T41555N5500JPiper PA-32-260 · S/N 32-969N6237BAero Commander 680-E · S/N 680-620-248N638WPPiper PA-23-250 · S/N 27-3081N672SWBoeing 737-3Q8 · S/N 23406N8468BPiper PA-34-220T · S/N 34-8233037N90600Douglas C-117D · S/N 43308N12557Cessna 552 · S/N 552-0003N12855Cessna 552 · S/N 552-0001N3700HMooney M20J · S/N 24-1038N407GDouglas DC3-G202A · S/N 4095N6280DAero Commander 680 · S/N 575-221N74216Balloon Works FIREFLY 7 · S/N F7-319N1871CCurtiss Wright C-46F · S/N 22469N2119KLuscombe 8E · S/N 4846N23EEPiper PA-23-250 · S/N 27-7654127N4026WPiper PA-32-300 · S/N 32-40041N494APMcdonnell Douglas DC-9-83(MD-83) · S/N 49442N49MUBeechcraft G58 · S/N TH-2396N5098AFairchild F-27 · S/N 80N51CPDouglas C-118A · S/N 53-3231N6716KGrumman Acft ENG Cor-Schweizer G-164B · S/N 435BN210PBCessna 210H · S/N 210-58993N35PKBeech 65 · S/N LC-123N3805WPiper PA-32-260 · S/N 32-734N8041TGeneral Dynamics 240 · S/N 52-39N84JFFord James QUICKIE Q-2 · S/N 2419N9786YCessna T210N · S/N 21064598N21112Piper PA-44-180 · S/N 44-7995039N4237LCessna 421B · S/N 421B0415N4554WPiper PA-23-250 · S/N 27-7554120N590HGLockheed 188C · S/N 188C1098N777STPiper PA-31-325 · S/N 31-7912029N95BLDouglas DC-6B · S/N 45220N9960ZCessna U206G · S/N U20606777N99WAero Commander 1121 · S/N 46N1342NConvair 240 · S/N 254N1401ZAerofab LAKE LA-4-250 · S/N 13
Back to Miami, FL