Denver, CO
Cancelled registrations · 995
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 = 'DENVER' 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 = 'DENVER' 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.
N940MCCompagnie Daher TBM 700 · S/N 1334N374LACessna 150E · S/N 15061330N81479Aeronca 7AC · S/N 7AC-97N6205RCessna 150E · S/N 15061505N6051TCessna 150D · S/N 15060751N2099JCessna 172S · S/N 172S9586N592CYDJI INSPIRE 1 · S/N W13DCG08040581N162AMCirrus Design SR22 · S/N 2724N134PBeech A36 · S/N E-1527N6700YCameron Balloons US A-140 · S/N 6700N1516HLindstrand Balloons 90A · S/N 5366N284DKLindstrand Balloons 31A · S/N 5203N5232RAerostar International S-57A · S/N S57A-3248N301LPLeptron RDASS · S/N LEP334N311LPLeptron RDASS · S/N LEP336N321LPLeptron RDASS · S/N LEP362N331LPLeptron RDASS · S/N LEP354N341LPLeptron RDASS · S/N LEP376N615ZTDJI PHANTOM 3 ADVANCED · S/N P76DCH12A10192N5135XAerostar International S-57A · S/N S57A-3243N6206VBeech 95-C55 · S/N TE-432N96855Taylorcraft BC12-D · S/N 9155N3584AAerostar International RAVEN S57-A · S/N S57A-3092N5155RAerostar International S-57A · S/N S57A-3244N113KBTextron B300 · S/N FL-1100N5575UPiper PA-28-140 · S/N 28-26304N65661Cameron Balloons US Z-77 · S/N 6602N52339Aerostar International S-60A · S/N S60A3288N67619Fairchild M-62A-4 · S/N T42-4252N840XMDJI INSPIRE 2 · S/N 09YDDC10FR0892N843UMDJI MAVIC AIR · S/N 0K1DF192BD3345N1404RBalony Kubicek Spol Sro BB22E · S/N 766N5318ZDJI FC40 P330D · S/N PH645377853N188PRGates Learjet 25D · S/N 371N280RCameron Balloons Z-70 · S/N 6719N348MMMarrin Michael D SKYBOLT · S/N 001N907TTomlinson Tracy L TUKAN TRIKE · S/N 11760N173TCDJI MAVIC PRO · S/N 08QDE3B01202LYN7003FPiper PA-28-181 · S/N 28-7790175N8154MDJI INSPIRE 2 · S/N 09YDE1C0041556N961AADassault/Sud FAN JET FALCON SER D · S/N 205N549CELeptron Industrial Robotic Hel RDASS · S/N 346-2808-38N25PBBartoe Otto E SKYOTE · S/N 001N64369Stinson L-5 · S/N 76162N5224RAerostar International S-57A · S/N S57A-3246N775HMDJI PHANTOM 4 · S/N 07DDD33 0A10286N7481RPiper PA-28-140 · S/N 28-22033N3035ZPiper PA-22-160 · S/N 22-6989N772XDReady Made RC RMRC ANACONDA - PNP · S/N DU2SRI001N21259Taylorcraft BF · S/N 1052
Back to Denver, CO