Skip to content

Cancelled registrations · 49

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

N643GPParker Gary James AVID MAGNUM · S/N 90MCancelled Feb 12, 2026 · Built 2014 · Fire Pilot LLC N827VTRafferty Trevor CASSUTT IIIM · S/N RA002Cancelled Jul 30, 2022 · Registration expired, pending cancellation · Built 1997 · Clark Joseph C N889WSDassault FALCON 2000 · S/N 29Cancelled May 1, 2020 · Registration pending, canceled · Built 1996 N48WSDassault FALCON 900B · S/N 076Cancelled Feb 3, 2020 · Registration expired, pending cancellation · Avant Aerospace Inc N8300EDassault-Breguet FALCON 50 · S/N 33Cancelled Nov 18, 2019 · Sale reported · Built 1980 N59ARAvions Marcel Dassault Breguet MYSTERE FALCON 50 · S/N 56Cancelled Sep 20, 2019 · Registration pending, canceled N21FJGulfstream Aerospace G-IV · S/N 1016Cancelled Aug 29, 2019 · Sale reported, canceled N369BSHytech-Hurricane HURRICANE 103 · S/N SN54327.5285Cancelled Jan 15, 2019 · Registration expired, pending cancellation · Built 1997 · Ennis Gregory P N994YCDJI INSPIRE 1 · S/N W13DCA22020614Cancelled Oct 23, 2018 · Registration expired, pending cancellation · Cortina Yann N800LMBritish Aerospace HS 125-700A · S/N NA0299Cancelled Mar 29, 2018 · Registration expired, pending cancellation · Built 1982 · Renda Aviation LLC N6868NMooney M-20G · S/N 680123Cancelled Jan 23, 2018 · Registration expired, pending cancellation · Built 1968 · Johnson Dennis R N97315Cessna 550 · S/N 550-0144Cancelled Jan 17, 2018 · Registration expired, pending cancellation · Atlas Aerial Mapping N6331MEurocopter/Canada BO 105LS A-3 · S/N 2051Cancelled Oct 24, 2017 · Registration expired, pending cancellation · Built 1998 · Chaparral Air Group N7940GCessna 172L · S/N 17259640Cancelled Jun 21, 2017 · Registration expired, pending cancellation · Built 1970 · Inman Charles W N500KMarshall James J COZY MK IV · S/N 0163Cancelled Jun 19, 2017 · Registration expired, pending cancellation · Built 2004 · Marshall James J N270DBBauman Darryl TEENIE TWO · S/N 270580730Cancelled May 19, 2015 · Registration expired, pending cancellation · Bauman Darryl N5799YPiper PA-23-250 · S/N 27-2930Cancelled May 5, 2015 · Registration expired, pending cancellation · Built 1965 · Betik Patrick G N8835JPiper PA-28-180 · S/N 28-2791Cancelled May 5, 2015 · Registration expired, pending cancellation · Built 1965 · Bush David N7423GBalloon Works FIREFLY 7 · S/N F7-304Cancelled Dec 18, 2014 · Registration expired, pending cancellation · Peterson Karen A N94231Convair 600-240D · S/N 57Cancelled Nov 24, 2014 · Registration expired, pending cancellation · Built 1948 · Sedalia Marshal Boonville Stage Line N31336Beech 35 · S/N D-1074Cancelled Oct 31, 2013 · Registration expired, pending cancellation · Corporate Aviation Analysis & Planning Inc N4572VMesserschmitt-Boelkow-Blohm BO-105S · S/N S-665Cancelled Aug 13, 2013 · Sale reported, canceled · Built 1984 N41NMesserschmitt-Boelkow-Blohm BO-105S · S/N S-344Cancelled Aug 6, 2013 · Sale reported, canceled N7646KPiper PA-20 · S/N 20-467Cancelled Jul 23, 2013 · Registration expired, pending cancellation · Built 1950 · Tomlin Melvin DBA N7030NBeech D55 · S/N TE-473Cancelled May 3, 2013 · Registration expired, pending cancellation · Built 1967 · Wayrynen P W N5416FMesserschmitt BO105CBS · S/N 794Cancelled Feb 13, 2013 · Sale reported, canceled · Built 1988 N41447Douglas DC3 · S/N 12987Cancelled Nov 20, 2012 · Registration expired, pending cancellation · Built 1944 · Sedalia Marshall Boonville Stg Lane N576BDArmstrong BD-4 · S/N 576Cancelled Sep 25, 2012 · Sale reported, pending cancellation · Built 1973 N496HLMesserschmitt-Boelkow-Blohm BO-105S · S/N S-822Cancelled Jun 7, 2012 · Sale reported, canceled · Built 1989 N40926Piper J3L-65 · S/N 7581Cancelled Jun 4, 2012 · Revoked, canceled · Built 1941 · Frederick Leland M N25353Piper PA-38-112 · S/N 38-80A0115Cancelled Jan 23, 2012 · Exported to Argentina · Built 1980 · Boutier Bernadette P N9724NCessna 120 · S/N 13455Cancelled Jun 5, 2008 · Built 1947 · Landry Lonny R N135EBGraham Grady EROS · S/N 2546PCancelled Aug 4, 2005 · Triennial form not returned · Built 2002 · Graham Grady M N39LHCessna 500 · S/N 5000089Cancelled May 13, 2005 · Sale reported · Built 1973 N42CYYoung Charles R RV-6A · S/N 21529Cancelled Jun 2, 2003 · Triennial form not returned · Built 2000 · Young Charles R N67570Cessna 152 · S/N 15281919Cancelled Nov 30, 2000 · Triennial form not returned · Z And B Enterprise Inc N340JKDehavilland DHC-7-102 · S/N 49Cancelled Jun 7, 1996 · Exported to Israel · International Turbine Service Inc N5465PCessna 152 · S/N 15284952Cancelled Jul 7, 1994 · Exported to Kenya · Armstrong Bradley C N94208Convair 600-240D · S/N 15Cancelled May 12, 1992 · Triennial form not returned · International Turbine Service Inc N94253Convair 600-240D · S/N 114Cancelled May 12, 1992 · Triennial form not returned · International Turbine Service Inc N2182HBalloon Works FIREFLY 7 · S/N 7786Cancelled May 11, 1992 · Peterson Karen A N7261DGates Learjet 55B · S/N 134Cancelled Jan 9, 1992 · Exported to Brazil · Airsupport Services Corporation N5014GBell 206B · S/N 2607Cancelled Jan 4, 1985 · Built 1979 · Marsteller International Inc N242KLCessna 310D · S/N 39094Cancelled Sep 29, 1975 · Shriver W B N83833Aeronca 7AC · S/N 7AC-2513Cancelled Sep 27, 1974 · Built 1946 · Carroll Neil Lynn N2374LBeech 23 · S/N M-216Cancelled Jun 8, 1973 · Goode R G N53622Laister-Kauffman LK-10A · S/N 51Cancelled Sep 23, 1970 · Taylor Lee Ramon N5516ECessna 150 · S/N 17016Cancelled Aug 19, 1970 · Clark James L N401BBeech 35 · S/N D-1405Cancelled Apr 11, 1958 · Jones N J

Back to Grapevine, TX