Cancelled registrations · 16

Query with SQL

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 = 'HIGHLANDS RANCH' ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

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 = 'HIGHLANDS RANCH'
  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 = 'HIGHLANDS RANCH'
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.

N10PVPiaggio Aero Industries P180 · S/N 1161Cancelled Sep 28, 2026 · Exported to Canada · Built 2008 · Plc Leasing Company II LLC N501PMPiaggio P180 · S/N 1022Cancelled Nov 5, 2024 · Built 1993 · Plc Leasing Company II LLC N3926UCessna 150E · S/N 15061326Cancelled Feb 16, 2022 · First renewal notice · Built 1965 · Raizada Shashank N763JDDJI SPREADINGWINGS S1000 · S/N 03P0015527Cancelled Feb 3, 2020 · Registration expired, pending cancellation · Dipasquale Rose M N764PDDJI INSPIRE 1 · S/N W13DCA31020104Cancelled Nov 27, 2019 · Registration expired, pending cancellation · Dipasquale Rose M N115LPDJI PHANTOM 3 PROFESSION · S/N P78DCF28030782Cancelled Jul 11, 2019 · Registration expired, pending cancellation · Arcadis US Inc N6117SAir & Space America 18A · S/N 18-23Cancelled May 30, 2018 · Sale reported, canceled N17THHenry Thomas C PITTS SPECIAL S1S · S/N 38814Cancelled Jan 3, 2018 · Registration expired, pending cancellation · Stottlemyer Gary L N1168KLuscombe 8A · S/N 3895Cancelled Jul 7, 2017 · Registration expired, pending cancellation · Built 1946 · May Mark A N75CDCessna 180K · S/N 18053047Cancelled Apr 10, 2017 · Exported to New Zealand · Built 1979 · Olson Scott C N5020BBeech H35 · S/N D-4999Cancelled Mar 19, 2013 · Registration expired, pending cancellation · Built 1957 · Goforth Enterprises N9369ZCessna TU206G · S/N U20606435Cancelled Jun 2, 2011 · Exported to Mexico · Rodriguez Alison C N5289NAerostar International S-60A · S/N S60A-3272Cancelled Feb 7, 2011 · Built 2001 · Dcg & Associates Inc N281Coln-Gregory VARIEZE · S/N 281Cancelled May 21, 2007 · Triennial form not returned · Built 1978 · Coln Gregory R N348PTTierney Francis P RANS S-12 XL · S/N 07960732Cancelled Sep 10, 2001 · Triennial form not returned · Tierney Francis P N20NKSocata TB-20 TRINIDAD · S/N 766Cancelled Nov 24, 1998 · Triennial form not returned · Advantage Flight Training

Back to Highlands Ranch, CO