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.

N3917EGray MXII · S/N 1191Cancelled Jun 11, 2013 · Registration expired, pending cancellation · Built 1983 · Randle Mark AN4432VSaab A32 LANSEN · S/N 32284Cancelled Jun 11, 2013 · Registration expired, pending cancellation · Built 1958 · United States Airpower MuseumN58REKelly Michael K RALLY 3A · S/N 25034Cancelled Jun 11, 2013 · Registration expired, pending cancellation · Kelly Michael KN7987PPiper PA-24-250 · S/N 24-3225Cancelled Jun 10, 2013 · Sale reported, canceled · Built 1962N9283TPiper PA-38-112 · S/N 38-78A0318Cancelled May 22, 2013 · Registration expired, pending cancellation · Built 1978 · Fikes James AN8611SCessna 150F · S/N 15061911Cancelled May 15, 2013 · Registration expired, pending cancellation · Built 1965 · Mazzei Flying Service IncN86689Hiller UH-12L4 · S/N 2548Cancelled May 15, 2013 · Registration expired, pending cancellation · Built 1966 · San Francisco & Fresno Land CoN772WBeech C-45H · S/N AF-743Cancelled May 9, 2013 · Registration expired, pending cancellation · Built 1942 · Jump Ride IncN7748Schoenau WALT'S WING S-1 · S/N 1Cancelled May 9, 2013 · Registration expired, pending cancellation · Built 1974 · Schoenau Walter WN7534XCessna 172B · S/N 17248034Cancelled May 8, 2013 · Registration expired, pending cancellation · Built 1960 · San Joaquin Valley CollegeN7251CLockheed PV-2 · S/N 37550Cancelled May 7, 2013 · Registration expired, pending cancellation · Built 1957 · United States Airpower MuseumN5468XSaab A32 LANSEN · S/N 32209Cancelled May 3, 2013 · Registration expired, pending cancellation · United States Airpower MuseumN64954Cessna 152 · S/N 15281498Cancelled Apr 30, 2013 · Registration expired, pending cancellation · Built 1978 · Rahn Keith AN64142Cessna 172M · S/N 17265044Cancelled Apr 29, 2013 · Registration expired, pending cancellation · Built 1975 · Newburn William A DBAN6800QBeech 65-80 · S/N LD-31Cancelled Apr 24, 2013 · Sale reported, pending cancellation · Built 1962N5517BCessna 182 · S/N 33517Cancelled Apr 22, 2013 · Registration expired, pending cancellation · Built 1956 · Desatoff Raymond AN5521GCessna 150J · S/N 15071021Cancelled Apr 22, 2013 · Registration expired, pending cancellation · Built 1969 · San Joaquin Valley College IncN62031Bell 47J-2A · S/N 3716Cancelled Apr 16, 2013 · Sale reported, pending cancellation · Built 1966N75FROrion Distributing IV P · S/N LIV-348FBCancelled Mar 19, 2013 · Registration expired, pending cancellation · Built 2009 · Orion Distributing IncN8877MBeech A23 · S/N M-620Cancelled Mar 11, 2013 · Sale reported, canceled · Built 1964N8360EMooney M20A · S/N 1538Cancelled Feb 27, 2013 · Sale reported, canceled · Built 1959N7348Geser-Mcconnell BRIEGLEB BG-12BD · S/N 12076Cancelled Feb 21, 2013 · Sale reported, canceled · Built 1977N6452YPiper PA-23-250 · S/N 27-3743Cancelled Feb 13, 2013 · Sale reported, canceled · Built 1967N6791JPiper PA-28-140 · S/N 28-24519Cancelled Feb 13, 2013 · Sale reported, canceled · Built 1968N2346GPiper PA-38-112 · S/N 38-79A0502Cancelled Feb 12, 2013 · Second renewal notice · Built 1979 · Golden Eagle Enterprises IncN57219Boeing A75N1(PT17) · S/N 75-3073Cancelled Feb 1, 2013 · Sale reported, canceled · Built 1942N1230HAeronca 15AC · S/N 15AC242Cancelled Dec 13, 2012 · Revoked, canceled · Built 1948 · Rowland Frank CN4651XCessna 150G · S/N 15064701Cancelled Dec 11, 2012 · Registration expired, pending cancellation · Built 1966 · Carlson Eugene SN9393KStinson 108-2 · S/N 108-2393Cancelled Nov 20, 2012 · Sale reported, pending cancellation · Built 1947N7088KLet BLANIK L-13 · S/N 173422Cancelled Oct 31, 2012 · Third renewal notice · Smajic IncN7088RLet BLANIK L-13 · S/N 173717Cancelled Oct 31, 2012 · Third renewal notice · Smajic IncN7088ULet BLANIK L-13 · S/N 173718Cancelled Oct 31, 2012 · Third renewal notice · Smajic IncN7088ZLet BLANIK L-13 · S/N 174107Cancelled Oct 31, 2012 · Third renewal notice · Smajic IncN1693SSnow 600-S2C · S/N 600-1275CCancelled Oct 15, 2012 · Registration expired, pending cancellation · Built 1965 · Milliron Michael Del DBAN102SPHiller OH-23G · S/N 64-15209Cancelled Oct 11, 2012 · Registration expired, pending cancellation · Built 1965 · San Francisco & Fresno Land CoN14FLRaven S55A · S/N S55A-339Cancelled Oct 11, 2012 · Registration expired, pending cancellation · Built 1977 · Laury Frank BN540EPiper PA-23-250 · S/N 27-7Cancelled Sep 20, 2012 · Sale reported, pending cancellation · Built 1960N2647XCessna 206 · S/N P206-0147Cancelled Sep 18, 2012 · Registration expired, pending cancellation · Built 1965 · Fresno Skyriders IncN3069PPiper PA-23-150 · S/N 23-987Cancelled Sep 5, 2012 · Sale reported, canceled · Built 1957N66976Cessna T-50 · S/N 2935Cancelled Sep 5, 2012 · Revoked, canceled · Tawco Constr IncN5637QMooney M20C · S/N 3017Cancelled Aug 27, 2012 · Revoked, canceled · Built 1965 · Industrial Leasing CoN5542XAero Commander S2R · S/N 1742RCancelled Aug 23, 2012 · Revoked, canceled · Built 1973 · Milliron MichaelN535ABellanca 14-19 · S/N 2088Cancelled Aug 21, 2012 · Revoked, canceled · Built 1951 · Wheeler Norman ON707TBBeech 65-A80 · S/N LD-169Cancelled Jul 9, 2012 · Registration pending, canceled · Built 1964N2466DPiper PA-38-112 · S/N 38-79A0324Cancelled Jun 28, 2012 · First renewal notice · Built 1978 · Golden Eagle Enterprises IncN400TACessna 411 · S/N 411-0064Cancelled Jun 27, 2012 · Sale reported, pending cancellation · Built 1965N2572NPiper PA-38-112 · S/N 3879A0925Cancelled Nov 9, 2011 · Second renewal notice · Golden Eagle Enterprises IncN40521Balloon Works FIREFLY 7 · S/N 10079Cancelled Mar 8, 2011 · Expired dealer · Built 1980 · Corlew Michael F DBAN4401XPiper PA-28-151 · S/N 28-7615007Cancelled Mar 8, 2011 · Triennial form not returned · Built 1975 · Morris ChesterN759YJCessna 182Q · S/N 18266362Cancelled Dec 21, 2010 · Exported to Mexico · Built 1978 · Lev Warren J
Back to Fresno, CA