Skip to content

Cancelled registrations · 139

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

N9030ZBrantly B-2B · S/N 2014Cancelled Dec 15, 2025 · Sale reported, canceled N3982SCessna 172E · S/N 17251182Cancelled Jun 24, 2025 · Built 1964 · Stone Don Edwin N2402GPiper PA-38-112 · S/N 38-79A0518Cancelled May 2, 2025 · Stone Don E N499AKAviat A-1C-180 · S/N 3396Cancelled Jan 14, 2025 · Exported to Canada · Built 2022 · Allen Douglas Matthew N3503TSix Chuter LEGEND · S/N DE2956Cancelled Mar 2, 2024 · Registration pending, canceled · Built 2003 N364AMAircraft Mfg & Development CH 2000 · S/N 201058Cancelled Jan 14, 2023 · Built 2005 · Joint Flight LLC N801ECCessna 340A · S/N 340A0312Cancelled Dec 31, 2022 · Registration expired, pending cancellation · Weatherspoon William J N9459LAmerican AA-1A · S/N AA1A-0259Cancelled Dec 31, 2022 · Registration expired, pending cancellation · Built 1971 · Mounce Chris R N4456CDestiny Powered Parachutes DESTINY 2000 · S/N 2C0382Cancelled Sep 8, 2022 · Registration expired, pending cancellation · Built 2002 · Satterwhite Sammy D N6377KCessna 150M · S/N 15077674Cancelled Jul 2, 2022 · Registration expired, pending cancellation · Built 1975 · Nutt Michael G N40LU3D Robotics IRIS+ · S/N IRS1502200689Cancelled Jan 8, 2022 · Registration expired, pending cancellation · Letourneau University N42LU3D Robotics AERO · S/N R251627258-2Cancelled Jan 8, 2022 · Registration expired, pending cancellation · Letourneau University N564GCSensefly EBEE RTK · S/N ER-01-28033Cancelled Oct 9, 2021 · Sale reported, canceled N41LU3D Robotics AERO · S/N R251627258-1Cancelled Sep 4, 2021 · Registration expired, pending cancellation · Letourneau University N1302MCessna T207A · S/N 20700667Cancelled May 8, 2021 · Registration expired, pending cancellation · Grubbs Jerry M N8065SCessna 150F · S/N 15061665Cancelled Nov 27, 2020 · Sale reported, canceled · Built 1965 N9449TCessna 210 · S/N 57249Cancelled Apr 15, 2020 · Exported to China · Built 1960 N622STSci.Aero PTY CYBERQUAD · S/N QM-AF24MP-161Cancelled Sep 6, 2019 · Sale reported, canceled N753DZSci.Aero PTY CYBERQUAD MAXI · S/N QM-AFEOIR-167Cancelled Sep 6, 2019 · Sale reported, canceled N1378EAeronca 7AC · S/N 7AC4939Cancelled Mar 9, 2019 · Revoked, pending cancellation · Built 1946 · Brown Nellis L N9742LBeech C23 · S/N M-1370Cancelled Sep 14, 2018 · Registration expired, pending cancellation · Built 1971 · Fleener Mike N7774UCessna 172E · S/N 17251774Cancelled Jun 26, 2018 · Registration pending, canceled · Built 1964 N9582LGrumman American Avn. AA-5 · S/N AA5-0582Cancelled Apr 4, 2018 · Registration expired, pending cancellation · Built 1974 · Mahan Brian D N8015TCessna 175A · S/N 56715Cancelled Mar 29, 2018 · Registration expired, pending cancellation · Built 1960 · Blalock Paul T N6051YPiper PA-23-250 · S/N 27-3241Cancelled Mar 14, 2018 · Registration expired, pending cancellation · Built 1966 · Gillespie R David N9426TCessna 210 · S/N 57226Cancelled Mar 13, 2018 · Registration expired, pending cancellation · Built 1959 · Gillespie Suzanne B N97214Stinson 108 · S/N 108-214Cancelled Mar 8, 2018 · Registration expired, pending cancellation · Built 1946 · Fountain Clarence Eugene N795TCThunder & Colt Airborne Amer AX7-65S1 · S/N 2453USACancelled Mar 6, 2018 · Registration expired, pending cancellation · Built 1994 · Gauthier Guy G N8046QHughes TH-55A · S/N 64-18136Cancelled Feb 26, 2018 · Registration expired, pending cancellation · Letourneau University N1659VCessna 140 · S/N 13831Cancelled Feb 8, 2018 · Registration expired, pending cancellation · Built 1947 · Letourneau University N4455GDestiny Powered Parachutes DESTINY 2000 · S/N 2C0366Cancelled Jan 23, 2018 · Registration expired, pending cancellation · Built 2002 · Cooper Thomas G N3961KPiper PA-28-140 · S/N 28-23841Cancelled Jan 19, 2018 · Registration expired, pending cancellation · Built 1967 · Ross Veldon C N3000LLindstrand Balloons 60A · S/N 5054Cancelled Jan 3, 2018 · Registration expired, pending cancellation · Built 1998 · Ashby Rick N6321ZAerostar International RAVEN S49A · S/N S49A-3013Cancelled Oct 27, 2017 · Registration expired, pending cancellation · Sides Mark R N974SARaytheon 58 · S/N TH-1974Cancelled Jun 20, 2017 · Exported to Guatemala · Built 2000 · Pivaral Kimberly Kay N2489FCessna 310A · S/N 38137Cancelled Mar 21, 2017 · Registration expired, pending cancellation · Letourneau University N684LMMiller Monte M RAND ROBINSON KR-2 · S/N 7713Cancelled Feb 16, 2017 · Registration expired, pending cancellation · Built 1993 · Wise Joseph D N9527LGrumman American Avn. AA-5 · S/N AA5-0527Cancelled Feb 13, 2017 · Revoked, canceled · Built 1974 · Hardtke Leon C DBA N73739Boeing A75N1(PT17) · S/N 75-7025Cancelled Feb 4, 2017 · Revoked, canceled · Built 1943 · Mid South Dusters N74859Grumman American Avn. AA-5B · S/N AA5B0380Cancelled Feb 4, 2017 · Revoked, canceled · Built 1976 · Flight Specialties Inc N8194HNorth American B-25N · S/N 4486749ACancelled Feb 4, 2017 · Revoked, canceled · Built 1944 · Wandel Hugh E N564GCSensefly EBEE RTK · S/N ER-01-32407Cancelled Nov 30, 2015 · Russell & Sons Construction Co Inc N791TCThunder & Colt Airborne Amer COLT 56A · S/N TCSP-1Cancelled May 15, 2015 · Registration expired, pending cancellation · Built 1993 · Get High Inc N3509XMooney M20F · S/N 670047Cancelled May 13, 2015 · Registration expired, pending cancellation · Built 1966 · Sharp Bert N2864RPiper PA-28R-200 · S/N 28R-35320Cancelled Nov 26, 2014 · Registration expired, pending cancellation · Built 1969 · Letourneau University N815TCThunder & Colt Airborne Amer AX7-65S1 · S/N 2460USACancelled Nov 7, 2013 · Registration expired, pending cancellation · Built 1994 · Ashby James R N11273Cessna 150L · S/N 15075290Cancelled Sep 13, 2013 · Registration expired, pending cancellation · Built 1973 · Elliott Gregory P N5150MBeech T42 · S/N 66-04301Cancelled Jul 15, 2013 · Registration expired, pending cancellation · Letourneau University N7678TCessna 172A · S/N 47278Cancelled Jul 9, 2013 · Registration expired, pending cancellation · Built 1960 · Doyle Tim K N91ADAndress Autry D A BIRD 1 · S/N 1Cancelled Jun 10, 2013 · Sale reported, canceled · Built 1988

Back to Longview, TX