Minneapolis, MN
Cancelled registrations · 925
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 = 'MN' AND d.registrant_city = 'MINNEAPOLIS' 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 = 'MN' AND d.registrant_city = 'MINNEAPOLIS' 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.
N804MNUniversity Of Minnesota MINI MUTT · S/N 1N94510Piccard AX-2 · S/N 4N177PFCessna 177A · S/N 17701330N27ATRobinson Helicopter R22 BETA · S/N 1151N4045PPiper PA-23-160 · S/N 23-1522N432FLPiper PA-28-140 · S/N 28-7125219N5487YPiper PA-23-250 · S/N 27-2581N800MNUniversity Of Minnesota ULTRA STICK 25E · S/N 1N802MNUniversity Of Minnesota ULTRA STICK 120 · S/N 1N803MNUniversity Of Minnesota ULTRA STICK 120 · S/N 2N106MPSensurion MAGPIE MP-1 · S/N 2014-00004MP-1N9028AAllis Frederick Michael HARMON ROCKET · S/N 88N39959Taylorcraft BF · S/N 6618N965TETiger AG-5B · S/N 10244N3024ZPiper PA-28-161 · S/N 28-7916399N56318Piper PA-28-235 · S/N 28-7310174N3740LCessna 172G · S/N 17253909N700TBYsker John A THUNDERBOLT TB-1 · S/N 001N447ACCorley Marion A CHALLENGER I · S/N CH 1-84N8890UCessna 150M · S/N 15078013N8171VPiper PA-28-161 · S/N 28-8016282N381PMPierzina Mike KOLB - FIRESTAR II · S/N FS00-4-00047N44435Taylorcraft BC12-D1 · S/N 10235N76024Cessna 120 · S/N 10418N7618DPiper PA-22-150 · S/N 22-5322N8007ACessna 170B · S/N 20859N9695EAeronca 11AC · S/N 11AC1339N51364Piper J3C-65 · S/N 8241N5424BCessna 182 · S/N 33424N51303Fairchild M-62A · S/N T435736N2296Scott-Bensen B-8M GYROCOPTER · S/N 31346N625BRCanadair CL-600-2B19 · S/N 7214N2541WQuicksilver GT-400 · S/N GT 2801371N504USBoeing 757-251 · S/N 23193N242RMMalkin Roy K SEAREY · S/N 1MK369CN1255RBellanca 14-19-3 · S/N 4319N770MJPiper PA-23-250 E · S/N 27-7405425N48969Cessna 152 · S/N 15281081N6232ZPiper PA-25 · S/N 25-282N7649RBeech 19A · S/N MB-440N79591Fairchild M-62A · S/N FV149N87960Piper J3C-65 · S/N 15578N29115Piper PA-28RT-201T · S/N 28R-7931193N8260TCessna 175B · S/N 17556960N32789Piper PA-28-140 · S/N 28-7525113N8335LCessna 172I · S/N 17256535N449FLPiper PA-28-140 · S/N 28-7125241N72783Cessna 120 · S/N 9966N1992RRaven S55A · S/N S55A-113N7615YPiper PA-30 · S/N 30-688
Back to Minneapolis, MN