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.
N944BCRobinson Helicopter R44 II · S/N 13484N182VACessna 182S · S/N 18280235N2148JPiper PA-28RT-201T · S/N 28R-7931012N719TFRobinson Helicopter R44 II · S/N 10990N75MKCessna 172M · S/N 17265649N1HHBeech F33A · S/N CE-611N25WXCessna 182Q · S/N 18266453N8983MBeech 35-B33 · S/N CD-733N91177Cessna A188B · S/N 18802023N5103VCessna 172RG · S/N 172RG0451N1082VCessna R172K · S/N R1722110N3209UCessna 182F · S/N 18254609N4171WPiper PA-32-300 · S/N 32-40250N5213ZCessna 162 · S/N 16200040N66NCCessna 421C · S/N 421C0519N80YDBeech S35 · S/N D-7394N2104SPiper PA-32RT-300 · S/N 32R-7985087N5340RCessna 172F · S/N 17252868N8980ZCessna 310G · S/N 310G0080N711DACessna 172N · S/N 17268365N7783GCessna 172L · S/N 17259483N804NDPiper PA-28R-201 · S/N 2837004N42764Piper PA-28-151 · S/N 28-7415399N5213KCessna 162 · S/N 16200038N7337ACessna 172 · S/N 29437N33022Piper PA-32-300 · S/N 32-7540081N1333CCessna 177B · S/N 17702704N4702LPiper PA-28-180 · S/N 28-4016N6076CCessna 162 · S/N 16200229N3322SCessna 210J · S/N 21059122N543ASPiper PA-24-250 · S/N 24-3250N63SCessna T337G · S/N P3370161N7116LRobinson Helicopter R22 BETA · S/N 2993N9277JPiper PA-28-180 · S/N 28-3356N713KJCessna 172F · S/N 17252406N6211VRockwell International 112A · S/N 327N46MDPiper PA-28-181 · S/N 28-7790247N91096Cessna 207 · S/N 20700071N4328PAyres S2R-T34 · S/N T41-154DCN1582TCessna 414 · S/N 414-0362N5968ACessna 172 · S/N 28568N4643FPiper PA-28R-200 · S/N 28R-7635432N443SHRobinson Helicopter R44 II · S/N 10306N5765NMooney M20J · S/N 24-1482N7480FHughes 269C · S/N 170570N7654SBellanca 8KCAB · S/N 250-76N7814KCessna 180J · S/N 18052748N656STPiper PA-28-181 · S/N 2843656N734NWCessna 172N · S/N 17268993N970ARCessna 210L · S/N 21060106
Back to Greeley, CO