OpenAirDocs.org
Temecula, CA

Cancelled registrations · 95

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

N7544CForney F-1 · S/N 5660Cancelled Feb 21, 2013 · Sale reported, canceled · Built 1959N21UPUltralite Products ARROW · S/N AP-4Cancelled Sep 21, 2012 · Registration expired, pending cancellation · Ultralite Products IncN1982RRaven S55A · S/N S55A-106Cancelled Aug 20, 2012 · Registration expired, pending cancellation · Built 1972 · Scherm Peter JN1539GBalloon Works FIREFLY 7-B · S/N 10249Cancelled Aug 7, 2012 · Registration expired, pending cancellation · Built 1981 · Barrett Dennis FN1522DBalloon Works FIREFLY 7 · S/N 11061Cancelled Aug 6, 2012 · Registration expired, pending cancellation · Built 1981 · Darran WalterN115CHHaynes Charles D III KITFOX SER V · S/N S9806-0159Cancelled Jul 19, 2012 · Registration expired, pending cancellation · Haynes Charles D IIIN104MLChamberlain Mark R VANS RV-10 · S/N 40016Cancelled Jun 14, 2012 · Exported to Australia · Built 2006 · Chamberlain Mark RN5503MQuicksilver GT-500 · S/N GT5-X0110Cancelled Aug 1, 2011 · Expired dealer · Built 1996 · Quicksilver AircraftN1059GAdams Balloon A55S · S/N 074Cancelled Jun 29, 2011 · Sale reported, canceled · Built 1981N8025QPalmer Paul O/Palmer & Assoc I SEAWIND 3000 · S/N 025Cancelled Jun 16, 2011 · Registration pending, pending cancellation · Built 1999N4016FLindstrand Balloons 180A · S/N 5041Cancelled Oct 13, 2010 · Exported to Mexico · Built 1997 · Brundage Thomas AN24827Cessna 152 · S/N 15280402Cancelled Aug 20, 2009 · Exported to Colombia · Built 1977 · Ewing Alan CN6555VCessna 172RG · S/N 172RG0773Cancelled Mar 29, 2007 · Exported to Bolivia · Built 1980 · Stevenson MarianneN7189URobinson Helicopter R22 BETA · S/N 3113Cancelled Jun 13, 2005 · Triennial form not returned · Built 2000 · Sunstone Aviation LLCN700CKCameron Balloons US V-77 · S/N 5162Cancelled Nov 17, 2004 · Triennial form not returned · Built 1986 · Johnson David MN8035LBrown Robert E HP-15/18 · S/N RB-1Cancelled May 3, 2004 · Triennial form not returned · Built 1980 · Brown Robert EN90RAAdkins L Richmond JR MONERAI · S/N 226Cancelled Nov 20, 2003 · Triennial form not returned · Built 1992 · Rapp Michael TN106MXEipper QUICKSILVER MX II · S/N 4680Cancelled Jul 24, 2003 · Second triennial mailing, no response · Built 1983 · Eipper Aircraft IncN14MXEipper MX SUPER · S/N 1008Cancelled Jul 24, 2003 · Second triennial mailing, no response · Eipper Aircraft IncN15MXEipper MXL-II · S/N 1948Cancelled Jul 24, 2003 · Second triennial mailing, no response · Eipper Aircraft IncN6236TCessna 150E · S/N 15060936Cancelled Jun 16, 2003 · Triennial form not returned · Built 1964 · Benbow Brenda IN11MXBrown Michael MXL SUPER · S/N 1029Cancelled Feb 25, 2003 · Second triennial mailing, no response · Eipper Aircraft IncN13MXBrown Michael EIPPER MX II · S/N 1423Cancelled Feb 25, 2003 · Second triennial mailing, no response · Eipper Aircraft IncN3256SEipper QUICKSILVER MX II · S/N 1083Cancelled Feb 25, 2003 · Second triennial mailing, no response · Built 1982 · Eipper AircraftN5MXBrown Michael MXL SUPER · S/N 1213Cancelled Feb 25, 2003 · Second triennial mailing, no response · Eipper Aircraft IncN7MXBrown Michael EIPPER MX II · S/N 5455Cancelled Feb 25, 2003 · Second triennial mailing, no response · Eipper Aircraft IncN65733Quicksilver GT-500 · S/N 058Cancelled Oct 16, 2002 · Second triennial mailing, no response · Byrum Lyle MN6573RQuicksilver GT-500 · S/N 075Cancelled Oct 16, 2002 · Second triennial mailing, no response · Built 1991 · Byrum Lyle MN6574SQuicksilver GT-500 · S/N 007Cancelled Oct 16, 2002 · Second triennial mailing, no response · Byrum Lyle MN47465Piper PA-32R-300 · S/N 32R-7880008Cancelled May 23, 2002 · Built 1977 · Powers David R TrusteeN83370Piper PA-18-150 · S/N 18-7609106Cancelled Apr 26, 2002 · Exported to Canada · Built 1976 · Roripaugh JackN819MSStump Michael J ROTORDYNE SBS-2 · S/N MSAC-002Cancelled Mar 11, 2002 · Triennial form not returned · Built 2000 · Stump Michael JN141HBShablow John S HIPERBIPE SNS-7 · S/N 141Cancelled Aug 31, 2001 · Shablow John SN732NZCessna T210M · S/N 21061655Cancelled May 17, 1999 · Triennial form not returned · 3 D CadwareN9042GBalloon Works FIREFLY 8B · S/N F8B305Cancelled Dec 12, 1998 · Triennial form not returned · Above All Balloon ChartersN18961Beech C23 · S/N M1983Cancelled Nov 5, 1998 · Hagler Brian HN983TCColt Balloons 105-A · S/N 1511USCancelled Jan 26, 1998 · Triennial form not returned · Ekdahl Dean AN742CBCameron Balloons V-77 · S/N 5003Cancelled Dec 13, 1997 · Triennial form not returned · Gallagher Peter PN5693WEnstrom F-28C · S/N 4902Cancelled May 20, 1997 · Skyline Aviation IncN400MRRPM Industries GT400S · S/N 1046Cancelled Jul 6, 1992 · Triennial form not returned · Rpm Industries IncN500GTNoll Bruce P GT-500 · S/N GT500006Cancelled Jun 22, 1992 · Noll Bruce PN5135KCessna 172N · S/N 17273980Cancelled Apr 5, 1991 · Triennial form not returned · Airmech IncN103MXEipper MX SUPER · S/N 1027Cancelled Dec 21, 1990 · Triennial form not returned · Eipper Aircraft IncN4716APiper PA-18-150 · S/N 184934Cancelled Jul 7, 1977 · Roripaugh John EN830SRCessna 150A · S/N 15062441Cancelled Sep 15, 1970 · Robert J Torbet
Back to Temecula, CA