Skip to content

Gainesville, TX

Cancelled registrations · 42

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

N690JDDuggan Jerry Frank BD-4 · S/N 690Cancelled Jun 4, 2025 · Built 1993 · Duggan Jerry F N2945SCessna 150G · S/N 15066845Cancelled Nov 23, 2024 · Sale reported, canceled · Built 1967 N144LADevorak James PULSAR · S/N 144Cancelled Nov 5, 2022 · Registration expired, pending cancellation · Built 1990 · Brown Mitchel L N3655SAir Tractor AT-301 · S/N 301-0298Cancelled Nov 5, 2022 · Registration expired, pending cancellation · Built 1980 · North Texas Dusters & Sprayers Inc N5824SBeech 95-B55 (T42A) · S/N TC-832Cancelled Jul 31, 2021 · Registration expired, pending cancellation · Built 1964 · Victory Jet Inc N713DGBeech 95-B55 (T42A) · S/N TC-518Cancelled Jan 11, 2021 · Registration expired, pending cancellation · Built 1963 · Victory Jet Inc N93605Ercoupe 415-C · S/N 928Cancelled Sep 6, 2019 · Revoked, canceled · Built 1946 · Cooke County Flying Club Inc N65077RFD DOMINATOR ULTRAWHITE · S/N 2Cancelled Mar 9, 2019 · Registration expired, pending cancellation · Built 2004 · Whiddon Mark H N158WMMoster Wayne R R.A.F. 2000 GTX · S/N H2-95-6-161Cancelled Feb 9, 2019 · Registration expired, pending cancellation · Built 2000 · Moster Wayne R N1563QCessna 150L · S/N 15072863Cancelled Jan 14, 2019 · Registration expired, pending cancellation · Built 1971 · Walk Michael F N4914NBoeing B75N1 · S/N 758289Cancelled Mar 15, 2018 · Registration expired, pending cancellation · Built 1943 · Bailey Ronnie R N4874NBoeing E75 · S/N 75-5280Cancelled Mar 8, 2018 · Registration expired, pending cancellation · Bailey Ronnie R N266MBBeech A65 · S/N LC-265Cancelled Jan 12, 2018 · Registration expired, pending cancellation · Built 1967 · Mcbride Forest Edward DBA N65WEBeech 65 · S/N LC-230Cancelled Jun 30, 2017 · Registration expired, pending cancellation · Built 1966 · Mcbride Forest E DBA N80935Sabre Trike With Areo Wing TRIKE · S/N 2000.075Cancelled May 31, 2017 · Registration expired, pending cancellation · Ebner Aloysius N360LKachergius Robert Edward LANCAIR 320 · S/N 460Cancelled Mar 21, 2017 · Registration expired, pending cancellation · Elkins Matthew Cal N81CTCessna 150L · S/N 15075771Cancelled Sep 14, 2016 · Exported to Bolivia · Built 1974 · Webb Sandy L N94627Ercoupe 415-G · S/N 4728Cancelled Nov 24, 2014 · Registration expired, pending cancellation · Built 1947 · Diviney H Ernie N8949DPiper PA-22-160 · S/N 22-6107Cancelled Aug 20, 2014 · Built 1958 · Stahl Richard J N2883SCessna 150G · S/N 15066783Cancelled Oct 23, 2013 · Registration expired, pending cancellation · Built 1967 · Biffle Ernest D N2060YSlocum Robert A RAND ROBINSON KR-2 · S/N KR 5707Cancelled Sep 20, 2013 · Registration expired, pending cancellation · Louderback Donald M N98BHHook Bert KINGFISHER · S/N 91Cancelled Jul 29, 2013 · Registration expired, pending cancellation · Built 1987 · Hetsel Gene A N818LWCessna 172 · S/N 36343Cancelled May 13, 2013 · Registration expired, pending cancellation · Built 1958 · Hawkins Paul L N1587QCessna 150L · S/N 15072887Cancelled Apr 11, 2013 · Registration expired, pending cancellation · Built 1971 · Gainesville Aircraft Services Inc N87131Ercoupe 415-C · S/N 304Cancelled Mar 7, 2013 · Sale reported, canceled · Built 1946 N1170Leachman-Jodel D-11-M · S/N L-1Cancelled Jun 4, 2012 · Sale reported, canceled · Built 1966 N1371ECessna 172N · S/N 17270973Cancelled Aug 28, 1999 · Triennial form not returned · Kinney Ray N4739BCessna 152 · S/N 15283610Cancelled Dec 10, 1982 · Built 1979 · Rgnonti Frank DBA Gainesville Aircraft Services N7797ACessna 180A · S/N 32694Cancelled Aug 16, 1963 · Neal K R N62417Boeing B75N1 · S/N 75-7006Cancelled Feb 15, 1956 · Osborne Tim H N8332ACessna 170 · S/N 25184Cancelled Dec 12, 1955 · Schmitz F E N1848MDouglas DC3C-S1C3G · S/N 20750Cancelled Dec 10, 1953 · Exported to Chile · Built 1943 · Witbeck Aircraft Corporation N1943Douglas DC3 · S/N 3268Cancelled Oct 7, 1953 · Exported to Chile · Witbeck Aircraft Corporation N18952Douglas DC3 · S/N 2016Cancelled Jul 30, 1953 · Exported to Ecuador · Built 1937 · Witbeck Aircraft Corporation N18954Douglas DC3 · S/N 2028Cancelled Jul 6, 1953 · Exported to Ecuador · Built 1938 · Witbeck Aircraft Corporation N361Douglas DC-3A-S1C3G · S/N 4470Cancelled May 6, 1953 · Exported to Chile · Witbeck Aircraft Inc N2683VCessna 170 · S/N 18367Cancelled Feb 25, 1953 · Greenwood F H N49549Douglas DC3A · S/N 11702Cancelled Feb 11, 1953 · Witback Aircraft Corporation N75774Cessna T-50 · S/N 4376Cancelled Jan 31, 1951 · Exported to Mexico · Osborne Aviation Corp N37402Interstate S-1A · S/N 245Cancelled Aug 30, 1948 · Built 1942 · Hester Evelyn W N47936Taylorcraft L-2B · S/N 4580Cancelled Sep 4, 1947 · Garrett R H (Jack)N17626Glider CHEROKEE II · S/N 1Cancelled Aug 15, 1939 · Morre Robert Lee

Back to Gainesville, TX