Vancouver, WA
Cancelled registrations · 260
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 = 'VANCOUVER' 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 = 'VANCOUVER' 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.
N9256UCessna 150M · S/N 15078206N7272WPiper PA-28-180 · S/N 28-1108N263SCSix Chuter West PARAGON · S/N 3210N995XPSix Chuter SKYRIDER SR5XP · S/N 99-2242-SR5XPN80451Beech 35 · S/N D-51N186RJames Roger Haldeman CYCLON 186 · S/N 001N114ENEthan Berry AVID MAGNUM · S/N 38-MN53331Consolidated Vultee BT-13A · S/N 1491N90KLLudeke Gary L / Krause Jerry L FIRESTAR 2 · S/N F1196N5506XFlightstar SPYDER · S/N JDA 2N769VPBrooks Baniel B SR EVANS VLKSPLN VP-1 · S/N V-591DBN6974XCessna 172B · S/N 17247874N1581BLuscombe T-8F · S/N 6208N5431KRyan NAVION B · S/N NAV-4-2331-BN4431KRyan NAVION · S/N NAV-4-1431N5040CBeech B35 · S/N D-2302N683CStinson 108 · S/N 1083683N8064SDJI MAVIC PRO · S/N 08QDDC3012035FN2499TPiper PA-38-112 · S/N 38-78A0816N689QPDJI INSPIRE 1 · S/N W13DCD25030274N749APDJI PHANTOM 2 VISION + · S/N PH645244529N33895Aeronca 65-CA · S/N C14281N5015JHelton LARK 95 · S/N 9515N215LSLaird Smith RV-6A · S/N 24756N55ECChatham Robert M RV6-A · S/N 23962N417SCCart Steven LEGEND · S/N 2902N89672Cessna 140 · S/N 8720N5587FHart Pat C MINI-IMP-C · S/N PH-1N18677Cessna 150L · S/N 15074036N17215Cessna 150L · S/N 15073668N8274CPiper PA-22 · S/N 22-2349N488WRRasmussen Wayne KITFOX MODEL 2 · S/N 488N2375UCessna 172D · S/N 17249975N11PSAeronca 7AC · S/N 7AC-3298N1323CCessna 177B · S/N 17702702N645GRRehn Gerald F KITFOX IV · S/N 1700N5455ZPiper PA-22-108 · S/N 22-9233N133SPTanous Gary D SANDPIPER XP-1 · S/N 9510-1003-XP1N8855XCessna 182D · S/N 18253255N3870EAeronca 11AC · S/N 11AC-S-70N6486KRepublic RC-3 · S/N 748N757JMCessna 152 · S/N 15279777N670LTDJI PHANTOM 2 VISION PLU · S/N PH646038001N7055DNorth American AT-6A · S/N 78-7228N918FWright Lail FOKKER DV III · S/N 1918N5043TPiper PA-34-200 · S/N 34-7250208N73SRRiddle R A/Riddle R S RV 4 · S/N 1653N4024EAeronca 11BC · S/N 11BC-112N9819KStinson 108 · S/N 1082819N7249CLockheed PV-2 · S/N 15-1137
Back to Vancouver, WA