Mcminnville, OR
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 = 'OR' AND d.registrant_city = 'MCMINNVILLE' 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 = 'MCMINNVILLE' 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.
N296XRAerovel FLEXROTOR · S/N 0049N908YSSpektreworks COBALT-CR · S/N 502N537TUTekever Uas S A AR3 · S/N 399N372PAHelicopteres Guimbal CABRI G2 · S/N 1150N950SGEurocopter AS332L1 · S/N 9007N369PAHelicopteres Guimbal CABRI G2 · S/N 1109N11261Cessna 150L · S/N 15075281N2009GCessna 182A · S/N 51309N96191Taylorcraft BF · S/N 8491N61EVSikorsky S-61R (CH-3E) · S/N 61566N7929JBell 206B · S/N 663N60EVSikorsky H3 · S/N 69-05799N6565TGoad Adam Robert ADMO · S/N 001N105EHHiller UH-12E · S/N HA3027N470EVBoeing 747-273C · S/N 20653N482EVBoeing 747-212B · S/N 20713N74744Robinson Helicopter R44 II · S/N 10900N5410NBell 212 · S/N 31206N9KCBell 206L-3 · S/N 51061N479EVBoeing 747-132 · S/N 19898N486EVBoeing 747-212B · S/N 20888N487EVBoeing 747-230B · S/N 23286N489EVBoeing 747-230B · S/N 23393N49552Aerospatiale SA316B ALOUETTE III · S/N 2275N11035Hughes Helicopters HUGHES 369D · S/N 900810DN204BBMesserschmitt-Boelkow-Blohm-Gm BO-105C · S/N S-57N204EVLockheed P2V-5 · S/N 128378N205EVLockheed P2V-5 · S/N 128366N57990Sud SA316B ALOUETTE III · S/N 2135N62EVSikorsky HH-3F · S/N 1493N63EVSikorsky HH-3F · S/N 1497N330JAerospatiale SA330J · S/N 1647N3870NBeech 35 · S/N D-1111N110BGHughes Helicopters HUGHES 369D · S/N 610949DN1601GMcdonnell Douglas Helicopter 369E · S/N 0218EN115FHBell 206B · S/N 2737N304HBoeing 757-225 · S/N 22195N198CSStordahl C M JR PROTECH PT-2C · S/N 001N90467Hiller UH-12E · S/N 2354N480EVBoeing 747-121 · S/N 20348N626USBoeing 747-251B · S/N 21708N377AKBoeing 737-200 · S/N 20578N67092Aerospatiale SA316B ALOUETTE III · S/N 2190N703BABoeing 777-236 · S/N 27109N477EVBoeing 747-SR-46 · S/N 20784N484EVBoeing 747-121 · S/N 20352N728EVBoeing 727-78 · S/N 18794N683ALMcdonnell Douglas DC-9-32 · S/N 73-1683N103EHHiller UH-12E · S/N HA3026N475DNMcdonnell Douglas DC-9-82(MD-82) · S/N 53007
Back to Mcminnville, OR