Spokane, WA
Cancelled registrations · 389
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 = 'WA' AND d.registrant_city = 'SPOKANE' 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 = 'WA' AND d.registrant_city = 'SPOKANE' 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.
N4382SSikorsky S-58J · S/N 581627N8342WPiper PA-28-180 · S/N 28-2526N924TBeech 35-33 · S/N CD-126N7075TCessna 172 · S/N 46675N3423JCessna 150G · S/N 15066123N8803LPiper PA-25-260 · S/N 25-5296N92JDCessna TU206F · S/N U20602479N44HMSchweizer SGS 1-26B · S/N 258N7738PPiper PA-24-250 · S/N 24-2952N1078JAero Commander 112 · S/N 78N42338Cessna 182L · S/N 18258974N5SPitts S-1C · S/N BBC-1N6478RPiper PA-28-140 · S/N 28-21667N5455SPiper PA-28 · S/N 287125122N14542Semco Balloon TC-4A · S/N SEM133N6983ACessna 172 · S/N 29083N1458HAeronca 15AC · S/N 15AC-531N66798Piper PA-31P · S/N 31P-7300158N9944RBeech M35 · S/N D-6470N3181FCessna 170B · S/N 25825N15587Piper PA-28-235 · S/N 28-7310057N6693ACessna 172 · S/N 28793N9539FHughes 269B · S/N 1080392N7228FPiper PA-28-140 · S/N 28-25141N2218EAeronca 7AC · S/N 7AC-5792N4320UCessna 150D · S/N 15060320N7676KPiper PA-20 · S/N 20-497N4010MPiper PA-12 · S/N 12-2890N2117HErcoupe 415-C · S/N 2740N1315CPiper PA-22-135 · S/N 22-1106N8473CAero Commander 500 · S/N 500-801N93864Forney F-1 · S/N 1187N3815RCessna 172H · S/N 17255315N57070Fairchild M-62 · S/N T43-5748N3996FCessna 172 · S/N 36896N4497DBeech G35 · S/N D-4628N7839CCherokee II HOMEBUILT · S/N JCM-1N50598Cessna 150J · S/N 15069424N30397Cessna 177A · S/N 17701234N1307CPiper PA-22 · S/N 22-1120N3633CCessna 180 · S/N 31131N1413APiper PA-22 · S/N 22-324N22740Cessna 150H · S/N 15068485N6409WPiper PA-28-140 · S/N 28-20478N5153ZPiper PA-22-108 · S/N 22-8803N1701ZCessna 336 · S/N 336-0001N501MGrumman G-21A · S/N B138N6186CBeech A45 (T-34A) · S/N 53-4096AN5470HPiper PA-18 · S/N 18-61N2334KLuscombe 8E · S/N 5061
Back to Spokane, WA