Visalia, CA

Cancelled registrations · 116

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

N146UPiper PA-24-250 · S/N 24-2648Cancelled Mar 3, 2011 · Expired dealer · Built 1961 · West Coast Aircraft Auction IncN1843EAeronca 7AC · S/N 7AC-5410Cancelled Sep 18, 2009 · Registration revoked · Built 1946 · Younger L DN9976Semco Balloon T · S/N SEM87Cancelled Sep 18, 2009 · Registration revoked · Built 1973 · Hot Air Aeronauts Of CaliforniaN2852DBoeing A75N1(PT17) · S/N 75-004Cancelled Jul 20, 2009 · Registration revoked · Built 1941 · Crop Air IncN51XBBower Rod XB51 · S/N 80769Cancelled Apr 13, 2009 · Exported to Australia · Built 2007 · Bower Rod WN1777SAero Commander 600 S-2D · S/N 600-1377DCancelled Sep 17, 2008 · Exported to Canada · Built 1967 · Main Brett NN7063MMcentire James R RANS S-9 · S/N 0888058Cancelled May 4, 2007 · Exported to New Zealand · Roberts Gary DN7291YPiper PA-30 · S/N 30-329Cancelled Apr 17, 2006 · Triennial form not returned · Built 1964 · Sinor Bernard RN249RSBurns Gary A RV-8 · S/N 80926Cancelled Apr 3, 2006 · Triennial form not returned · Burns Gary AN10531Cessna 150L · S/N 15074904Cancelled May 25, 2004 · Triennial form not returned · Built 1973 · Sario Anthony PN8472FPiper PA-28-181 · S/N 28-7790246Cancelled Mar 5, 2003 · Registration revoked · Built 1976 · Bergman John CN43132Taylorcraft BC12-D · S/N 6791Cancelled Oct 2, 2002 · Registration revoked · Built 1946 · Palmer Francis WN729BBStamm William J RUTAN VARIEZE · S/N 164Cancelled May 4, 2001 · Brim John AN225Harwell Roy M III V-20 · S/N 20Cancelled Oct 31, 2000 · Anders David WN9683GCessna TU206F · S/N U20601883Cancelled Apr 3, 2000 · Exported to Mexico · Meyer Richard SN8276MCessna 210K · S/N 21059276Cancelled Nov 13, 1998 · Triennial form not returned · Cavale FrankN600EMMcnamee W A / Mcnamee E G SPEEDWING · S/N 600Cancelled Nov 4, 1996 · Bookout NissanN30438Cessna 177A · S/N 17701254Cancelled Sep 6, 1996 · Triennial form not returned · Giles WilmaN595BBeech A35 · S/N D1616Cancelled Feb 23, 1996 · Triennial form not returned · Rent And Lease ProgramsN8874QAero Commander S2R · S/N 1474RCancelled Apr 6, 1995 · Triennial form not returned · Gilbert Aviation Industries IncN3087DAyres S-2R · S/N R1820027DCCancelled Mar 20, 1995 · Triennial form not returned · Gilbert Aviation Industries IncN9520LGrumman American Avn. AA-5 · S/N AA50520Cancelled Jun 21, 1994 · Triennial form not returned · Haworth Steven PN8924Edmiston SCORPION ONE · S/N PL02Cancelled May 3, 1994 · Triennial form not returned · Lyons Thomas PN3416GBensen B-8M · S/N PL01Cancelled Apr 7, 1993 · Triennial form not returned · Lyons Thomas PN3214VCessna 150M · S/N 15076423Cancelled Dec 31, 1992 · Exported to Germany · Graham Bruce HN2440FRussell Morris H KR-1 · S/N MR3479Cancelled Sep 3, 1991 · Triennial form not returned · Russell Morris HN5022CBeech B35 · S/N D2284Cancelled Jul 8, 1991 · Stewart George WN3225ZNoell-Oros ROTEC RALLY 3 · S/N 64646Cancelled Sep 27, 1985 · Administratively canceled · Noell Leonard RN52338Cessna 182P · S/N 18262539Cancelled Aug 20, 1984 · S K Ranch Clarence RitchieN6143XAero Commander 500-A · S/N 500A-931-26Cancelled Dec 18, 1981 · William L Main IncN23501Cessna 150H · S/N 15068993Cancelled Sep 30, 1981 · Built 1968 · Action AviationN4815RCessna A188B · S/N 18802335TCancelled Nov 7, 1978 · Gilbert Aviation Industries IncN7705TCessna 172A · S/N 47305Cancelled Jul 2, 1976 · Jackson Eugene DN202QAero Commander 500 · S/N 793Cancelled May 17, 1976 · Built 1959 · Main William L IncN54865Consolidated Vultee BT-13A · S/N 1414Cancelled Jun 10, 1975 · Rose L RobertN4712JBeech A23-19 · S/N MB-170Cancelled Apr 1, 1975 · Green Acres Airport IncN56419Boeing A75 · S/N 35-215Cancelled Aug 14, 1974 · Green Acres Arpt IncN7945FCessna 150F · S/N 15064045Cancelled Apr 22, 1974 · Newkirk George LN2818MBeech 95-B55 (T42A) · S/N TC-867Cancelled Mar 19, 1974 · Exported to Australia · Mccarthy Land CompanyN56488Consolidated Vultee BT-13A · S/N 5325Cancelled Dec 6, 1971 · Shannon R ArthurN9395MMooney M20F · S/N 670019Cancelled Mar 22, 1971 · Ruddy R Earl JrN6986PPiper PA-24-250 · S/N 24-2129Cancelled Feb 2, 1971 · Whitmore John FN7766ACessna 180A · S/N 32663Cancelled Dec 11, 1970 · Exported to Mexico · Heck Richard CN5062NCessna T-50 · S/N 4124Cancelled Oct 7, 1970 · Gilbert R JohnN6963PPiper PA-24-250 · S/N 24-2103Cancelled Oct 20, 1966 · Exported to Canada · Cornelius Richard DN3001HErcoupe 415-C · S/N 3626Cancelled Oct 7, 1965 · Skynights IncN9720RBeech M35 · S/N D-6383Cancelled May 22, 1965 · J A MeadeN3437VCessna 190 · S/N 7142Cancelled May 21, 1965 · Green Acres Arpt IncN68449Consolidated Vultee BT-13A · S/N 6597Cancelled May 21, 1965 · Allen William FN1364NNorth American AT-6C · S/N 26977Cancelled May 18, 1965 · George H Middleton Jr
Back to Visalia, CA