Skip to content

Cancelled registrations · 22

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 = 'ENNIS' 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 = 'ENNIS'
  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 = 'ENNIS'
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.

N4978ZPiper PA-22-108 · S/N 22-8584Cancelled Oct 30, 2021 · Registration expired, pending cancellation · Built 1961 · Davis James Randall N408PRaytheon A36 · S/N E-3580Cancelled Oct 7, 2020 · Exported to Mexico · Built 2004 · Beard Bramlet N397TBeech D95A · S/N TD-544Cancelled Jan 6, 2020 · Registration expired, pending cancellation · Built 1963 · Berlin Airlift Foundation N5046NBellanca 7GCBC · S/N 1132-79Cancelled Mar 14, 2018 · Registration expired, pending cancellation · Built 1979 · Walker Carol L N5027GBellanca 7GCBC · S/N 1174-79Cancelled Jan 23, 2018 · Registration expired, pending cancellation · Built 1979 · Setian Peter N82952Aeronca 7AC · S/N 7AC1603Cancelled Nov 21, 2017 · Revoked, canceled · Built 1946 · Byers John D N814RBeech K35 · S/N D-5946Cancelled Jun 7, 2017 · Registration expired, pending cancellation · Built 1959 · Laudan Timothy J N5441WPiper PA-28-160 · S/N 28-517Cancelled Sep 19, 2014 · Sale reported, pending cancellation · Built 1962 N8257FCessna 150F · S/N 15064357Cancelled Nov 8, 2013 · Registration expired, pending cancellation · Built 1966 · Ennis Flying Club Inc N9869VCessna 188 · S/N 188-0119Cancelled Sep 19, 2013 · Registration expired, pending cancellation · Built 1966 · Davis Charles Mike N76VRMellema BEDE 4 · S/N 582Cancelled Jan 6, 2010 · Built 1978 · Barney Thomas H N82797Kester BD-4 · S/N 553Cancelled May 20, 2008 · Exported to Canada · Built 1984 · Barney Thomas H II N4315PPiper PA-23-160 · S/N 23-1816Cancelled May 25, 1999 · Exported to Germany · Eisenhuth Albert N45540Cessna 150M · S/N 15076965Cancelled Dec 11, 1996 · Exported to Czech Republic · Red Baron Aviation N7132GCessna 172K · S/N 17258832Cancelled Jul 1, 1986 · Mccormack Robert S N8145FCessna 150F · S/N 15064245Cancelled Jan 19, 1981 · Mason Robert K DBA J & J Specialties N85787Aeronca 7AC · S/N 7AC-4537Cancelled Jun 16, 1976 · W D Bozek N3349WPiper PA-32-260 · S/N 32-190Cancelled Oct 29, 1974 · Ennis Aviation Inc N89272Cessna 140 · S/N 8298Cancelled Sep 9, 1949 · Schanewerk Joe N37372Interstate S-1A · S/N 215Cancelled Sep 15, 1948 · Built 1941 · Williams Seth S N37404Interstate S-1A · S/N 247Cancelled Sep 15, 1948 · Built 1942 · Williams Seth S N34936Interstate S-1A · S/N 31Cancelled Sep 10, 1948 · Williams Seth S

Back to Ennis, TX