Tulare, CA

Cancelled registrations · 153

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

N9497KCessna T188C · S/N T18803951TCancelled Nov 10, 1993 · Exported to Philippines · Johnston Aircraft Service IncN41VAPiper PA-25-235 · S/N 253937Cancelled Apr 19, 1993 · Exported to MexicoN9995PPiper PA-36-285 · S/N 367560111Cancelled Aug 5, 1992 · Triennial form not returned · Johnston Aircraft Ser IncN57618Piper PA-36-285 · S/N 367660016Cancelled May 26, 1992 · Exported to Mexico · Johnston Aircraft Service IncN9948PPiper PA-36-300 · S/N 367560059Cancelled Apr 13, 1992N44504Piper PA-36-285 · S/N 367460038Cancelled Oct 25, 1991 · Triennial form not returned · Johnston Aircraft Service IncN82400Piper PA-25-235 · S/N 25-7756001Cancelled Nov 25, 1988 · Exported to Australia · Johnston Aircraft Service IncN57806Piper PA-36-285 · S/N 36-7660127Cancelled Oct 10, 1984 · Exported to Australia · Johnston Aircraft Service IncN57808Piper PA-36-285 · S/N 36-7660102Cancelled Sep 28, 1984 · Exported to Mexico · Johnston Aircraft Service IncN7586ZPiper PA-25-235 · S/N 25-3664Cancelled Jan 26, 1984 · Exported to Mexico · Johnston Aircraft Service IncN4953XRockwell International S-2R · S/N 2161RCancelled Sep 19, 1983 · Exported to Mexico · Johnston Aircraft Service IncN81814Piper PA-28-161 · S/N 288016302Cancelled Jun 25, 1983 · Administratively canceled · Gryphon Aviation ServicesN4431YPiper PA-25-235 · S/N 25-4057Cancelled May 18, 1983 · Exported to Mexico · Built 1966 · Crom'S Agricultural Flying ServiceN8837LPiper PA-25-235 · S/N 25-5348Cancelled Mar 3, 1983 · Administratively canceled · Tulare Mosquito Abatement DistrictN2385YPiper PA-36-300 · S/N 36-8160021Cancelled Sep 24, 1982 · Exported to South Africa · Johnston Aircraft Service IncN6152APiper PA-36-375 · S/N 36-8102010Cancelled Apr 14, 1982 · Exported to Australia · Johnston Aircraft Service IncN57890Piper PA-36-300 · S/N 36-7760053Cancelled Mar 2, 1982 · Anderson BrothersN59674Piper PA-36-300 · S/N 36-7760085Cancelled Jan 27, 1982 · Exported to Australia · Johnston Aircraft Service IncN4752YPiper PA-25-260 · S/N 25-4512Cancelled Dec 14, 1981 · Exported to Mexico · Johnston Aircraft Service IncN57842Piper PA-36-300 · S/N 36-7760015Cancelled Aug 26, 1981 · Exported to Mexico · Johnston Aircraft ServiceN4536YPiper PA-25-235 · S/N 25-4182Cancelled Jun 22, 1981 · Exported to Mexico · Built 1967 · Bruce Jones & Sons IncN8795LPiper PA-25-235 · S/N 25-5482Cancelled Jan 26, 1981 · Exported to Mexico · Johnston Aircraft Service IncN56407Aeronca 0-58B · S/N 13003Cancelled Jan 12, 1981 · Nelson C NormandN9921PPiper PA-36-285 · S/N 36-7560031Cancelled Jan 12, 1981 · Exported to South Africa · Johnston Aircraft Service IncN6513ZPiper PA-25-235 · S/N 252043Cancelled Jan 2, 1981 · Exported to Mexico · Johnston Aircraft Service UncN9962PPiper PA-36-285 · S/N 36-7560073Cancelled Oct 30, 1980 · Exported to South Africa · Johnston Aircraft Service IncN4453YPiper PA-25-235 · S/N 25-4099Cancelled Sep 18, 1980 · Exported to Mexico · Built 1966 · Johnston Aircraft Service IncN8948LPiper PA-25-235 · S/N 25-5413Cancelled Aug 14, 1980 · Exported to Mexico · Johnston Aircraft Service IncN59667Piper PA-36-300 · S/N 36-7760075Cancelled Jul 24, 1980 · Exported to Mexico · Johnston Aircraft Service IncN9788PPiper PA-25-235 · S/N 25-7556101Cancelled May 20, 1980 · Exported to Mexico · Johnston Aircraft Service IncN5636XAero Commander S2R · S/N 1836RCancelled Mar 18, 1980 · Exported to Mexico · Johnston Aircraft Service IncN59672Piper PA-36-300 · S/N 36-7760083Cancelled Feb 15, 1980 · Exported to Mexico · Johnston Aircraft Service IncN57717Piper PA-36-285 · S/N 36-7660039Cancelled Jan 11, 1980 · Exported to Australia · Johnston Aircraft Service IncN4192EPiper PA-25-235 · S/N 25-7856072Cancelled Dec 20, 1979 · Exported to Mexico · Built 1978N9778PPiper PA-25-235 · S/N 25-7556088Cancelled Nov 28, 1979 · Exported to Mexico · Johnston Aircraft Service IncN9841PPiper PA-25-235 · S/N 25-7556158Cancelled Nov 19, 1979 · Exported to Mexico · Built 1975 · Johnston Aircraft Service IncN9959PPiper PA-36-285 · S/N 36-7560070Cancelled Nov 6, 1979 · Exported to Australia · Built 1975 · Johnston Aircraft Service IncN7664ZPiper PA-25-235 · S/N 25-3808Cancelled Oct 1, 1979 · Exported to Mexico · Johnston Aircraft Services IncN9869PPiper PA-25-235 · S/N 25-7556194Cancelled Oct 1, 1979 · Exported to Mexico · Built 1975 · Johnston Aircraft Service IncN2318QPiper PA-25-235 · S/N 25-7956024Cancelled Aug 31, 1979 · Johnston Aircraft Service IncN3899EPiper PA-36-375 · S/N 36-7802046Cancelled Aug 31, 1979 · Exported to Mexico · Johnston Aircraft ServiceN9177RCessna A188B · S/N 18802141TCancelled Aug 31, 1979 · Exported to Mexico · Johnston Aircraft Service IncN9195TPiper PA-25-235 · S/N 25-7856044Cancelled Aug 24, 1979 · Exported to Mexico · Johnston Aircraft Service IncN2317QPiper PA-25-235RESTD · S/N 25-7956008Cancelled Aug 19, 1979 · Exported to Mexico · Johnston Aircraft IncN7059ZPiper PA-25-235 · S/N 25-2834Cancelled Aug 16, 1979 · Exported to Mexico · Johnston Aircraft Service IncN9770PPiper PA-25-235 · S/N 25-7556081Cancelled Aug 15, 1979 · Exported to Mexico · Built 1975 · Johnston Aircraft Service IncN655UGrumman G-164 · S/N 391Cancelled Aug 14, 1979 · Exported to Mexico · Johnston Aircraft Service IncN2157JCessna A188B · S/N 18803394TCancelled Aug 13, 1979 · Exported to Mexico · Johnston Aircraft Service IncN82588Piper PA-25-235 · S/N 25-7856005Cancelled Aug 7, 1979 · Exported to Mexico · Built 1977 · Johnston Aircraft Service IncN9192TPiper PA-25-235 · S/N 25-7856042Cancelled Jul 24, 1979 · Exported to Mexico · Johnston Aircraft Service Inc
Back to Tulare, CA