South St Paul, MN
Cancelled registrations · 30
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 = 'SOUTH ST PAUL' 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 = 'SOUTH ST PAUL' 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.
N12326Dehavilland DHC-6-300 · S/N 273N208JEDehavilland DHC-6-300 · S/N 557N225WACessna 208 · S/N 20800225N604MACessna 208 · S/N 20800031N125ARCessna 208B · S/N 208B0925N107FBAir Tractor AT-802 · S/N 802-0176N94MSCessna 208 · S/N 20800298N633KBeech 95-C55 · S/N TE-198N839Eberspacher Warren A HAC MODEL A-001 · S/N 1N94901Taylorcraft BC12-D · S/N 9301N60064Cessna 150J · S/N 15070047N562GCessna 150H · S/N 15068274N96187Taylorcraft BC12-D · S/N 8487N5697TCessna 172E · S/N 17251597N117LCessna A185E · S/N 18501850N6814DConsolidated Vultee P4Y-2 · S/N 59913N4218ZPiper PA-18-150 · S/N 18-8440N3511VCessna 140 · S/N 14780N6815DConsolidated Vultee P4Y-2 · S/N 59946N2784JCessna 185E · S/N 185-1534N9598SChampion 7ECA · S/N 7ECA295N5845TCessna 185C · S/N 185-0745N4640UCessna 180G · S/N 108-51340N5105UCessna 206 · S/N 206-0105N3013NCessna 140 · S/N 13271N9262TCessna 180C · S/N 50762N23152Piper J3C-65 · S/N 2936N69635Consolidated Vultee BT-13B · S/N 79-1246N4726BCessna 180 · S/N 31624N9585ACessna 170A · S/N 19398
Back to South St Paul, MN