Hemet, CA

Cancelled registrations · 110

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 = 'CA' AND d.registrant_city = 'HEMET'
  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.

N30JRRehler J CUSTOM KB2 · S/N 1Cancelled Aug 25, 2007 · Built 2001 · Tyler Thomas EN1385BNorth American Medore T-6G · S/N 52-8199-1Cancelled Dec 5, 2006 · Triennial form not returned · Medore Arthur DN37474North American-Medore SNJ-5 · S/N 88-13037Cancelled Jun 2, 2006 · Triennial form not returned · Banaire Enterprises IncN601BJJonker Bill W ZNH SPR ZODC 601 HDS · S/N 6-3075Cancelled Apr 17, 2006 · Exported to Australia · Built 1995 · Jonker Bill WN74635Boeing PT-17 · S/N 75-7069Cancelled Feb 17, 2006 · Triennial form not returned · Built 1945 · Havens Larry HN102FCBurkhart Grob Flugzeugbau G102 CLUB ASTIR IIIB · S/N 5621 CBCancelled Mar 17, 2005 · Triennial form not returned · Built 1984 · Orange County Soaring AssocN9340XCessna 182E · S/N 18253740Cancelled Nov 8, 2003 · Second triennial mailing, no response · Built 1961 · Sailplane Enterprises IncN992SLMcdonnell Douglas Helicopter 369E · S/N 510ECancelled Jul 30, 2002 · Triennial form not returned · Built 1993 · Riverside County Sheriffs DepartmentN1272QCessna 150L · S/N 15072572Cancelled Oct 15, 2001 · Triennial form not returned · Built 1971 · Ruggiero John PN1163SSchweizer SGS 1-34 · S/N 63Cancelled Feb 26, 2001 · Triennial form not returned · Sailplane Enterprises InternationalN9626ZCallair A-9 · S/N 1029Cancelled Feb 16, 2001 · Triennial form not returned · Sailplane Enterprises InternationalN17904Schweizer SGS 2-33A · S/N 284Cancelled Feb 10, 2001 · Triennial form not returned · Sailplane Enterprises InternationalN72LCase SPECIAL · S/N W1001Cancelled May 10, 2000 · Triennial form not returned · Cagle Howard CN4128BBellanca 17-31A · S/N 75-32-148Cancelled Mar 7, 2000 · Triennial form not returned · Osborne Douglas PN807WZRaven S55A · S/N S55A480Cancelled Dec 12, 1997 · Triennial form not returned · Archambeau RobertN2546LPiper PA-38-112 · S/N 3879A0759Cancelled Dec 5, 1997 · Exported to Philippines · Burt Duane LN100HAHirt Mark Robert TRIO · S/N 002Cancelled Feb 12, 1997 · Second triennial mailing, no response · Hirt Mark RN996SDBell OH-58C · S/N 6916166Cancelled Jan 17, 1997 · Riverside County Sheriffs DeptN997SDBell OH-58C · S/N 7221444Cancelled Jan 17, 1997 · Riverside County Sherifffs DeptN8094SPiper PA-28-236 · S/N 287911326Cancelled May 31, 1996 · Exported to Canada · Towler William RN444RTRaven S55A · S/N S55A-248Cancelled Dec 5, 1995 · Built 1975 · Thurau Rudi FriedrichN13745Fairchild C-119C · S/N 48322Cancelled Sep 1, 1995 · Triennial form not returned · Hemet Valley Flying Svc Co IncN32CRRaymond Charles B KR-2 · S/N 7945Cancelled Aug 17, 1995 · Triennial form not returned · Raymond Charles BN583TBeech A36 · S/N E1020Cancelled Mar 3, 1994 · Triennial form not returned · Gibbel Robert ON9652RBeech B95 · S/N TD349Cancelled Oct 26, 1992 · Hmdr EnterprisesN13746Fairchild C-119C · S/N 48352Cancelled Sep 28, 1992 · Triennial form not returned · Hemet Valley Flying Svc Co IncN13744Fairchild C-119C · S/N 49199Cancelled Sep 17, 1992 · Triennial form not returned · Hemet Valley Flying Svc Co IncN52542Heale Ross WIZARD T-38BR503 · S/N 66017Cancelled May 21, 1991 · Triennial form not returned · Inland Disposal IncN13742Fairchild C-119C · S/N 49-194Cancelled Jul 3, 1984 · Administratively canceled · Hemet Valley Flying Serivce CoN4093KLampman/Purves SURVEYOR · S/N 11Cancelled Dec 26, 1978 · Built 1966 · Purves R/Lampman CN6458CConsolidated Vultee PBY-6A · S/N 46644Cancelled Dec 5, 1978 · Exported to Canada · Hemet Valley Flying Service Co IncN8256RBellanca 17-31A · S/N 32-69Cancelled Aug 30, 1978 · Exported to Mexico · Built 1972 · Zabetian Parvin DN7267SCessna 150H · S/N 15067967Cancelled Jul 8, 1977 · Hemet Flying Club IncN77359Cessna 120 · S/N 11800Cancelled Jun 20, 1977 · Warner Robert JN3775UCessna 182S · S/N 18255175Cancelled Jun 22, 1973 · Venable Aircraft Co IncN9860CGrumman TBM-3E · S/N 86118Cancelled Apr 3, 1972 · Built 1945 · Hemet Valley Flg ServiceN7229CGrumman TBM-3E · S/N 86195Cancelled Oct 26, 1971 · Hemet Valley Flying Service CoN6825CGrumman TBM-3E · S/N 85883Cancelled Oct 13, 1971 · Hemet Valley Flying Service CompanyN7246CGrumman TBM-3E · S/N 91724Cancelled Jan 12, 1971 · Hemet Valley Flying Service CoN3356GGrumman TBM-3E · S/N 85844Cancelled Sep 10, 1970 · Hemet Valley Flying Service CoN6459CConsolidated Vultee PBY-6A · S/N 46653Cancelled Sep 9, 1970 · Hemet Valley Flying Service Co IncN9082ZGrumman TBM-3E · S/N 53727Cancelled Sep 9, 1970 · Hemet Valley Flying Svc CoN3620GGyro-Copter B7M · S/N 2Cancelled Sep 1, 1970 · Yates Paul NN44835Naval Aircraft Factory N3N-3 · S/N 2818Cancelled Jun 8, 1970 · Hemet Valley Flying Service CompanyN56787Boeing A75N1 · S/N 75-804Cancelled Jun 8, 1970 · Hemet Valley Flying Service CoN59792Boeing A75N1 · S/N 75-2386Cancelled Jun 8, 1970 · Hemet Valley Flying Service CoN4078KVail V-3 · S/N 1001Cancelled Mar 23, 1970 · Geist Jerrold AN9679CGrumman TBM-3E · S/N 69293Cancelled Sep 9, 1968 · Hemet Valley Flying ServiceN44934Naval Aircraft Factory N3N-3 · S/N 2848Cancelled May 20, 1965 · Hemet Valley Flying Service CoN45062Naval Aircraft Factory N3N-3 · S/N 2727Cancelled May 20, 1965 · Hemet Valley Flying Service Co
Back to Hemet, CA