Skip to content

Cancelled registrations · 18

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 = 'TX' AND d.registrant_city = 'THE COLONY' 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 = 'TX' AND d.registrant_city = 'THE COLONY'
  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 = 'TX' AND d.registrant_city = 'THE COLONY'
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.

N238SHPrince David L GLASAIR SH-2 · S/N 238Cancelled Mar 4, 2023 · Registration expired, pending cancellation · Built 2007 · Henricks Michael R N141MMMagnino Mark S SONERAI II · S/N 01414LCancelled Jun 14, 2022 · Registration expired, pending cancellation · Built 1989 · Magnino Mark S N51YFFaas C Jack LOEHLE 5151 · S/N 679113Cancelled Jan 9, 2021 · Registration expired, pending cancellation · Faas C Jack N751XDGryphon Dynamics GD-6 · S/N GD6001Cancelled Oct 5, 2019 · Registration expired, pending cancellation · Chopper Shots Imaging LLC N652BMMinicopter JOKER 3 · S/N MJ3001Cancelled Jun 29, 2019 · Registration expired, pending cancellation · Chopper Shots Imaging LLC N653HC3D Robotics SOLO · S/N S111A5601509Cancelled Jun 29, 2019 · Registration expired, pending cancellation · Ua Tacsolutions LLC N1917FFokker D-7 · S/N 1Cancelled Feb 9, 2018 · Registration expired, pending cancellation · Built 1967 · Kelly Donald M N2417DPiper PA-38-112 · S/N 38-79A0304Cancelled Feb 22, 2017 · Registration expired, pending cancellation · Built 1978 · Lutts Robin R N2311HBalloon Works FIREFLY 7 · S/N 7748Cancelled Sep 16, 2014 · Registration expired, pending cancellation · Built 1978 · Foster Fred N7552Schweizer SGS 2-33A · S/N 182Cancelled Jul 23, 2013 · Registration expired, pending cancellation · Built 1970 · Planes Of History Inc N7611EBellanca 14-19-3 · S/N 4113Cancelled May 8, 2013 · Registration expired, pending cancellation · Built 1959 · Lanning John N6874ECessna 175A · S/N 56374Cancelled May 2, 2013 · Registration expired, pending cancellation · Built 1959 · Murphy William J N6038XMooney M20A · S/N 1629Cancelled Apr 25, 2013 · Registration expired, pending cancellation · Built 1960 · Phillips David N68TTThompson Thomas N DRAGONFLY · S/N 896Cancelled Jun 7, 2012 · Registration expired, pending cancellation · Thompson Thomas N N234EZLangley VARI-EZE · S/N 1521Cancelled Nov 4, 2008 · Triennial form not returned · Built 1979 · Norris Robert E N218EEiben Theodore Q-2 · S/N 2735Cancelled Sep 11, 2008 · Triennial form not returned · Built 1987 · Magnino Mark S N68TTBrooks Dale C KOSAN #39 · S/N 1Cancelled Mar 18, 1992 · Thompson Thomas N N57127Raven S55A · S/N S55A670Cancelled Dec 11, 1991 · Triennial form not returned · Blue Sky Adventures

Back to The Colony, TX