Skip to content

Cancelled registrations · 39

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

N199VPYoumans Michael Scott RV-3A · S/N 1Cancelled Jun 7, 2025 · Registration pending, canceled N324SBBryner Sheldon E JUST ACFT HIGHLANDER · S/N JAESC0158Cancelled Nov 6, 2020 · Registration pending, canceled · Built 2008 N7655CPiper PA-28-181 · S/N 28-7690072Cancelled Aug 10, 2018 · Registration expired, pending cancellation · Built 1975 · Bailey David Scott N2126HErcoupe 415-D · S/N 2749Cancelled May 30, 2018 · Sale reported, canceled · Built 1946 N3286XCessna 310L · S/N 310L-0136Cancelled Mar 13, 2018 · Registration expired, pending cancellation · Built 1967 · Bailey David Scott N59419Taylorcraft DCO-65 · S/N L-5702Cancelled Feb 16, 2018 · Registration expired, pending cancellation · Built 1944 · Hardin Stephen M N99977Ercoupe 415-C · S/N 2600Cancelled Feb 13, 2018 · Registration expired, pending cancellation · Built 1946 · Hardin Stephen M N59DDKillough PITTS SPECIAL · S/N 798001Cancelled Jan 25, 2018 · Registration expired, pending cancellation · Built 1974 · Washburn Tom N331EJJantzen EVANS VP · S/N P15Cancelled Sep 18, 2017 · Registration expired, pending cancellation · Built 1972 · King Grady W N17693Boeing A75 · S/N 75-6528Cancelled May 18, 2015 · Registration expired, pending cancellation · Built 1942 · Phillips Airfield Inc N735BVCessna 182Q · S/N 18265303Cancelled May 14, 2015 · Sale reported, canceled · Built 1976 N312GCCessna 340A · S/N 340A0023Cancelled Nov 6, 2014 · First renewal notice · Built 1975 · Parrish James M N5470EAlon A2 · S/N A-4Cancelled Aug 20, 2013 · Sale reported, canceled · Built 1965 N2199WDouglas Brian G RW 133 SCORPION II · S/N BGD002Cancelled Aug 13, 2013 · Sale reported, canceled N2463NPiper PA-38-112 · S/N 38-79A0853Cancelled Aug 7, 2013 · Registration expired, pending cancellation · Built 1979 · Hamby Wesley R N45JFGulfstream American AA-5B · S/N AA5B0954Cancelled May 10, 2013 · Exported to Canada · Built 1978 · Furstenberg James G N119AZCessna 182T · S/N 18281293Cancelled Jul 12, 2011 · Exported to Australia · Built 2003 · Martin Steven Ray N6459GCessna 150K · S/N 15071959Cancelled Feb 3, 2010 · Exported to Argentina · Built 1970 · Yarborough Dennis K N10088Cessna 150L · S/N 15074784Cancelled Jan 27, 2006 · Triennial form not returned · Built 1973 · Imaginary Lines Inc N45880Luscombe 8A · S/N 2407Cancelled May 20, 2003 · Triennial form not returned · Built 1946 · Stacey Larson H N117DHCessna 195 · S/N 7358Cancelled Mar 4, 1999 · Exported to Denmark · Waters Thomas L N5514WPiper PA-28-160 · S/N 28608Cancelled Apr 14, 1993 · Triennial form not returned · Beesley Glen Jr N4811PPiper PA-23-250 · S/N 27377Cancelled Mar 26, 1991 · Triennial form not returned · Wallace Aero Inc N4387NCessna 190 · S/N 7018Cancelled Jul 29, 1980 · Morgan Kenneth R N98799Piper J3C-65 · S/N 19038Cancelled Jun 27, 1973 · Criswell L G N2691CCessna 310 · S/N 35091Cancelled Jun 21, 1973 · Morran Carl R N8785YPiper PA-30 · S/N 30-1943Cancelled Aug 4, 1971 · Exported to Australia · Tom Norton Inc N5966DPiper PA-22-150 · S/N 22-4631Cancelled Jan 27, 1971 · Boettcher H H Md N33599Piper J3C-65 · S/N 14076Cancelled Feb 20, 1956 · Lewis J E N4491NBoeing N2S-5 · S/N 75-8084Cancelled Jul 25, 1952 · Wallace Matthew A N75801Cessna T-50 · S/N 6447Cancelled Oct 23, 1951 · Anderson Hotels System N39323Aeronca 65-TAC · S/N C3162TACancelled Apr 16, 1951 · Curtis Jesse K N9332KStinson 108-2 · S/N 108-2332Cancelled Feb 1, 1951 · Barnes H C N7441KPiper PA-20 · S/N 20-352Cancelled Jan 18, 1951 · Jarvis Barney W N9787KStinson 108-2 · S/N 108-2787Cancelled Jan 16, 1951 · Alexander G H N70848Piper J3C-65 · S/N 17864Cancelled Jun 7, 1949 · Matthew A Wallace N88531Piper J3C-65 · S/N 16156Cancelled Apr 7, 1949 · Jackson Melvin W N88532Piper J3C-65 · S/N 16157Cancelled Apr 7, 1949 · Jackson Melvin W N15826Rearwin 8500 · S/N 450Cancelled Aug 5, 1948 · Built 1936 · Foster Monroe D

Back to Terrell, TX