OpenAirDocs.org
Grants Pass, OR

Cancelled registrations · 138

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 = 'GRANTS PASS'
  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.

N9830BBellanca 14-19-2 · S/N 4082Cancelled Jul 30, 2022 · Registration expired, pending cancellation · Built 1958 · Swanland Robert CN39GLNord STAMPE SV4C · S/N 17Cancelled Oct 2, 2021 · Registration expired, pending cancellation · Built 1966 · Gentry Robert MN9062ZBalloon Works FIREFLY 8B · S/N F8B-329Cancelled Jan 11, 2021 · Registration expired, pending cancellation · Built 1991 · Wilkinson Steve AN8322GCessna 150F · S/N 15062422Cancelled Oct 31, 2020 · Registration expired, pending cancellation · Built 1965 · Southern Oregon Aviation LLCN302DCCroy Barbara / Croy Daniel D KR-2M · S/N 1613-2Cancelled Oct 3, 2020 · Registration expired, pending cancellation · Built 1992 · Croy Jana MN69LXLindstrand Balloons 69X · S/N 5293Cancelled Oct 3, 2020 · Registration expired, pending cancellation · Built 2005 · Wilkinson SteveN15091Balloon Works FIRE FLY 10 · S/N F10-2002Cancelled May 29, 2020 · Registration expired, pending cancellation · Built 2001 · Wilkinson SteveN6718BDJI INSPIRE 1 · S/N W13DCG25040171Cancelled Oct 5, 2019 · Registration expired, pending cancellation · Commander Chris Barnett PcN671ZBDJI PHANTOM 3 PROFESSION · S/N P76DCE14011458Cancelled Oct 5, 2019 · Registration expired, pending cancellation · Commander Chris Barnett PcN9583SChampion 7ECA · S/N 7ECA-372Cancelled Mar 7, 2019 · Registration expired, pending cancellation · Built 1965 · Stonebrook Robert EN7870UCessna 172F · S/N 17251870Cancelled Feb 25, 2019 · Registration expired, pending cancellation · Built 1964 · Cessna 7870u LLCN152BSCessna 152 · S/N 15283553Cancelled Aug 24, 2018 · Exported to Philippines · Built 1979 · Afs IncN6083DCirrus Design SR22 · S/N 0612Cancelled Jul 26, 2018 · Registration pending · Built 2003N870SWOregon Department Of Forestry CENTURYRADIKAL G30V2 · S/N 20400139Cancelled Jun 8, 2018 · Registration expired, pending cancellation · Oregon Dept Of ForestryN871SWOregon Department Of Forestry ALIGN TREX 700 · S/N 20144009784Cancelled Jun 8, 2018 · Registration expired, pending cancellation · Oregon Dept Of ForestryN1568QCessna 150L · S/N 15072868Cancelled May 30, 2018 · Sale reported, canceledN19NWSosna Philip APACHE · S/N NW1Cancelled Mar 13, 2018 · Registration expired, pending cancellation · Built 2002 · Morgan Terry LN4383JPiper PA-28-140 · S/N 28-22770Cancelled Mar 13, 2018 · Registration expired, pending cancellation · Built 1967 · Lewis Kendall TN8167BSikorsky S-61A · S/N 61137Cancelled Feb 23, 2018 · Registration expired, pending cancellation · Carson Helicopters IncN42626Sikorsky S-61R · S/N 61522Cancelled Feb 13, 2018 · Registration expired, pending cancellation · Carson Helicopters IncN4263FSikorsky S-61R · S/N 61533Cancelled Feb 13, 2018 · Registration expired, pending cancellation · Carson Helicopters IncN6981RSikorsky S-61L · S/N 61453Cancelled Feb 12, 2018 · Registration expired, pending cancellation · Built 1972 · Carson Helicopters IncN1782CKolb FIRESTAR · S/N 12767Cancelled Feb 9, 2018 · Registration expired, pending cancellation · Built 1999 · Hankins Roger PN81692Sikorsky S-61A · S/N 61074Cancelled Feb 9, 2018 · Registration expired, pending cancellation · Carson Helicopters IncN1593MCessna T210M · S/N 21061949Cancelled Feb 8, 2018 · Registration expired, pending cancellation · Built 1977 · Nance James HN87580Sikorsky S-61N · S/N 61465Cancelled Feb 7, 2018 · Registration expired, pending cancellation · Built 1969 · Carson Helicopters IncN124DDDarby Erwin A/Darby Jean M THORP S 18 · S/N 91Cancelled Feb 6, 2018 · Registration expired, pending cancellation · Built 1996 · Darby Erwin AN19PMMooney M20C · S/N 2687Cancelled Jan 11, 2018 · Registration expired, pending cancellation · Built 1964 · Arnold Mathew RN1522WFirefly Balloons GALAXY 11B · S/N GLX-1211BCancelled Jan 10, 2018 · Registration expired, pending cancellation · Built 2002 · Wilkinson Steve AN92590Sikorsky S-61D · S/N 61351Cancelled Jan 10, 2018 · Registration expired, pending cancellation · Carson Helicopters IncN9271ASikorsky S-61D · S/N 61449Cancelled Jan 10, 2018 · Registration expired, pending cancellation · Carson Helicopters IncN81725Sikorsky HSS-2 · S/N 148050Cancelled Jan 9, 2018 · Registration expired, pending cancellation · Carson Helicopters IncN82702Sikorsky S-61D · S/N 61432Cancelled Jan 9, 2018 · Registration expired, pending cancellation · Carson Helicopters IncN9260ASikorsky S-61D · S/N 61442Cancelled Jan 9, 2018 · Registration expired, pending cancellation · Carson Helicopters IncN51014Sikorsky S-61R · S/N 61515Cancelled Jan 8, 2018 · Registration expired, pending cancellation · Carson Helicopoters IncN5102ZSikorsky S-61R · S/N 61518Cancelled Jan 8, 2018 · Registration expired, pending cancellation · Carson Helicopters IncN618PASikorsky S-61L · S/N 61426Cancelled Jan 5, 2018 · Registration expired, pending cancellation · Built 1968 · Carson Helicopters IncN454PGSikorsky SH-3G · S/N 151545Cancelled Jan 4, 2018 · Registration expired, pending cancellation · Carson Helicopters IncN454USSikorsky SH-3A · S/N 151553Cancelled Jan 4, 2018 · Registration expired, pending cancellation · Carson Helicopters IncN454VASikorsky SH-3A · S/N 149682Cancelled Jan 4, 2018 · Registration expired, pending cancellation · Carson Helicopters IncN454WGSikorsky SH-3G · S/N 148996Cancelled Jan 4, 2018 · Registration expired, pending cancellation · Carson Helicopters IncN454XSSikorsky SH-3G · S/N 151555Cancelled Jan 4, 2018 · Registration expired, pending cancellation · Carson Helicopters IncN454YSSikorsky SH-3A · S/N 149922Cancelled Jan 4, 2018 · Registration expired, pending cancellation · Carson Helicopters IncN454ZGSikorsky SH-3G · S/N 151536Cancelled Jan 4, 2018 · Registration expired, pending cancellation · Carson Helicopters IncN302YSikorsky/Carson Services S61N · S/N 61472CCancelled Jan 3, 2018 · Registration expired, pending cancellation · Carson Helicopters IncN2184YFirefly Balloons GALAXY 11B · S/N GLX-1511BCancelled Jan 2, 2018 · Registration expired, pending cancellation · Built 2005 · Wilkinson Steve AllanN609TBZalusky Robert F AEROGARE SEA HAWK · S/N 108Cancelled Oct 27, 2017 · Registration expired, pending cancellation · Built 1985 · Ketelsen Irvin CN2001GFirefly Balloons FIREFLY 9B-15 · S/N F9B-2015Cancelled Oct 26, 2017 · Registration expired, pending cancellation · Built 2006 · Wilkinson Steve AN8170VSikorsky S-61A · S/N 61232Cancelled Oct 26, 2017 · Registration expired, pending cancellation · Carson Helicopters IncN31733Carson Helicopters / Sikorsky S61A · S/N 61236Cancelled Sep 26, 2017 · Registration expired, pending cancellation · Carson Helicopters Inc
Back to Grants Pass, OR