Fresno, CA

Cancelled registrations · 437

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

N914TBPiper PA-31P · S/N 31P7400189Cancelled Aug 27, 1997 · Exported to Israel · Central California Aviation Inc DBAN8792QCessna TU206G · S/N U20603544Cancelled Aug 15, 1997 · Exported to Mexico · Ilex Computer CorpN29964Waco UPF-7 · S/N 5461Cancelled May 9, 1997 · Exported to Canada · Guilmette John LN51BTConsolidated/Diaz Mark A BT-13A · S/N AF4123063ACancelled May 6, 1997 · Diaz Mark AN29102Waco UPF-7 · S/N 5311Cancelled Apr 30, 1997 · Exported to Canada · Guilmette John LN47ZPBell 47J-2 · S/N 1421Cancelled Mar 20, 1997 · Exported to Chile · Quinn EricN18DTMargeson/Heidebrink VANS RV-3 · S/N 459Cancelled Jan 17, 1997 · Triennial form not returned · Anderson James EN123GZPiper PA-31P · S/N 31P7400179Cancelled Jun 20, 1996 · Exported to Canada · Central California Aviaton IncN28523Piper PA-28RT-201T · S/N 28R7931186Cancelled Jun 7, 1996 · Exported to Canada · Central California Aviation IncN9129ZPiper PA-28RT-201T · S/N 28R8631004Cancelled Apr 5, 1996 · Exported to Germany · Dowling Michael D ExecutorN89JHHarmon John M DOLPHIN · S/N 001Cancelled Mar 2, 1996 · Triennial form not returned · Molatore Dennis JN93JJJones Gerald L CHALLENGER II SPEC · S/N CH21292CW0916Cancelled Aug 8, 1995 · Jones Gerald LN3760CBalloon Works FIREFLY 7 · S/N F7103Cancelled Mar 23, 1995 · Triennial form not returned · Coffman Leroy B IIIN4647RPiper PA-28-140 · S/N 2821401Cancelled Mar 21, 1995 · Triennial form not returned · Son Electrical Contracting CorpN2628RRaven S55A · S/N S55A417Cancelled Dec 21, 1994 · Triennial form not returned · Online Computors PlusN7231NCessna T210N · S/N 21063210Cancelled Dec 21, 1994 · Exported to South Africa · Mcaweeney Dan JN86TSSteffen Stanley E ROTORWAY EXEC · S/N 3252Cancelled Sep 15, 1994 · Triennial form not returned · Steffen Stanley EN8264TCessna 175B · S/N 17556964Cancelled May 4, 1994 · Triennial form not returned · Ewing Jim P DBAN2479BBell 47D1 · S/N 759Cancelled Feb 10, 1994 · Triennial form not returned · Caglia Franklin JN7416DBalloon Works FIREFLY 7 · S/N F7259Cancelled Jan 13, 1994 · Second triennial mailing, no response · Big Kids Toys IncN61DAEmbraer EMB-110P1 · S/N 110376Cancelled Dec 21, 1992 · Exported to Venezuela · Westair IndustriesN63DAEmbraer EMB-110P1 · S/N 110382Cancelled Dec 21, 1992 · Exported to Venezuela · Westair IndustriesN40492Balloon Works FIREFLY 7 · S/N 7928Cancelled May 27, 1992 · Triennial form not returned · Finch J MichaelN104TNEmbraer EMB-110P1 · S/N 110363Cancelled Feb 7, 1992 · Exported to Venezuela · Westair Industries IncN103TNEmbraer EMB-110P1 · S/N 110325Cancelled Dec 6, 1991 · Exported to Venezuela · Westair Industries IncN9309UCessna 150M · S/N 15078259Cancelled Nov 21, 1991 · Triennial form not returned · Walters John LN2489HBalloon Works FIREFLY 7 · S/N 7704Cancelled Apr 8, 1991 · Triennial form not returned · Ridge Clair WN46LMMoore Larry KR-2 · S/N 7646Cancelled Apr 1, 1991 · Triennial form not returned · Moore Larry DN7193UMooney M20E · S/N 411Cancelled Mar 29, 1991 · Triennial form not returned · Annan James C JrN444EQBell 47G-3B-1 · S/N 2810Cancelled Mar 14, 1991 · Exported to Chile · Quinn EricN65198Mitsubishi MU-2B-35 · S/N 549Cancelled Dec 3, 1990 · Exported to Canada · Western Piper Sales IncN7344UCessna 207A · S/N 207-00409Cancelled May 19, 1986 · Exported to Dominican Republic · James Mckoane Enterprises IncN70072Cessna 172M · S/N 17267188Cancelled Aug 13, 1985 · Cochrane Robert GN5954ACessna 172 · S/N 28554Cancelled May 14, 1985 · Nelson Wesley AN5375CCessna 404 · S/N 4040665Cancelled Feb 28, 1984 · Exported to Germany · Crupriss CorporationN2602CPiper PA-38-112 · S/N 3879A0253Cancelled Jan 10, 1984 · Administratively canceled · Western Piper Sales IncN491ABeech 95-C55 · S/N TE295Cancelled Nov 2, 1983 · Floyd J Harkness Co IncN9824RBeech M35 · S/N D-6339Cancelled Jul 22, 1983 · Administratively canceled · Fresno Sky Riders IncN24647Beech B19 · S/N MB-562Cancelled Apr 19, 1983 · Built 1973 · Mckernan Enterprises IncN5364ACessna T210N · S/N 21063392Cancelled Nov 26, 1982 · Wofford Aircraft SalesN34460Cessna 177B · S/N 17701818Cancelled Oct 26, 1982 · Non-citizen corporation, flight hours not reported · Built 1972 · Bill Russell Capo Co IncN1173UCessna 172M · S/N 17266874Cancelled Aug 12, 1982 · Administratively canceled · Young KennethN6574ZCessna TU206G · S/N U20606323Cancelled Jul 26, 1982 · Exported to Mexico · Dillon Aero ServicesN12PAPiper PA-12 · S/N 12988Cancelled Apr 14, 1982 · Administratively canceled · Lindskoog Stanley WN5420QCessna 150L · S/N 15073320Cancelled Feb 12, 1982 · Exported to Mexico · Golden Valley Aero IncN844BBeech S35 · S/N D-7359Cancelled Oct 13, 1981 · Sale reported · Built 1964N6734CBeech 58 · S/N TH-1115Cancelled Sep 10, 1981 · Exported to Australia · Western Piper Sales IncN8847QCessna A185F · S/N 18503777Cancelled Jul 6, 1981 · Exported to Canada · Regency Leasing IncN14416Aerospatiale SA341G GAZELLE · S/N 1094Cancelled Jun 12, 1981 · Exported to Canada · Built 1973 · Mccarthy Leland And Bettye LouN610JPBeech V35A · S/N D-8990Cancelled May 7, 1981 · Big Bonanza
Back to Fresno, CA