Kenosha, WI
Cancelled registrations · 95
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 = 'WI' AND d.registrant_city = 'KENOSHA' 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 = 'WI' AND d.registrant_city = 'KENOSHA' 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.
N9358JPiper PA-28-180 · S/N 28-3457N97812Stinson 108-1 · S/N 108812N4909HCessna 152 · S/N 15284015N6477PCessna 152 · S/N 15285024N63BBeech E18S · S/N BA119N6338Republic F-84 · S/N 52-6370N4779ECessna 172N · S/N 17271644N48732Cessna 152 · S/N 15280941N7486QCessna 182P · S/N 18261126N24KBeech H-18 · S/N BA648N16600Beech UC-45J · S/N 39749N7190XCessna 150A · S/N 15059290N899CStinson 108-3 · S/N 1083899N3776NBeech 35 · S/N D-998N6847PPiper PA-24-250 · S/N 24-1981N5179VBeech C-45H · S/N AF462N4670CCessna 170B · S/N 25614N9733ACessna 170A · S/N 19194N3030KCulver V · S/N 249N2277YCessna 177 · S/N 17700077N45676Luscombe 8A · S/N 2203N8139FCessna 402 · S/N 402-0233N5401Baker GYROCOPTER · S/N 397-22-4837N9384VMooney M20C · S/N 700025N97766Stinson 108-1 · S/N 108766N3906JCessna 150G · S/N 150-65206N63715Fairchild M-62C(PT-23A) · S/N 236N4465VBeech 35 · S/N D-1281N36515Aeronca 65-CA · S/N C16041N95940Taylorcraft BC12-D · S/N 8240N47321Harlow S1B1 · S/N 160N4055MPiper PA-12 · S/N 12-2937N5891Waco GXE · S/N 1546N6964Waco GXE · S/N 1701N553Arrow Aircraft & Motors ARROW SPORT · S/N 307N650NDavis D-1-K · S/N 507N242KAeromarine 39-B · S/N 13N624VParks P-1 · S/N 1999N11860Curtiss Wright JR CW1 · S/N 1234N5556Ryan B1 · S/N 121N10030Caviezel E C SPORT · S/N 1N1903Aeromarine Plane & Motor EO · S/N 5079N1948Fischer Body STANDARD J1 · S/N 1N2190Standard J-1 · S/N 22684N11493Aeronca C-3 · S/N A-163
Back to Kenosha, WI