Corvallis, OR
Cancelled registrations · 126
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 = 'OR' AND d.registrant_city = 'CORVALLIS' 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 = 'OR' AND d.registrant_city = 'CORVALLIS' 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.
N73BVBellanca 17-31ATC · S/N 73-31066N9219SHammer Tom VARIEZE · S/N 1718N210XDAmerican Champion 8KCAB · S/N 1132-2013N5554KRaven Industries RALLY RX7 · S/N RX7-116N991TPPettit Thomas E SAVANNAH · S/N 04-06-51-297N6402JPiper PA-28-180 · S/N 28-4818N1960WBeech B19 · S/N MB-622N52980Daleo Norman C RANS S-14 · S/N 0392017N8539JCessna 150G · S/N 15066439N737SGCessna TR182 · S/N R18200878N2341JRobinson Helicopter R22 BETA · S/N 2187N7179QMason Bob QUICKSILVER MX II · S/N 1097N6156UAviation International Rotors CH-54A · S/N 66-18410N243WJBell 214ST · S/N 28127N1915RRaven Industries RX6 · S/N RX6-293N51714Baierl David W RANS S-6ES COYOTE II · S/N 0492290N86129Elkay UFO-9 · S/N L-1N733FPolizzotto Gary DR PULSAR · S/N 121N620HAHispano Aviacion HA-200 SAETA · S/N E.14A-20N8ZHHiller UH-12D · S/N 1051N75EBruer PITTS S-1C · S/N JLB-12N70065Ponnequin Craig R N 3 PUP · S/N N85596-11N421TBCessna 421A · S/N 421A0056N310RCCessna T310Q · S/N 310Q0212N4418QCessna 172M · S/N 17261701N13841Piper PA-23-250 · S/N 27-4482N919GHawkins John RAN S-6 · S/N 0196916ESN66632Waco UPF-7 · S/N 5585N4ZHBell 206B · S/N 170N5599ACessna 177RG · S/N 177RG-1108N144SGRepublic RC-3 · S/N 51N758JYCessna R172K · S/N R1723144N6380HHinde Frank George ZENITH ZODC CH601HDS · S/N 63599N46560Robinson Helicopter R44 · S/N 0407N6070KRepublic RC-3 · S/N 250N91270Wachs Gary Michael ROTORWAY EXEC · S/N 3090N512HHRobinson Helicopter R22 BETA · S/N 0548N101PRRobinson Helicopter R22 BETA · S/N 0936N525BWRobinson Helicopter R22 BETA · S/N 2358N8627BCessna 172 · S/N 36327N5121PPederson Earl C SILHOUTTE I · S/N 227N277MBStearns ER BD-4 · S/N 4469N7193Mclagan DRUINE TURBULENT D31 · S/N 136N2ZHBell 47J-2A · S/N 3110N9410LAmerican AA-1A · S/N AA1A-0210N2535PPiper PA-38-112 · S/N 38-79A1018N5675YPiper PA-23-250 · S/N 27-2790N9753MMooney M20C · S/N 670047N51989Ridings Douglas D PDQ-2 MOD C · S/N S2N6ZHHiller UH-12E · S/N 1624
Back to Corvallis, OR