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.
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
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.
N41665Piper PA-34-200 · S/N 34-7450146N811MSPiper PA-28R-201 · S/N 2837042N79110Cessna 172N · S/N 17268131N2101YCessna 172D · S/N 17249601N444MYYelich Mark STARDUSTER SA-100 · S/N 857N949TAColumbia Aircraft Mfg LC41-550FG · S/N 41751N4661NCessna 402C · S/N 402C0019N172CSCessna 172M · S/N 17262260N970BLCessna 210L · S/N 21059734N9895ACessna 195A · S/N 7598N261KKCirrus Design SR20 · S/N 2261N1330JRockwell International 112A · S/N 330N377SBRockwell International 112B · S/N 526N195BGCessna 195 · S/N 7652N13245Cessna 172M · S/N 17262606N3164KAir Tractor AT-301 · S/N 301-0535N573BVCessna A185F · S/N 18502177N5256QCessna 150L · S/N 15073156N4504LRobinson Helicopter R44 II · S/N 13084N2880WPiper PA-32R-301 · S/N 32R-8013002N666WWBeech 35-B33 · S/N CD-572N185WKCessna 185 · S/N 18503196N3320SCessna 210J · S/N 21059120N606JACessna 172S · S/N 172S8767N114ALRockwell International 114 · S/N 14023N46212Cessna 152 · S/N 15283015N6900YPiper PA-23-250 · S/N 27-4254N3600ABeech A36 · S/N E-1328N5XTTomlin Thomas E MODEL 4-SPEEDSTER · S/N ACS-094N1881NCessna 120 · S/N 12125N154MECessna 172S · S/N 172S8534N4246ZRobinson Helicopter R44 II · S/N 12697N50507Cessna 150J · S/N 15069354N6284XCessna 182T · S/N 18282105N2128BPiper PA-44-180 · S/N 44-7995096N9007YPiper PA-31-310 · S/N 31-11N9033RCessna TR182 · S/N R18200657N553CMCessna 310R · S/N 310R0169N10292DJI PHANTOM 3 PROFESSION · S/N P78DCL22071095N10313DJI PHANTOM 3 PROFESSION · S/N P78DCJ14061820N95773Taylorcraft BC12D-85 · S/N 8073N7306CAir Tractor AT-301 · S/N 301-0606N376JCessna T310R · S/N 310R-0668N59323Boeing A75N1(PT17) · S/N 751849N36490Taylorcraft DC-65 · S/N 4164N24MECessna 172S · S/N 172S8463N650YCDJI PHANTOM 3 PROFESSION · S/N P76DCE20016856N2350SCessna T210L · S/N 21061252N6501SDJI PHANTOM 3 PROFESSION · S/N P76DCF23016695N7149WPiper PA-28-180 · S/N 28-957
Back to Greeley, CO