Skip to content

Cancelled registrations · 56

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

N95WEBlackshape BK160 · S/N BCV.21009Cancelled Jul 15, 2026 · Exported to Italy · Gulf State Aviation LLC N398DWElan/Glaser Dirks DG-300 ELAN · S/N 3E484A26Cancelled May 29, 2024 · Exported to Canada · Built 1998 · Rasch Hellmut G N139GSBreda Nardi Hughes NH500MC · S/N 25-0278Cancelled Feb 7, 2024 · Exported to Philippines · Gulf State Aviation LLC N160GSBreda Nardi Hughes NH500MC · S/N 21-0270Cancelled Feb 7, 2024 · Exported to Philippines · Gulf State Aviation Inc N164GSBreda Nardi Hughes NH500MC · S/N 40Cancelled Feb 7, 2024 · Exported to Philippines · Gulf State Aviation Inc N669TXJames E Heldt WHITMAN TAILWIND · S/N 1121Cancelled Feb 4, 2023 · Registration expired, pending cancellation · Heldt James E N488FCDesmon Don Butts TITANIUM EXPLORER · S/N 0025-0416Cancelled Nov 5, 2022 · Registration expired, pending cancellation · Built 2016 · Butts Desmon D N128LNEurocopter AS 350 B2 · S/N 3989Cancelled Apr 6, 2022 · Exported to Panama · Gulf State Aviation Inc N900UMMD Helicopters MD 900 · S/N 900-00112Cancelled Aug 13, 2020 · Exported to Austria · Built 2006 N315AMNew Piper PA-32R-301T · S/N 3257439Cancelled Jan 31, 2020 · Registration expired, pending cancellation · Built 2006 · Vanlue Duke N464KFTextron 510 · S/N 510-0464Cancelled May 24, 2019 · Exported to Canada · Built 2015 · Kyle Aviation LLC N81453Bell UH-1H · S/N 3214Cancelled Jan 29, 2018 · Registration expired, pending cancellation · Built 1968 · Peacocke John N9015RGriggs Robert SINGLE PLACE · S/N RG52600Cancelled Jul 14, 2017 · Registration expired, pending cancellation · Griggs Robert G N9047WPiper PA-28-235 · S/N 28-10639Cancelled Nov 24, 2014 · Registration expired, pending cancellation · Built 1965 · Blanton Larry N2424ZGeneral Balloon AX-6 · S/N 424Cancelled Sep 19, 2014 · Registration expired, pending cancellation · Built 1978 · Coleman Larry E N2185NCessna 140 · S/N 12421Cancelled Sep 16, 2014 · Registration expired, pending cancellation · Built 1947 · Patch Roy A N1926HPiper PA-28-161 · S/N 28-7716064Cancelled Sep 10, 2014 · Registration expired, pending cancellation · Built 1977 · Hamlin Anthony E N911PDBell OH-58C · S/N 69-16106Cancelled Mar 19, 2014 · Third renewal notice · Peacocke John P N35LHIsrael Aircraft Industries 1124 · S/N 413Cancelled Nov 21, 2013 · Sale reported, pending cancellation · Built 1985 N810VCIsrael Aircraft Industries 1124 · S/N 321Cancelled Aug 8, 2013 · Sale reported, canceled · Built 1981 N95JCPitts S-1T · S/N 004Cancelled Aug 6, 2013 · Sale reported, canceled · Built 1977 N77VTSchleicher ASW-15 · S/N 15032Cancelled Jul 29, 2013 · Built 1969 · Sortino Anthony T N7100RChampion 8GCBC · S/N 359-84Cancelled Jun 11, 2013 · Registration expired, pending cancellation · Champion Aircraft Co Inc N61PDBell OH-58C · S/N 68-16737Cancelled Jun 7, 2013 · Registration expired, pending cancellation · Peacocke John P N206HBell 206A · S/N 263Cancelled Jun 6, 2013 · Registration expired, pending cancellation · Built 1968 · Burts Leonard Burts N94487Cessna 152 · S/N 15285687Cancelled Nov 27, 2012 · Sale reported, pending cancellation · Built 1982 N3953HMooney M20J · S/N 24-0991Cancelled Nov 14, 2012 · Registration expired, pending cancellation · Built 1980 · Houston Northwest Aviation Inc N4651PCessna 152 · S/N 15284792Cancelled Aug 27, 2012 · Registration pending, canceled · Built 1980 N800DXAllseitz Edwin A JR EUROPA MONOWHEEL · S/N A089Cancelled Aug 23, 2012 · Registration expired, pending cancellation · Allseitz Edwin A Jr N15150Balloon Works FIREFLY 7-B · S/N 11004Cancelled Aug 6, 2012 · Registration expired, pending cancellation · Built 1981 · Mclaughlin Gerard C N7101RChampion 7ECA · S/N 1353-84Cancelled Oct 13, 2011 · Expired dealer · Champion Aircraft Co Inc N358GDehavilland DH104 DOVE 6BA · S/N 04362Cancelled Jul 15, 2011 · Expired dealer · Built 1952 · Lake 4 Sales Corp N7101DChampion 8KCAB · S/N 643-84Cancelled Jul 7, 2011 · Expired dealer · Champion Aircraft Co Inc N46887Cessna 152 · S/N 15283132Cancelled Mar 1, 1999 · A B Aviation Inc N3740HMooney M20J · S/N 240917Cancelled Aug 3, 1998 · Triennial form not returned · Duchesneau Darrell A N4983VAlson-Bruce HOMEBUILT · S/N 0022Cancelled May 22, 1996 · Second triennial mailing, no response · Alson Burce T N1635FCessna 172H · S/N 17255030Cancelled Aug 17, 1992 · Triennial form not returned · Flores Mike S N2730FCessna 182J · S/N 18256830Cancelled Jun 16, 1992 · Exported to Mexico · Pfafman Frederick V N85ADSkipton Donald E QUICKIE 2 · S/N 2666Cancelled Feb 27, 1992 · Skipton Donald E N2314SRobinson Helicopter R22 BETA · S/N 1893Cancelled Dec 13, 1991 · Exported to United Kingdom · Richardson Robert N37720Gulfstream American AA-5B · S/N AA5B-1213Cancelled Sep 13, 1982 · Exported to Australia · Built 1979 · Intran USA Inc N3536KPiper PA-31-350 · S/N 31-7952208Cancelled Apr 15, 1981 · Exported to Mexico · Built 1979 · Houston Northwest Aviation Inc N20395Cessna 172M · S/N 17261255Cancelled Feb 23, 1979 · Exported to Canada · Seaback Aviation Corp N2686PConsolidated Aeronautics LAKE LA-4-200 · S/N 893Cancelled May 8, 1978 · Exported to Finland · Consolidated Aeronautics Inc N116MMPiper PA-28R-201T · S/N 28R-7703193Cancelled Feb 14, 1978 · Built 1977 · Munroe Dallas F N1951QCessna 177RG · S/N 177RG0351Cancelled Oct 29, 1975 · Built 1973 · Seaback Aviation Corp N1062LLake LA-4-200 · S/N 655Cancelled Feb 5, 1975 · Exported to Finland · Lake 4 Sales Corp N9109TBeech A23-24 · S/N MA-328Cancelled Apr 24, 1974 · Built 1968 · Hooks Charles G Jr N65623Aerofab LA-4-200 · S/N 568Cancelled Aug 16, 1973 · Exported to Canada · Lake 4 Sale Corp N2012TThurston TSC-1A · S/N 12Cancelled Sep 8, 1972 · Exported to Canada · Built 1970 · Lake-4 Sales Corp

Back to Tomball, TX