OpenAirDocs.org
Hickory, NC

Cancelled registrations · 64

Query with SQL
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 = 'NC' AND d.registrant_city = 'HICKORY'
  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.

N7546CDJI PHANTOM 2 VISION + · S/N PH645396738Cancelled Oct 22, 2022 · Third renewal notice · Catawba County Economic Development CorpN117LJSportine Aviacija JSC LAK-17AT · S/N 182Cancelled Apr 18, 2022 · Exported to Argentina · Pate Earl GN4648VCulver PQ-14A · S/N N2432Cancelled Oct 5, 2019 · Registration expired, pending cancellation · Built 1944 · Harris George BN2729MPiper PA-28-181 · S/N 28-7890264Cancelled Sep 12, 2018 · Registration expired, pending cancellation · Built 1977 · Tunstill Christopher DN246JTBeech V35B · S/N D-10079Cancelled Apr 24, 2018 · Registration expired, pending cancellation · Built 1978 · J & J Air LLCN32277Piper PA-28-151 · S/N 28-7515110Cancelled Feb 8, 2018 · Built 1974 · Jm Aircraft IncN80586Waggoner Gary R TITAN II · S/N D99912COHK0351Cancelled Dec 1, 2017 · Built 1999 · Straley Joseph PN85SEDiamond Aircraft Ind DA20-C1 · S/N C0268Cancelled May 24, 2017 · Exported to Canada · Built 2004 · Eclipse Partners LLCN70DLPiper PA-46-310P · S/N 46-8608001Cancelled Mar 6, 2017 · Registration expired, pending cancellation · Built 1985 · Hickory Travel LLCN9537BCessna 172RG · S/N 172RG0863Cancelled Jun 16, 2015 · Exported to Russia · Built 1981 · Mayfield Richard GN310CRCessna 310R · S/N 310R0648Cancelled May 13, 2015 · Registration expired, pending cancellation · Built 1976 · J M Aircraft IncN7144UMooney M20E · S/N 383Cancelled Dec 22, 2014 · Revoked, canceled · Built 1964 · Marshall Ronald RN900SWS.O.C.A.T.A. RALLYE 150 ST · S/N 3176Cancelled Sep 12, 2013 · Registration expired, pending cancellation · Built 1979 · Fox David PN2775HErcoupe 415-C · S/N 3400Cancelled Aug 13, 2013 · Sale reported, canceled · Built 1946N19574Cessna 150L · S/N 15074498Cancelled Jun 14, 2013 · Exported to Brazil · Built 1973 · Jm Aircraft IncN213EACessna U206G · S/N U20605103Cancelled May 20, 2013 · Exported to Zambia · Built 1979 · J M Aircraft IncN6523NCessna 210N · S/N 21063081Cancelled May 7, 2013 · Exported to Paraguay · Built 1978 · Jm Aircraft IncN60862Cessna 150J · S/N 15070629Cancelled Nov 9, 2012 · Registration pending, canceled · Built 1969N266TPiper PA-18 105 · S/N 18-2380Cancelled Oct 18, 2012 · Registration expired, pending cancellation · Built 1953 · Catawba Flight IncN36474Taylorcraft BF12-65 · S/N 3296Cancelled Oct 9, 2012 · Registration expired, pending cancellation · Built 1941 · Davis Richard MN2065JNorth American T-28B · S/N 54-140456Cancelled Aug 13, 2012 · Registration pending, canceledN11471Cessna 150L · S/N 15075444Cancelled Aug 7, 2012 · Exported to Russia · Built 1973 · Hart Robert W IIIN249SCessna U206G · S/N U20605081Cancelled Sep 29, 2010 · Exported to Zambia · Built 1979 · Jm Aircraft IncN2887MPiper PA-32-300 · S/N 32-7840059Cancelled Jan 25, 2008 · Triennial form not returned · Built 1977 · 373ds LLCN61CPRaytheon 400A · S/N RK-402Cancelled Mar 26, 2007 · Exported to Austria · Palmetto Aviation LLCN86FSCanadair F-86 MK.5 · S/N 1157Cancelled Mar 13, 2007 · Triennial form not returned · Built 1954 · Flying Fossiles LLCN121GCessna 210N · S/N 21064331Cancelled Sep 20, 2005 · Exported to Namibia · Built 1981 · Gerrard Donna GN36GCChorosz Gilbert C GLASAIR II FT-S · S/N 2251-47Cancelled Jul 1, 2005 · Exported to South Africa · Built 1995 · Chorosz Gilbert CN982SABeech F90 · S/N LA160Cancelled Oct 26, 2004 · Exported to South Africa · Jm Aircraft IncN104LSBeech B100 · S/N BE-115Cancelled May 27, 2004 · Exported to Canada · Built 1981 · Hickory Air LLCN6430NCessna 210N · S/N 21063006Cancelled Jul 29, 2003 · Exported to Mexico · Built 1978 · Jm Aircraft IncN95775Cessna 152 · S/N 15285966Cancelled Mar 12, 2003 · Triennial form not returned · Built 1985 · Profile Aviation Center IncN112DRBloomberg Jason F DR 1 FOKKER · S/N 2009Cancelled Mar 27, 2002 · Exported to New Zealand · Built 1987 · Gwynn William HN145JHHarden John S PRO TECH PT-2 · S/N 1145Cancelled Oct 29, 2001 · Triennial form not returned · Harden John SN42920Piper PA-34-220T · S/N 34-8333042Cancelled Nov 9, 2000 · Exported to Israel · Jm Aircraft IncN3711GBeech C24R · S/N MC745Cancelled Aug 22, 1994 · Exported to Belgium · Euro Sky IncN84131Piper PA-34-220T · S/N 348133173Cancelled Dec 16, 1992 · Exported to Germany · J M Aircraft IncN777MTCessna 401A · S/N 401A0121Cancelled Nov 23, 1992 · Exported to Chile · Mcclure Aircraft IncN9698YCessna 210N · S/N 21064576Cancelled Nov 16, 1992 · Exported to United Kingdom · J M Aircraft IncN415FFCessna 421B · S/N 421B0557Cancelled Oct 23, 1992 · Exported to Germany · Quilici AugustineN64080Cessna 172P · S/N 17275517Cancelled Jun 25, 1992 · Exported to France · Quilici AugustinN4356QCessna TU206F · S/N U20603047Cancelled May 19, 1992 · Exported to Ecuador · Euro Sky IncN7575FCessna 172N · S/N 17273261Cancelled Jun 20, 1991 · Exported to Belgium · Euro Sky IncN9556BCessna 172RG · S/N 172RG0878Cancelled May 15, 1991 · Exported to Brazil · Mcclure Aircraft IncN41HBMorrisey 2150A · S/N SP30Cancelled Mar 22, 1991 · Triennial form not returned · Mason Robert LN9151ZPiper PA-28-181 · S/N 2890091Cancelled Mar 5, 1991 · Exported to BelgiumN2160QCessna 177RG · S/N 177RG0560Cancelled Aug 30, 1982 · Built 1974 · Hickory Air Service IncN872RBeech 35-33 · S/N CD-28Cancelled Jul 15, 1971 · Tru-Flight IncN33HBeech D17S · S/N 6698Cancelled Aug 19, 1970 · Roberts Walter LN51158Cessna 150 · S/N 15069803Cancelled Jun 8, 1970 · Built 1968 · Cannon Aviation Co Inc
Back to Hickory, NC