Englewood, CO
Cancelled registrations · 253
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 = 'ENGLEWOOD' 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 = 'ENGLEWOOD' 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.
N240LGDassault FALCON 900 EX · S/N 101N2533UCessna 172D · S/N 17250133N876MALearjet 60 · S/N 193N502EFAero Electric SF100P · S/N 0001N859KVDJI Innovations M1P MAVIC PRO · S/N 08QUE840100LUN6150BLeeds Brad VARIEZE · S/N 30763N3534Beech B100 · S/N BE-49N864DKCirrus Design SR22T · S/N 1973N934SCBombardier BD-700-1A10 · S/N 9034N351AMGates Learjet 35A · S/N 409N9774UGrumman American Avn. AA-5A · S/N AA5A-0174N625LNMesserschmitt-Bolkow-Blohm BK 117 A-4 · S/N 7108N303DXDJI MAVIC PRO · S/N 08QDDBJ01203AWN387GGrumman American Avn. AA-5A · S/N AA5A0387N733XADJI PHANTOM 3 PROFESSION · S/N P78DCL18070434N1STPiper PA-23 · S/N 23-527N74317Eurocopter AS 350 B3 · S/N 4317N89TCGates Lear Jet 35 · S/N 026N135APApollo MONSOON · S/N 00006N620PABell Helicopter Textron Canada 407 · S/N 54610N138HHMesserschmitt-Bolkow-Blohm BK 117 A-4 · S/N 7060N844FDassault-Breguet FALCON 10 · S/N 201N8062KStinson 108 · S/N 1083062N480TMEnstrom Helicopter 480B · S/N 5095N3930CCessna 404 · S/N 404-0003N135MEEurocopter Deutschland EC135P1 · S/N 0009N23AGates Learjet 35A · S/N 233N876MLearjet 31A · S/N 179N234MRGates Learjet 35A · S/N 201N1112CCochrans BUCKSHOT · S/N BC-1N169TMExtra Flugzeugproduktions-Und EA 300/LT · S/N LT007N372JLLearjet 31A · S/N 142N352LNEurocopter AS 350 B2 · S/N 3728N357KMGulfstream Aerospace G-1159A · S/N 435N1709VCessna 120 · S/N 13894N125ECMesserschmitt-Bolkow-Blohm BK 117 A-4 · S/N 7065N222LFBell 222UT · S/N 47528N350GREurocopter AS 350 B2 · S/N 3140N600USMagnaghi Aeronautica SKY ARROW LSA · S/N LSA026N68395Cessna 402C · S/N 402C0484N38KSBeech 95-B55B (T42A) · S/N TF-11N254MBeech A24R · S/N MC-34N758SZCessna R172K · S/N R1723336N203LGBeech B200 · S/N BB-926N11VQAirbus Helicopters EC 130 T2 · S/N 8070N771EMCessna 525A · S/N 525A0217N104TGAviation Technology GRP JAVELIN MODEL 100 · S/N 0001N527MBMesserschmitt-Bolkow-Blohm BK 117 A-4 · S/N 7103N390LGAmerican Eurocopter AS350B3 · S/N 7595N72TPCessna T310R · S/N 310R1628
Back to Englewood, CO