Skip to content

Central Point, OR

Cancelled registrations · 53

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 = 'CENTRAL POINT' 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 = 'CENTRAL POINT'
  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 = 'CENTRAL POINT'
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.

N6924GCompagnie Daher TBM 700 · S/N 1377Cancelled Aug 14, 2023 · Blum Family Dynasty Inc N9395KStinson 108-2 · S/N 108 2395Cancelled Mar 4, 2023 · Registration expired, pending cancellation · Campbell Duncan B N426XOwen Lee Gossett CCX-2000 · S/N CCX-2000-0141Cancelled Jun 29, 2022 · Exported to New Zealand · Built 2022 · Gossett Owen Lee N12037Whittman Tailwind 8-W MODIFIED · S/N 1001Cancelled Dec 20, 2019 · Sale reported, canceled · Built 1964 N913ACErickson Air Crane S-64E · S/N 64025Cancelled Dec 19, 2019 · Exported to South Korea · Erickson Inc N229ACErickson S64E · S/N 64018Cancelled Nov 29, 2019 · Registration expired, pending cancellation · Built 2001 · Erickson Inc N915ACErickson Air Crane S-64E · S/N 64043Cancelled Nov 21, 2019 · Exported to South Korea · Erickson Inc N4722Crouse FLY BABY 1-A · S/N 65-56Cancelled Sep 6, 2019 · Sale reported, canceled · Built 1970 N625KHDJI PHANTOM 3 PROFESSION · S/N P76DCH08016318Cancelled May 1, 2019 · Registration expired, pending cancellation · Heberleen Christopher J N7FAAmerican AA-1A · S/N AA1A-0334Cancelled Mar 6, 2018 · Registration expired, pending cancellation · Built 1972 · Dietz Albert C N7428PPiper PA-24-250 · S/N 24-2616Cancelled Feb 23, 2018 · Registration expired, pending cancellation · Built 1961 · Pleatman Douglas T N236ACErickson S-64F · S/N 64089Cancelled Nov 14, 2016 · Third renewal notice · Built 1970 · Erickson Inc N385EHBell 212 · S/N 30730Cancelled Feb 24, 2016 · Exported to Canada · Erickson Inc N386EHBell Helicopter Textron 212 · S/N 35064Cancelled Feb 24, 2016 · Exported to Canada · Erickson Inc N39392Beech D17S · S/N 6875Cancelled Mar 19, 2015 · Registration expired, pending cancellation · Built 1954 · Harbour John L N9432YBeech 35-A33 · S/N CD-286Cancelled Nov 24, 2014 · Registration expired, pending cancellation · Built 1961 · Rodrigues James D N95322Taylorcraft BC12-D · S/N 9722Cancelled Aug 8, 2013 · Sale reported, canceled · Built 1946 N69426Beech D17S · S/N 6718Cancelled May 23, 2013 · Registration expired, pending cancellation · Harbour John L N68659Aero-Ace CE 1 · S/N 11721Cancelled May 2, 2013 · Registration expired, pending cancellation · Built 1961 · Mcculloch James D N3716Schweizer TH55A/269A · S/N 291102Cancelled Sep 20, 2012 · Sale reported, canceled N264SDSchweizer TH55A/269A · S/N 380799Cancelled Sep 5, 2012 · Registration pending, canceled N8829HNorth American NAVION · S/N NAV-4-829Cancelled Jul 31, 2012 · Registration pending, canceled · Built 1947 N49298Meadowlark Ultralight C II · S/N 030Cancelled Sep 12, 2011 · First renewal notice · Built 1984 · Crippen Jerry N N3614DCessna 310 · S/N 35314Cancelled Jul 8, 2011 · Revoked, canceled · Built 1956 · West Coast Shot Mfg Co N100MADouglas DC3C-S1C3G · S/N 20180Cancelled Nov 23, 2010 · Sale reported, pending cancellation N788ACEurocopter AS 350 BA · S/N 2259Cancelled Jul 26, 2010 · Exported to Malaysia · Built 1989 · Erickson Air-Crane Inc N248ACErickson S64E · S/N 64066Cancelled Apr 6, 2009 · Triennial form not returned · Built 1968 · Erickson Air Crane Inc N149ACGarlick Helicopters UH-1H · S/N 5229Cancelled Sep 5, 2008 · Exported to Australia · Built 1966 · Erickson Air Crane Inc N126ACGarlick Helicopters UH-1H · S/N 5645Cancelled May 30, 2008 · Triennial form not returned · Built 1966 · Erickson Air Crane Inc N245ACErickson S64E · S/N 64027Cancelled Oct 5, 2007 · Exported to South Korea · Built 2007 · Erickson Air-Crane Inc N25854Cessna 152 · S/N 15280819Cancelled Jul 9, 2007 · Exported to Philippines · Built 1977 · Jordan Aircraft Services Inc N174ACErickson S-64F · S/N 64080Cancelled Apr 18, 2007 · Exported to Italy · Built 2006 · Erickson Air-Crane Inc N28AFNorth American/Armoflex T-28B · S/N 138321Cancelled Jan 23, 2007 · Triennial form not returned · Coffman Ron D N4099LErickson S64E · S/N 64038Cancelled Nov 28, 2006 · Exported to South Korea · Built 2006 · Erickson Air Crane Inc N197ACErickson S-64F · S/N 64067Cancelled May 24, 2006 · Exported to Italy · Built 1969 · Erickson Air-Crane Inc N198ACErickson S-64F · S/N 64098Cancelled May 24, 2006 · Exported to Italy · Built 1970 · Erickson Air-Crane Inc N227ACErickson S-64F · S/N 64078Cancelled May 24, 2006 · Exported to Italy · Built 1969 · Erickson Air Crane Inc N213ACErickson S-64F · S/N 64088Cancelled Feb 28, 2006 · Exported to Italy · Built 1970 · Erickson Air-Crane Inc N223ACSikorsky S-64F · S/N 64086Cancelled Mar 31, 2004 · Triennial form not returned · Built 1969 · Erickson Air-Crane Inc N4149PPiper PA-23-160 · S/N 23-1631Cancelled Oct 21, 2002 · Triennial form not returned · Built 1959 · Burns Johnnie L N4099BErickson S64E · S/N 64019Cancelled Jan 23, 2002 · Exported to South Korea · Built 1967 · Erickson Air-Crane Inc N6959RSikorsky S-64E · S/N 64002Cancelled Mar 2, 2001 · Triennial form not returned · Erickson Air Crane Co LLC N165ACSikorsky S-64F · S/N 64085Cancelled Mar 1, 2001 · Triennial form not returned · Erickson Air Crane Co LLC N6965RSikorsky S-64E · S/N 64060Cancelled Apr 1, 1999 · Built 1968 · Erickson Air-Crane Co LLC N9741NBell 206B · S/N 2041Cancelled Dec 28, 1994 · Exported to Malaysia · Erickson Air-Crane Co N11UELockheed 1329 · S/N 5038Cancelled Dec 10, 1992 · Erickson Aircrane Co N9118MSikorsky S-61N · S/N 61702Cancelled Jan 9, 1991 · Exported to South Africa · Erickson Aircraft Leasing Co N1630XCessna 210L · S/N 21060666Cancelled Dec 28, 1977 · Jazdzewski Terrence & Candace DBA Jet Realty N2853GBeech C-45G · S/N AF-188Cancelled Sep 30, 1977 · Myers Jon W N2066QCessna 177RG · S/N 177RG0466Cancelled Jun 16, 1975 · Simco Engineering Co

Back to Central Point, OR