Skip to content

Cancelled registrations · 46

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

N881NEOdonnell James HAWK CLASSIC II · S/N HCII-312-R503-TRICancelled Aug 9, 2023 · Built 1995 · Keiger Richard L N6561ECessna 175 · S/N 56061Cancelled Mar 5, 2022 · Registration expired, pending cancellation · Built 1959 · Henschel Warren E N71512Luscombe 8A · S/N 2939Cancelled Mar 5, 2022 · Registration expired, pending cancellation · Built 1946 · Henschel Warren E N81833Piper PA-28-161 · S/N 28-8016222Cancelled Oct 6, 2021 · Built 1980 · Bozzo Paul W N652TSStreet Thomas G KITFOX SPEEDSTER · S/N LCS 149Cancelled Aug 19, 2021 · Exported to Costa Rica · Street Thomas G N618JHHoyle James I DOMINATOR · S/N 41440Cancelled Nov 21, 2019 · Registration expired, pending cancellation · Built 1999 · Todaro Robert S N800CCRaytheon Corporate Jets HAWKER 800XP · S/N 258266Cancelled Apr 3, 2019 · Built 1995 · Aviation And Marketing International Inc N44296Taylorcraft BC12-D · S/N 10096Cancelled Jan 18, 2019 · Registration expired, pending cancellation · Built 1946 · Henschel John W N9833UGrumman American Avn. AA-5A · S/N AA5A0233Cancelled Jan 8, 2019 · Registration expired, pending cancellation · Built 1976 · Dd & Kd Ltd N6614WPiper PA-28-140 · S/N 28-20708Cancelled Jul 12, 2018 · Registration expired, pending cancellation · Built 1965 · Henschel Warren E N71545Aerostar International S-49A · S/N S49A-3205Cancelled Mar 19, 2018 · Registration expired, pending cancellation · Built 1996 · Caraway Shelley L N9844NRobinson Helicopter R44 · S/N 0450Cancelled Mar 9, 2018 · Registration expired, pending cancellation · Heritage Helicopter Services LLC N994HVRobinson Helicopter R22 BETA · S/N 0994Cancelled Mar 9, 2018 · Registration expired, pending cancellation · Built 1989 · Heritage Helicopter Services LLC N123FGBellanca 17-31A · S/N 73-32-124Cancelled Feb 28, 2018 · Registration expired, pending cancellation · Built 1973 · Gilley Frank M N94LWWallace Daniel A EXEC · S/N 71851Cancelled Jan 24, 2018 · Registration expired, pending cancellation · Built 1995 · Dan Wallace Inc N980KWallace Daniel A RENEGADE SPIRIT · S/N 622RENCancelled Oct 27, 2017 · Registration expired, pending cancellation · Built 2000 · Wallace Daniel A N55071Piper PA-28-235 · S/N 28-7310113Cancelled Oct 20, 2017 · Registration expired, pending cancellation · Built 1973 · Zaporozhets Dennis N26947Piper J4A · S/N 4965Cancelled Jul 12, 2017 · Registration expired, pending cancellation · Built 1946 · Wallis Bruce W N89EAArgence Enas A RV-8 · S/N 009Cancelled May 15, 2017 · Registration expired, pending cancellation · Built 2007 · Milne Robert D N7303RPiper PA-32-300 · S/N 32-7340043Cancelled Apr 13, 2017 · Registration expired, pending cancellation · Built 1972 · Wallis Bruce W N4667PPiper PA-23-250 · S/N 27-190Cancelled Mar 10, 2017 · Registration expired, pending cancellation · Built 1960 · Texlandair LLC N4807ULymbery Meydon P EXEC 90 · S/N 5066Cancelled Feb 28, 2017 · Registration expired, pending cancellation · Built 2002 · Texas Air Corps N3105CPrice BG-12A · S/N RAP1Cancelled May 6, 2015 · Registration expired, pending cancellation · Built 1971 · Solo Antonio R N435STPiper PA-28-161 · S/N 28-8116059Cancelled Nov 26, 2014 · Registration expired, pending cancellation · Built 1980 · Brahmp LLC N56206Boeing A75 · S/N 75-212Cancelled Oct 28, 2014 · Registration expired, pending cancellation · Built 1940 · Robbins Robert C N65837Convair BT-13A · S/N 2819Cancelled Nov 8, 2013 · Registration expired, pending cancellation · Built 1941 · Angel Charles N91JLLovell Jerry LOVELL EZ · S/N 1JLCancelled Sep 30, 2013 · Registration expired, pending cancellation · Built 1991 · Lovell Jerry A N66PFAero Commander 680 · S/N 680-411-86Cancelled Sep 26, 2013 · Registration expired, pending cancellation · Built 1956 · Strong Edward D N191GSSimpson Stephen R RANS S-12S · S/N 08051000Cancelled Jul 15, 2013 · Registration expired, pending cancellation · Simpson Stephen R N2263HYoung Harry R MITCHELL WING U-2 · S/N U-702Cancelled Jun 12, 2013 · Registration expired, pending cancellation · Built 1994 · Britton Richard T N7787GCessna 150L · S/N 15074728Cancelled May 9, 2013 · Registration expired, pending cancellation · Built 1973 · Evans Aviation N8421XCessna 172C · S/N 17248921Cancelled Nov 13, 2012 · Sale reported, pending cancellation · Built 1961 N3021DCessna 310 · S/N 35221Cancelled Sep 25, 2012 · Registration expired, pending cancellation · Built 1956 · Johnson Rand C N2WWWarnack THORP T-18 · S/N 772Cancelled Aug 22, 2012 · Registration expired, pending cancellation · Built 1974 · Warnack Worthy R N8154MCirrus Design SR20 · S/N 1371Cancelled Dec 29, 2011 · Built 2003 · Brock Vincent N18BHLockheed 1329-23E · S/N 5099Cancelled Jun 24, 2011 · Sale reported · Built 1967 N25568Cessna 152 · S/N 15280736Cancelled Jun 3, 2011 · Exported to Canada · Built 1977 · Brahmp LLC N493AMBurkhart Grob GROB G115C · S/N 82019/CCancelled Mar 23, 2011 · Exported to Canada · Aviation & Marketing Int'L Inc N820MGHawker Siddeley DH.125-400A · S/N NA739Cancelled Apr 20, 2010 · Built 1969 · Aviation And Marketing International Inc N721LRCessna S550 · S/N S5500118Cancelled Feb 3, 2010 · Exported to Israel · Built 1986 · Rawlings Rick N8263RBellanca 17-30A · S/N 30447Cancelled Jan 3, 2001 · Bartlett Thomas B N233PTReed Gary F PT 2C · S/N 1233Cancelled Feb 13, 1998 · Triennial form not returned · Reed Gary N7573WPiper PA-28-180 · S/N 281519Cancelled Jun 4, 1996 · Triennial form not returned · Buresh Roger A N5563GCessna 150J · S/N 15071063Cancelled Nov 18, 1994 · Triennial form not returned · Christian Flying Services Inc N6232UMooney M20C · S/N 2071Cancelled Aug 11, 1994 · Triennial form not returned · Logan Daniel J N8488TCessna 182C · S/N 52388Cancelled Dec 1, 1993 · Bonds Bobby A Sr

Back to Kingwood, TX