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.
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
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.
N313ALRobinson Helicopter R44 II · S/N 10056N1666HPiper PA-34-200T · S/N 34-7770132N2031HBalloon Works FIREFLY 7 · S/N 782N4093FRocky Mountain Flygh BUCCANEER 11 B2B · S/N B2B-K039N3140UBell UH-1H · S/N 71-20310N74773Mooney M20B · S/N 1773N225HACessna 150L · S/N 15074094N234HACessna 150J · S/N 15070503N813RBlackmore Richard H RV-4 · S/N RV4-813N4346LPiper PA-46-310P · S/N 46-8408038N25130Scherer SCAMP WT16-3 · S/N 747N81281Fairchild 24R-46 · S/N R46-181N24428Taylorcraft BL-65 · S/N 1764N69280Avionautica Rio M-100S · S/N 064N7530ALindstrand Balloons 120A · S/N 5237N78843Piper PA-11 · S/N 11-1642N6893WPiper PA-28-140 · S/N 28-21051N53481Hotchkiss Mark R LAZAIR · S/N A815N5178DJennings Ronald V ULTRAPUP · S/N 1223N4400FRaven S55A · S/N S55A-1044N7950RBeech V35A · S/N D-8968N6794FCessna 150F · S/N 15063394N5713ERaven S55A · S/N S55A-673N558SBBeech D50E · S/N DH-347N23JCCessna 150H · S/N 15068033N2421WSchweizer SGS 2-32 · S/N 40N46193Cessna 152 · S/N 15283013N801CPiper PA-31T · S/N 31T-7620048N707NALockheed NC-130B · S/N 58-0712N6477NCessna T210N · S/N 21063051N554HAPiper PA-28-151 · S/N 28-7715134N331CFPilatus PC-12/45 · S/N 331N60JGClassic WACO YMF · S/N F5-019N4047SBalloon Works FIREFLY 7 · S/N 7904N4049LBalloon Works FIREFLY 6 · S/N 6746N40550Balloon Works FIREFLY 7 · S/N 10134N307CBCameron Balloons V-77 · S/N 343N33977Schweizer SGS 2-33A · S/N 387N29639Taylorcraft BC12-65 · S/N 2504N5717GCessna 150K · S/N 15071217N47789Cessna T337D · S/N 337-0992N28TWNorth American T-28A · S/N 51-3616N43991Taylorcraft BC · S/N 6610N41RLPiper PA-23-250 · S/N 27-3374N1088QPiper PA-28-181 · S/N 28-7790375N2650KRolladen-Schneider LS-4 · S/N 4202N4242British Aerospace BAE 125 SERIES 800A · S/N NA0453N6404XCessna TU206G · S/N U20605869N767TEurocopter EC120B · S/N 1168N29197Cessna T210L · S/N 21059831
Back to Boulder, CO