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.
N100NGExtra Flugzeugproduktions UND EXTRA NG · S/N NG001N6993QGrumman Acft ENG Cor-Schweizer G-164B · S/N 340BN15BVDJI PHANTOM 3 PROFESSION · S/N CE282041384948N17BVDJI S900 · S/N 0370061048N20BVDJI PHANTOM 3 PROFESSION · S/N P76DCH07016497N40BVDJI PHANTOM 2 · S/N PH646062574N73053Cessna 140 · S/N 10265N230VSAeryon Labs SKY RANGER · S/N SKU-100001-00 SR4021325N231VSAeryon Labs SKY RANGER · S/N SKU-100001-00 SR2023487N7092URobinson Helicopter R22 BETA · S/N 2944N4085TRobinson Helicopter R22 BETA · S/N 1841N9059BChampion 7FC · S/N 7FC-147N622BVTarot 650 SPORT · S/N AIST6501N6117CMuegerl Larry D AEROTRIKE COBRA · S/N 05N112JSStevens Jerrold B NIEUPORT 11 · S/N 003N115BV3D Robotics SOLO · S/N S111A5901287N117BVDJI INSPIRE 1 · S/N W21ACJ23010673N811BVDJI MATRICE 100 · S/N M02DCI12020163N812BVDJI MATRICE 100 · S/N M02DCI12020164N815BVSensefly EXOM · S/N EX-01-29880N680RU3D Robotics SOLO · S/N S111A5602893N680TU3D Robotics SOLO · S/N S111A5602450N680YV3D Robotics IRIS+ · S/N IRS1515900042N6815UDJI PHANTOM 2 · S/N PH646026225N28BVDJI PHANTOM 2 · S/N PH646065697N16BV3D Robotics IRIS+ · S/N IRS143370017N68BVDJI MATRICE 100 · S/N M02DCI01020081N905BV3D Robotics SOLO · S/N S111A5701151N906BVDJI PHANTOM 3 PROFESSION · S/N P76DCG18066438N907BVDJI PHANTOM 2 VISION + · S/N PH645396387N26BV3D Robotics IRIS+ · S/N IRS1433700291N18BV3D Robotics SOLO · S/N S111A5605339N35BVDJI PHANTOM 3 PROFESSION · S/N P76DCG02016724N37BVDJI FLAMEWHEEL F550 · S/N 84414UN585RSDJI PHANTOM 3 PROFESSION · S/N P76DCF19014066N799TADJI PHANTOM 2 · S/N PH645433992N579EUDJI PHANTOM 2 · S/N PH646028959N6939KPiper PA-20 · S/N 20-43N532BWOregon State Univ Ais Lab MATRIX · S/N AISM001N543WUHoneycomb AGDRONE · S/N AISAD001N3004EAeronca 7AC · S/N 7AC-6590N811JEHytek HURRICANE · S/N 530-98HTN532DUChris Mcvey GWAIHIR · S/N AISG001N5322VHiller UH-12C · S/N 874N47GMPiper PA-34-200 · S/N 34-7350224N96331Taylorcraft BC12-D · S/N 8631N303PRRobinson Helicopter R22 BETA · S/N 1039N4258Cessna U206E · S/N U20601692N109SHPiper PA-22-160 · S/N 22-5963N23032Cessna 150H · S/N 15068690
Back to Corvallis, OR