Boulder, CO

Cancelled registrations · 262

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

N313ALRobinson Helicopter R44 II · S/N 10056Cancelled Sep 16, 2014 · Registration expired, pending cancellation · Built 2003 · Flying Dog Helicopters LLCN1666HPiper PA-34-200T · S/N 34-7770132Cancelled Sep 10, 2014 · Registration expired, pending cancellation · Win Air IncN2031HBalloon Works FIREFLY 7 · S/N 782Cancelled Sep 10, 2014 · Registration expired, pending cancellation · Built 1977 · Levin DavidN4093FRocky Mountain Flygh BUCCANEER 11 B2B · S/N B2B-K039Cancelled Nov 4, 2013 · Registration expired, pending cancellation · Built 1995 · Rocky Mountain FlyghN3140UBell UH-1H · S/N 71-20310Cancelled Oct 29, 2013 · Registration expired, pending cancellation · Built 1971 · Pan American Partners LLCN74773Mooney M20B · S/N 1773Cancelled Oct 24, 2013 · Registration expired, pending cancellation · Built 1961 · Radke Lawrence FN225HACessna 150L · S/N 15074094Cancelled Aug 27, 2013 · Sale reported, canceled · Built 1972N234HACessna 150J · S/N 15070503Cancelled Aug 13, 2013 · Sale reported, canceled · Built 1969N813RBlackmore Richard H RV-4 · S/N RV4-813Cancelled Aug 8, 2013 · Sale reported, canceled · Built 1985N4346LPiper PA-46-310P · S/N 46-8408038Cancelled Jul 30, 2013 · Registration expired, pending cancellation · Built 1984 · High Winds IncN25130Scherer SCAMP WT16-3 · S/N 747Cancelled Jul 18, 2013 · Registration expired, pending cancellation · Built 1981 · Scherer David RN81281Fairchild 24R-46 · S/N R46-181Cancelled Jul 16, 2013 · Sale reported, canceled · Built 1946N24428Taylorcraft BL-65 · S/N 1764Cancelled Jul 9, 2013 · Registration expired, pending cancellation · Built 1940 · Stevens Jane OrmsbyN69280Avionautica Rio M-100S · S/N 064Cancelled Jul 9, 2013 · Registration expired, pending cancellation · Built 1966 · Longs Peak Sailplane Club IncN7530ALindstrand Balloons 120A · S/N 5237Cancelled Jul 9, 2013 · Registration expired, pending cancellation · Built 2003 · Kohler KevinN78843Piper PA-11 · S/N 11-1642Cancelled Jul 8, 2013 · Registration expired, pending cancellation · Built 1948 · Rigg John RN6893WPiper PA-28-140 · S/N 28-21051Cancelled Jul 2, 2013 · Registration expired, pending cancellation · Built 1965 · Bennett Josiah IN53481Hotchkiss Mark R LAZAIR · S/N A815Cancelled Jun 7, 2013 · Registration expired, pending cancellation · Hotchkiss Mark RN5178DJennings Ronald V ULTRAPUP · S/N 1223Cancelled Jun 5, 2013 · Sale reported, canceled · Built 2002N4400FRaven S55A · S/N S55A-1044Cancelled May 13, 2013 · Registration expired, pending cancellation · Built 1984 · Huntington Lewis RN7950RBeech V35A · S/N D-8968Cancelled May 9, 2013 · Registration expired, pending cancellation · Built 1969 · Floor Dennis DBAN6794FCessna 150F · S/N 15063394Cancelled May 2, 2013 · Registration expired, pending cancellation · Built 1966 · Reynolds William W DBAN5713ERaven S55A · S/N S55A-673Cancelled Apr 23, 2013 · Registration expired, pending cancellation · Built 1980 · Aragon Lorin VN558SBBeech D50E · S/N DH-347Cancelled Apr 22, 2013 · Registration expired, pending cancellation · Built 1963 · Biometric Resort Development CorpN23JCCessna 150H · S/N 15068033Cancelled Apr 15, 2013 · Registration expired, pending cancellation · Built 1967 · 23jc LLCN2421WSchweizer SGS 2-32 · S/N 40Cancelled Apr 11, 2013 · Registration expired, pending cancellation · Built 1966 · Miller Bruce AN46193Cessna 152 · S/N 15283013Cancelled Mar 18, 2013 · Registration expired, pending cancellation · Built 1978 · Alphin Donald WN801CPiper PA-31T · S/N 31T-7620048Cancelled Feb 27, 2013 · Sale reported, canceled · Built 1976N707NALockheed NC-130B · S/N 58-0712Cancelled Feb 20, 2013 · Sale reported, canceled · Built 1958N6477NCessna T210N · S/N 21063051Cancelled Feb 13, 2013 · Sale reported, canceled · Built 1978N554HAPiper PA-28-151 · S/N 28-7715134Cancelled Jan 31, 2013 · Sale reported, canceled · Built 1976N331CFPilatus PC-12/45 · S/N 331Cancelled Jan 17, 2013 · Exported to Canada · Cerretani Aviation Group LLCN60JGClassic WACO YMF · S/N F5-019Cancelled Jan 2, 2013 · Exported to New Zealand · Built 1988 · Annecharico Arthur LN4047SBalloon Works FIREFLY 7 · S/N 7904Cancelled Nov 15, 2012 · Registration expired, pending cancellation · Built 1979 · Lalan JackN4049LBalloon Works FIREFLY 6 · S/N 6746Cancelled Nov 15, 2012 · Registration expired, pending cancellation · Levin David NN40550Balloon Works FIREFLY 7 · S/N 10134Cancelled Nov 15, 2012 · Registration expired, pending cancellation · Built 1981 · Levin David NN307CBCameron Balloons V-77 · S/N 343Cancelled Nov 6, 2012 · Registration expired, pending cancellation · Built 1979 · Finnoff ChrisN33977Schweizer SGS 2-33A · S/N 387Cancelled Oct 3, 2012 · Registration expired, pending cancellation · Built 1975 · Miller Bruce AN29639Taylorcraft BC12-65 · S/N 2504Cancelled Sep 24, 2012 · Registration expired, pending cancellation · Built 1941 · Noe Noel RN5717GCessna 150K · S/N 15071217Cancelled Aug 27, 2012 · Revoked, canceled · Built 1969 · Bennett Josiah IN47789Cessna T337D · S/N 337-0992Cancelled Aug 7, 2012 · Revoked, canceled · Built 1969 · Van Duren PaulN28TWNorth American T-28A · S/N 51-3616Cancelled Jul 6, 2012 · Registration expired, pending cancellation · Built 1951 · 844th Squadon IncN43991Taylorcraft BC · S/N 6610Cancelled Jun 27, 2012 · Revoked, canceled · Built 1945 · Guadagno James RN41RLPiper PA-23-250 · S/N 27-3374Cancelled Jun 4, 2012 · Revoked, canceled · Built 1966 · James Michael FN1088QPiper PA-28-181 · S/N 28-7790375Cancelled May 7, 2012 · Exported to Canada · Built 1977 · Journeys Aviation IncN2650KRolladen-Schneider LS-4 · S/N 4202Cancelled Apr 3, 2012 · Exported to Canada · Built 1981 · Brack JosephN4242British Aerospace BAE 125 SERIES 800A · S/N NA0453Cancelled Sep 15, 2011 · Exported to Mexico · Built 1990 · Two Trees Holdings LLCN6404XCessna TU206G · S/N U20605869Cancelled Jul 15, 2011 · Expired dealer · Built 1980 · Business Aircraft Sales CorpN767TEurocopter EC120B · S/N 1168Cancelled Jul 6, 2011 · Exported to Brazil · Built 2000 · Hummingbird Aviation LLCN29197Cessna T210L · S/N 21059831Cancelled Jun 30, 2011 · Expired dealer · Built 1973 · Dakota Ridge Aircraft
Back to Boulder, CO