Redmond, WA
Cancelled registrations · 67
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 = 'REDMOND' 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 = 'REDMOND' 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.
N70JRForman James Roy GLASAIR II S TD · S/N SH2055N2071JCameron Balloons US V-77 · S/N 5428N50PLIsrael Aircraft Industries 1124A · S/N 338N116DCCrocker Donald E RV-6 · S/N 20298N628BNorth American T-28B · S/N 138224N71PWBoeing 737-2Q8C · S/N 21960N704NYCessna 150M · S/N 15078754N75PWBoeing 737-2T5 · S/N 22632N5669SMaule M-7-235 · S/N 4040CN40191Stinson 108 · S/N 108121N34RNNewton Richard PANTHER 2 PLUS · S/N 69034N11NACessna 310 · S/N 35182N37025Balloon Works FIREFLY 8-24 · S/N F8059N8908PPiper PA-24-260 · S/N 24-4363N8346Randall FLYBABY 1A · S/N 2071N252BColonial C-1 · S/N 12N9650BCessna 180 · S/N 32947
Back to Redmond, WA