Greeley, CO

Cancelled registrations · 501

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 = 'CO' AND d.registrant_city = 'GREELEY'
  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.

N944BCRobinson Helicopter R44 II · S/N 13484Cancelled Feb 24, 2024 · Sale reported, canceled · Built 2013N182VACessna 182S · S/N 18280235Cancelled Feb 17, 2024 · Sale reported, canceled · Built 1998N2148JPiper PA-28RT-201T · S/N 28R-7931012Cancelled Feb 3, 2024 · Sale reported, canceled · Built 1978N719TFRobinson Helicopter R44 II · S/N 10990Cancelled Feb 3, 2024 · Sale reported, canceled · Built 2005N75MKCessna 172M · S/N 17265649Cancelled Jan 27, 2024 · Sale reported, canceled · Built 1975N1HHBeech F33A · S/N CE-611Cancelled Jan 13, 2024 · Sale reported, canceled · Built 1975N25WXCessna 182Q · S/N 18266453Cancelled Jan 13, 2024 · Sale reported, canceled · Built 1978N8983MBeech 35-B33 · S/N CD-733Cancelled Jan 13, 2024 · Sale reported, canceled · Built 1964N91177Cessna A188B · S/N 18802023Cancelled Jan 13, 2024 · Sale reported, canceled · Built 1975N5103VCessna 172RG · S/N 172RG0451Cancelled Dec 30, 2023 · Sale reported, canceled · Built 1980N1082VCessna R172K · S/N R1722110Cancelled Dec 26, 2023 · Sale reported, canceled · Built 1976N3209UCessna 182F · S/N 18254609Cancelled Dec 26, 2023 · Sale reported, canceled · Built 1963N4171WPiper PA-32-300 · S/N 32-40250Cancelled Dec 26, 2023 · Sale reported, canceled · Built 1967N5213ZCessna 162 · S/N 16200040Cancelled Dec 26, 2023 · Sale reported, canceled · Built 2011N66NCCessna 421C · S/N 421C0519Cancelled Dec 26, 2023 · Sale reported, canceled · Built 1978N80YDBeech S35 · S/N D-7394Cancelled Dec 26, 2023 · Sale reported, canceled · Built 1964N2104SPiper PA-32RT-300 · S/N 32R-7985087Cancelled Dec 11, 2023 · Sale reported, canceledN5340RCessna 172F · S/N 17252868Cancelled Dec 11, 2023 · Sale reported, canceled · Built 1965N8980ZCessna 310G · S/N 310G0080Cancelled Dec 11, 2023 · Sale reported, canceled · Built 1962N711DACessna 172N · S/N 17268365Cancelled Nov 27, 2023 · Sale reported, canceled · Built 1976N7783GCessna 172L · S/N 17259483Cancelled Nov 27, 2023 · Sale reported, canceled · Built 1970N804NDPiper PA-28R-201 · S/N 2837004Cancelled Nov 27, 2023 · Sale reported, canceled · Built 1988N42764Piper PA-28-151 · S/N 28-7415399Cancelled Oct 28, 2023 · Sale reported, canceled · Built 1974N5213KCessna 162 · S/N 16200038Cancelled Oct 7, 2023 · Sale reported, canceled · Built 2011N7337ACessna 172 · S/N 29437Cancelled Oct 7, 2023 · Sale reported, canceled · Built 1957N33022Piper PA-32-300 · S/N 32-7540081Cancelled Sep 25, 2023 · Sale reported, canceled · Built 1975N1333CCessna 177B · S/N 17702704Cancelled Sep 16, 2023 · Sale reported, canceled · Built 1977N4702LPiper PA-28-180 · S/N 28-4016Cancelled Sep 16, 2023 · Sale reported, canceled · Built 1967N6076CCessna 162 · S/N 16200229Cancelled Sep 16, 2023 · Sale reported, canceled · Built 2013N3322SCessna 210J · S/N 21059122Cancelled Jul 18, 2023 · Exported to Mexico · Built 1969N543ASPiper PA-24-250 · S/N 24-3250Cancelled Jul 1, 2023 · Sale reported, canceledN63SCessna T337G · S/N P3370161Cancelled Jul 1, 2023 · Sale reported, canceled · Built 1973N7116LRobinson Helicopter R22 BETA · S/N 2993Cancelled Jun 26, 2023 · Sale reported, canceled · Built 1999N9277JPiper PA-28-180 · S/N 28-3356Cancelled May 27, 2023 · Sale reported, canceled · Built 1966N713KJCessna 172F · S/N 17252406Cancelled May 20, 2023 · Sale reported, canceled · Built 1964N6211VRockwell International 112A · S/N 327Cancelled May 15, 2023 · Sale reported · Built 1975N46MDPiper PA-28-181 · S/N 28-7790247Cancelled Apr 29, 2023 · Sale reported, canceled · Built 1976N91096Cessna 207 · S/N 20700071Cancelled Apr 22, 2023 · Sale reported, canceled · Built 1969N4328PAyres S2R-T34 · S/N T41-154DCCancelled Apr 18, 2023 · Sale reported, canceled · Built 1991N1582TCessna 414 · S/N 414-0362Cancelled Mar 28, 2023 · Sale reported, canceled · Built 1972N5968ACessna 172 · S/N 28568Cancelled Mar 28, 2023 · Sale reported, canceledN4643FPiper PA-28R-200 · S/N 28R-7635432Cancelled Jan 19, 2023 · Sale reported · Built 1976N443SHRobinson Helicopter R44 II · S/N 10306Cancelled Jan 14, 2023 · Sale reported, canceled · Built 2004N5765NMooney M20J · S/N 24-1482Cancelled Jan 14, 2023 · Sale reported, canceled · Built 1984N7480FHughes 269C · S/N 170570Cancelled Jan 14, 2023 · Sale reported, canceled · Built 1977N7654SBellanca 8KCAB · S/N 250-76Cancelled Dec 29, 2022 · Sale reported, canceled · Built 1976N7814KCessna 180J · S/N 18052748Cancelled Nov 29, 2022 · Registration pending, canceled · Built 1976N656STPiper PA-28-181 · S/N 2843656Cancelled Oct 12, 2022 · Sale reported, canceled · Built 2007N734NWCessna 172N · S/N 17268993Cancelled Mar 19, 2022 · Sale reported, canceled · Built 1977N970ARCessna 210L · S/N 21060106Cancelled Mar 8, 2022 · Exported to Mexico · Bas Part Sales LLC
Back to Greeley, CO