Skip to content

Cancelled registrations · 21

Query with SQL

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 = 'SCAPPOOSE' ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

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 = 'SCAPPOOSE'
  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 = 'SCAPPOOSE'
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.

N2322JBeech 23 · S/N M-252Cancelled Sep 10, 2024 · Revoked, canceled · Built 1963 · Peters Paul S N68PWExtra Flugzeugbau EA 300/S · S/N 030Cancelled Apr 3, 2021 · Registration expired, pending cancellation · Built 1999 · Precision Aerosports LLC N50KFPiper PA-22-150 · S/N 22-4274Cancelled Sep 4, 2020 · Registration expired, pending cancellation · Built 1956 · N50kf LLC N852SCJames A Vanek SPORTCOPTER II · S/N SC008Cancelled May 2, 2020 · Registration expired, pending cancellation · Vanek James A N583SCSport Copter SPORT COPTER SUPERSP · S/N 001Cancelled May 1, 2020 · Registration expired, pending cancellation · Built 2007 · Sport Copter Inc N56072Mccallum Fred F/Lt Miniatureac LIGHT MINIATURE 1X · S/N 1014Cancelled Jul 14, 2017 · Registration expired, pending cancellation · Built 1990 · Cousins Scott R N7525KPiper PA-18 · S/N 18-241Cancelled Apr 13, 2017 · Registration expired, pending cancellation · Built 1950 · Gordon Glen R N74333Bellanca 14-13-2 · S/N 1446Cancelled Feb 4, 2017 · Revoked, canceled · Built 1947 · Adams Robert J N2098VFuji LM II · S/N 21052Cancelled Oct 29, 2013 · Registration expired, pending cancellation · Built 1983 · Cedar Point Hom N1168Fortney David SPORT COPTER VORTEX · S/N 137Cancelled Oct 25, 2013 · Registration expired, pending cancellation · Fortney David N91131Cessna T207 · S/N 20700086Cancelled Jul 3, 2013 · Registration expired, pending cancellation · Built 1969 · T-207 Corp N378BRRush Bradley D VORTEX · S/N 046Cancelled Jun 12, 2013 · Registration expired, pending cancellation · Built 2000 · Rush Bradley D N8804DPiper PA-22 · S/N 22-5972Cancelled Nov 15, 2012 · Sale reported, pending cancellation · Built 1958 N5749LBell 206B · S/N 3089Cancelled Sep 14, 2009 · Triennial form not returned · Built 1980 · Cascade Commerical Helicopters Inc N61887Vanek James SPORT COPTER · S/N 070Cancelled Apr 9, 2001 · Triennial form not returned · Vanek James A N4381NWilliams R L / Gearhardt J GILES G-202 · S/N G202028Cancelled May 8, 1998 · Exported to New Zealand · Akrotech Aviation Inc N838TGGift Tobias Earl CHALLENGER II · S/N CH20492B0838Cancelled Mar 24, 1997 · Triennial form not returned · Gift Tobias E N1607GChampion 7KCAB · S/N 111Cancelled Sep 18, 1970 · Leffler Irvin N9342KStinson 108-2 · S/N 108-2342Cancelled May 30, 1948 · Cody-Wrecking Aero Service N49139Taylorcraft DCO-65 · S/N 0-4279Cancelled Aug 19, 1947 · Cody Wiecking Aero Service N12732Trtek Joe TRTEK CHURCH MIDWING · S/N 50Cancelled Aug 2, 1934 · Built 1932 · Trtek Joseph

Back to Scappoose, OR