Skip to content

Cancelled registrations · 102

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

N6600ZPiper PA-25-235 · S/N 25-2175Cancelled May 9, 2026 · Sale reported, canceled · Built 1962 N5951BAir Tractor AT-602 · S/N 602-1209Cancelled Feb 3, 2024 · Sale reported, canceled · Built 2011 N222DFCessna 150F · S/N 15064190Cancelled Oct 21, 2023 · Revoked, canceled · Built 1966 · Latimer Mary M N3260EAeronca 11AC · S/N 11AC-1633Cancelled Feb 5, 2022 · Registration expired, pending cancellation · Built 1947 · Screws Harlan D N4615ZPiper PA-22-108 · S/N 22-8128Cancelled Feb 5, 2022 · Registration expired, pending cancellation · Built 1961 · Abernathy Lyle D N4307CChampion 7EC · S/N 7EC-307Cancelled Oct 30, 2021 · Registration expired, pending cancellation · Built 1955 · Screws Harlan D N83661Aeronca 7AC · S/N 7AC-2339Cancelled Oct 31, 2020 · Registration expired, pending cancellation · Built 1946 · Screws Harlan D N4283EAeronca 11CC · S/N 11CC-154Cancelled Apr 3, 2020 · Registration expired, pending cancellation · Built 1947 · Screws Harlan D N8205Crenshaw PIETENPOL AIRCAMPER · S/N MCA1Cancelled Apr 3, 2020 · Registration expired, pending cancellation · Built 1985 · Screws Harlan D N9197Bowers Fly Baby FB-1A · S/N 10168Cancelled Apr 3, 2020 · Registration expired, pending cancellation · Built 1970 · Screws Harlan D N3180EAeronca 11AC · S/N 11AC-1521Cancelled May 4, 2019 · Registration expired, pending cancellation · Built 1946 · Screws Harlan D N83607Aeronca 7AC · S/N 7AC-2283Cancelled Jul 12, 2018 · Sale reported, canceled · Built 1946 N85822Aeronca 11AC · S/N 11AC-241Cancelled Jun 1, 2018 · Sale reported, canceled · Built 1946 N653LFAirborne Windsports PTY EDGE XT-582-L · S/N XT-582-0070Cancelled Mar 13, 2018 · Registration expired, pending cancellation · Built 2009 · Lehman Farms N6249HCessna 152 · S/N 15284146Cancelled Jan 12, 2018 · Registration expired, pending cancellation · Built 1979 · Vernon College N72343Cessna 140 · S/N 9527Cancelled Jan 8, 2018 · Registration expired, pending cancellation · Built 1946 · Aydelott Donald R N3294HEngineering & Research ERCOUPE 415-C · S/N 3919Cancelled Apr 13, 2017 · Registration expired, pending cancellation · Built 1946 · Screws Harlan D N1885SBeagle B.206 SERIES 2 · S/N B206-073Cancelled Mar 10, 2017 · Registration expired, pending cancellation · Built 1969 · Bradson Properties Inc N2603DPiper PA-38-112 · S/N 38-79A0390Cancelled Sep 9, 2016 · Sale reported, canceled · Built 1978 N646CStinson 108-3 · S/N 108-3646Cancelled Nov 2, 2014 · Registration expired, pending cancellation · Built 1947 · Latimer Mary M N34617Stinson 10A · S/N 8017Cancelled Oct 2, 2014 · Registration expired, pending cancellation · Built 1941 · Latimer Mary M N175RFCessna 175 · S/N 56203Cancelled Sep 10, 2014 · Registration expired, pending cancellation · Built 1959 · Kutac Albert V N44260Taylorcraft BC12-D · S/N 9660Cancelled Sep 20, 2013 · Registration expired, pending cancellation · Screws Harlan D N8631LPiper PA-25-235 · S/N 25-5065Cancelled Sep 11, 2013 · Registration expired, pending cancellation · Built 1969 · North Texas Agricultural Apps Inc N50620Air Tractor AT-502B · S/N 502B-0457Cancelled Aug 23, 2013 · Sale reported, canceled · Built 1997 N5379Grumman Acft ENG Cor-Schweizer G-164A · S/N 1143Cancelled Aug 7, 2013 · Sale reported, canceled · Built 1973 N4165JCessna A188B · S/N 18803723TCancelled Jul 9, 2013 · Registration expired, pending cancellation · Built 1980 · Lobo Flying Service Inc N502RSAir Tractor AT-502 · S/N 502-0089Cancelled Jun 14, 2013 · Sale reported, canceled · Built 1990 N21877Cessna A188B · S/N 18801094TCancelled Jun 11, 2013 · Sale reported, canceled · Built 1972 N9568PPiper PA-25-260 · S/N 25-7405678Cancelled May 23, 2013 · Registration expired, pending cancellation · Built 1974 · Shivers Flying Service Inc N8199SCessna 150F · S/N 15061799Cancelled May 13, 2013 · Registration expired, pending cancellation · Built 1965 · Brantly Helicopter Ind USA Co Ltd N6604Grumman G-164A · S/N 742Cancelled Apr 30, 2013 · Registration expired, pending cancellation · Built 1970 · Shivers Aerial Spraying Inc N48554Grumman Acft ENG Cor-Schweizer G-164A · S/N 1670Cancelled Mar 7, 2013 · Sale reported, pending cancellation · Built 1976 N577YGrumman G-164 · S/N 168Cancelled Feb 1, 2013 · Sale reported, canceled · Built 1962 N5635JCessna A188A · S/N 18800585Cancelled Jan 31, 2013 · Sale reported, canceled · Built 1969 N8498MBradford Mark D B8M · S/N 1Cancelled Nov 29, 2012 · Sale reported, pending cancellation · Built 1980 N4835RCessna A188B · S/N 18802354TCancelled Nov 27, 2012 · Sale reported, canceled · Built 1975 N9196UCessna 150M · S/N 15078147Cancelled Nov 19, 2012 · Sale reported, pending cancellation · Built 1976 N4136ANorth American AT-6C · S/N 88-13583Cancelled Nov 7, 2012 · Sale reported, canceled N6919SCessna 150H · S/N 15067619Cancelled Oct 15, 2012 · Sale reported, pending cancellation · Built 1967 N5951XBrantly B-2B · S/N 90Cancelled Dec 8, 2009 · Exported to China · Built 1963 · Brantly International Inc N9029FBrantly B-2B · S/N 2022Cancelled Dec 8, 2009 · Exported to China · Built 2001 · Brantly International Inc N8528HGrumman Acft ENG Cor-Schweizer G-164A · S/N 1396Cancelled Oct 6, 2009 · Triennial form not returned · Built 1975 · Latimer Mary M N9614PPiper PA-25-260 · S/N 25-7656008Cancelled Jun 30, 2009 · Exported to Chile · Built 1976 · Chapman Troy Alton Jr N97688Stinson 108 · S/N 108-688Cancelled May 28, 2009 · Triennial form not returned · Built 1946 · Latimer Mary M N9029KBrantly B-2B · S/N 2023Cancelled Dec 10, 2008 · Exported to China · Brantly International Inc N9001UBrantly B-2B · S/N 2016Cancelled Oct 21, 2008 · Exported to China · Built 2000 · Brantly International Inc N20260Cessna 172M · S/N 17261137Cancelled Sep 19, 2008 · Triennial form not returned · Built 1972 · Latimer Tamara K N9030QBrantly B-2B · S/N 2015Cancelled May 28, 2008 · Exported to China · Built 2000 · Brantly International Inc N2217UBrantly 305 · S/N 1025Cancelled Sep 27, 2006 · Non-citizen corporation, flight hours not reported · Built 1966 · Brantly International Inc.

Back to Vernon, TX