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.

N2292WBell 206B · S/N 505Cancelled Oct 6, 2017 · Registration expired, pending cancellation · Built 1970 · Rogers Helicopters IncN63457Boeing PT-17 · S/N 75-2149Cancelled Sep 7, 2017 · Registration expired, pending cancellation · Milliron Michael DelN911EWEurocopter AS 350 B2 · S/N 2657Cancelled Jul 17, 2017 · Exported to Australia · Built 1992 · Rogers Helicopters IncN530KDMcdonnell Douglas Heli 369FF · S/N 0044FFCancelled Jul 14, 2017 · First renewal notice · Rogers Robin MN505WWAerospatiale AS350 B2 ECUREUIL · S/N 2442Cancelled May 15, 2017 · Exported to Canada · Built 1991 · Rogers Helicopters IncN795DFBeech B200 · S/N BB-1510Cancelled Apr 18, 2017 · Devine Organics LLCN408FCBell 407 · S/N 53450Cancelled Mar 22, 2017 · First renewal notice · Built 2000 · American Airborne EmsN7249WPiper PA-28-180 · S/N 28-1077Cancelled Mar 21, 2017 · Registration expired, pending cancellation · Built 1963 · Rocha Rodolfo BarraganN912KWAerospatiale AS350B2 · S/N 2260Cancelled Mar 21, 2017 · Exported to Canada · Built 1989 · Rogers Helicopters IncN176PAPetrus David Wayne S-90 · S/N 80842Cancelled Mar 8, 2017 · Built 2004 · Huene William AN3889FPiper PA-28-181 · S/N 28-7690455Cancelled Mar 6, 2017 · Registration expired, pending cancellation · Built 1976 · Helease IncN8340GCessna 150F · S/N 15062440Cancelled Feb 4, 2017 · Revoked, canceled · Built 1965 · Tuck Joyce RN2578LPiper PA-38-112 · S/N 38-79A0768Cancelled Jul 14, 2016 · Registration expired · Built 1979 · Golden Eagle Enterprises IncN7409MCessna 175 · S/N 55709Cancelled May 14, 2015 · Sale reported, canceled · Built 1959N5029ACessna 172 · S/N 28029Cancelled May 13, 2015 · Sale reported, canceled · Built 1955N302FBFantasy Sky Promotions FANTASY EIGHT · S/N 049Cancelled May 4, 2015 · Registration expired, pending cancellation · Built 1990 · Gray David BruceN8003PPiper PA-24-250 · S/N 24-3243Cancelled Apr 30, 2015 · Registration expired, pending cancellation · Built 1962 · Mcdaniel Rance CN23415Piper PA-38-112 · S/N 38-81AOO99Cancelled Mar 19, 2015 · Registration expired, pending cancellation · Built 1991 · Kenner James DBAN701TUPicard Martin W ZENAIR CH701 · S/N 7-7208Cancelled Feb 17, 2015 · Exported to Australia · Built 2008 · Picard Martin WN62410Cessna 305A · S/N 23191Cancelled Dec 22, 2014 · Registration expired, pending cancellation · Built 1951 · Hammer Field Flying ClubN811QCorbus/Winters BD-5B · S/N 3239Cancelled Dec 3, 2014 · Registration expired, pending cancellation · Built 1985 · Winters Howard HN9229UCessna 150M · S/N 15078179Cancelled Nov 24, 2014 · Registration expired, pending cancellation · Built 1976 · Scott Mark AN89FLBeech 65 · S/N LC-95Cancelled Nov 20, 2014 · Registration expired, pending cancellation · Built 1961 · Lambe Frank DBAN8296Beech 65 · S/N LC-113Cancelled Nov 19, 2014 · Registration expired, pending cancellation · Built 1960 · Decker Alan NashN7270FCessna 182E · S/N 18254085Cancelled Nov 17, 2014 · Registration expired, pending cancellation · Built 1962 · Eaves Ralph EN7070SCessna 150H · S/N 15067770Cancelled Nov 13, 2014 · Registration expired, pending cancellation · Built 1967 · Fresno Holdings IncN4746PPiper PA-23-250 · S/N 27-282Cancelled Oct 14, 2014 · Registration expired, pending cancellation · Built 1960 · Fresno Holdings IncN23628Taylorcraft BC-65 · S/N 1359Cancelled Sep 19, 2014 · Registration expired, pending cancellation · Built 1939 · Fisher Garry DN10828Cessna 150L · S/N 15075068Cancelled Sep 8, 2014 · Registration expired, pending cancellation · Built 1973 · Wingate Terry LN68855Beech C18S · S/N 7488Cancelled Nov 12, 2013 · Revoked, canceled · Built 1952 · Arosteguy George J JrN7414CLockheed PV-2 · S/N 151428Cancelled Oct 31, 2013 · Registration expired, pending cancellation · Built 1957 · Davis Joseph LN25092Piper PA-38-112 · S/N 38-80A0030Cancelled Oct 23, 2013 · Registration expired, pending cancellation · Built 1979 · Schoenhoeft Joseph SN269BVSikorsky UH-34D · S/N 148816Cancelled Sep 26, 2013 · Registration expired, pending cancellation · Big Valley Ag IncN67468Boeing A75 · S/N 75-7469Cancelled Sep 26, 2013 · Revoked, canceled · Built 1940 · Caudle Dwight DN7773North American P-51C · S/N A68-1Cancelled Sep 17, 2013 · Registration expired, pending cancellation · Stan Air IncN5512XRockwell International S-2R · S/N 1712RCancelled Sep 16, 2013 · Registration expired, pending cancellation · Built 1973 · Leach LeasingN6434ECessna 172 · S/N 46534Cancelled Sep 16, 2013 · Registration expired, pending cancellation · Built 1959 · Contreras Joe MN80664Landry Allen E QUICKIE · S/N 197Cancelled Aug 28, 2013 · Registration expired, pending cancellation · Built 1980 · Knapp Montelle NN7086CLockheed PV-2 · S/N 151410Cancelled Aug 20, 2013 · Sale reported, canceled · Built 1945N6345RPiper PA-28-140 · S/N 28-21515Cancelled Aug 6, 2013 · Revoked, canceled · Built 1966 · Sanchez IsaacN43378Taylorcraft BC12-D · S/N 7037Cancelled Jul 30, 2013 · Registration expired, pending cancellation · Built 1946 · Crider Kurt EN2408UCessna 172 · S/N 29566Cancelled Jul 18, 2013 · Registration expired, pending cancellation · Built 1956 · Our Land CorpN9816KStinson 108-2 · S/N 108-2816Cancelled Jul 17, 2013 · Sale reported, pending cancellationN1726HCessna 310C · S/N 35826Cancelled Jul 8, 2013 · Registration expired, pending cancellation · Built 1959 · Pacella John J JrN3977WPiper PA-32-260 · S/N 32-944Cancelled Jun 27, 2013 · Sale reported, canceled · Built 1967N418CStinson 108-2 · S/N 108-3418Cancelled Jun 20, 2013 · Exported to Canada · Built 1947 · Sahakian JosephN2866UAerostar International RX-7 · S/N RX7-3010Cancelled Jun 13, 2013 · Registration expired, pending cancellation · Built 1986 · Hollingsworth David CN4824VBellanca 17-30 · S/N 30093Cancelled Jun 13, 2013 · Sale reported, canceled · Built 1968N31247Hvass BENSEN B8 GYROGLIDER · S/N BHG-1Cancelled Jun 12, 2013 · Registration expired, pending cancellation · Built 1976 · Mcdonald Stanley JN49297Moore Marvin A TIERRA II · S/N VA002Cancelled Jun 12, 2013 · Registration expired, pending cancellation · Built 1984 · Moore Marvin A
Back to Fresno, CA