Stockton, CA

Cancelled registrations · 236

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

N6777HCessna 172M · S/N 17265577Cancelled Sep 5, 2013 · Exported to Kenya · Built 1975 · Plane Exchange IncN68285Cessna 152 · S/N 15282229Cancelled Sep 5, 2013 · Exported to Kenya · Built 1978 · Plane Exchange IncN7878SBell 47G-3B-1 · S/N 6620Cancelled Aug 22, 2013 · Sale reported, canceled · Built 1967N9763ZBell 47G-2 · S/N 29Cancelled Aug 21, 2013 · Sale reported, canceledN3000JCessna 150E · S/N 15061100Cancelled Aug 19, 2013 · Sale reported, canceled · Built 1965N91MDDixon Myron B BUSHBY MUSTANG II · S/N 1-1058-ACancelled Aug 19, 2013 · Sale reported, canceledN254BHHalkett Brian K BH-1 · S/N 001Cancelled Jul 29, 2013 · Sale reported, canceledN79972Cessna 172K · S/N 17258294Cancelled Jul 22, 2013 · Exported to Philippines · Built 1969N71145Balloon Works FIREFLY 7 · S/N F7-409Cancelled Jul 2, 2013 · Registration expired, pending cancellation · Built 1987 · Johanson MarkN7835GCessna 172L · S/N 17259535Cancelled Jun 26, 2013 · Exported to United Arab Emirates · Built 1970 · Plane Exchange IncN6280NBell 206A · S/N 146Cancelled Jun 14, 2013 · Registration expired, pending cancellation · Built 1968 · Alpine Helicopters Service IncN7759Ryan Aeronautical ST3KR · S/N 1162Cancelled Jun 14, 2013 · Registration expired, pending cancellation · Built 1941 · Aero Nostalgia IncN9660CBeech C-45G · S/N AF-220Cancelled Jun 14, 2013 · Sale reported, canceled · Built 1959N935KGilligan John E OSPREY 2 · S/N 935Cancelled Jun 11, 2013 · Registration expired, pending cancellation · Gilligan John EN23WMMinatre William J 1980 KR-2 · S/N KR22323Cancelled Jun 5, 2013 · Registration expired, pending cancellation · Built 1980 · Minatre William JN8050AHentschel Edward H R BENSEN B8M · S/N EH-1Cancelled May 13, 2013 · Registration expired, pending cancellation · Built 1979 · Hentschel Edward H RN66BJO'Connor DUSTER BJ-1B · S/N 30Cancelled Apr 30, 2013 · Registration expired, pending cancellation · Built 1975 · Paine Brian ON62421Hiller UH-12E · S/N 1731Cancelled Apr 29, 2013 · Registration expired, pending cancellation · Built 1965 · Alpine Helicopter Service IncN59505Ryan Aeronautical ST3KR · S/N 1412Cancelled Apr 24, 2013 · Registration expired, pending cancellation · Built 1941 · Aero Nostalgia IncN5326JCessna 172N · S/N 17273760Cancelled Apr 23, 2013 · Exported to United Arab Emirates · Built 1980 · Plane Exchange IncN5287HPiper PA-16 · S/N 16-91Cancelled Apr 18, 2013 · Registration expired, pending cancellation · Built 1949 · Padayhag Patricio ManuelN409FLRobinson Helicopter R22 ALPHA · S/N 0409Cancelled Apr 1, 2013 · Sale reported, canceled · Built 1984N7865SBell 206A · S/N 51Cancelled Feb 27, 2013 · Sale reported, canceled · Built 1967N7890SBell 206A · S/N 73Cancelled Feb 27, 2013 · Sale reported, canceled · Built 1967N6839BPiper PA-22-150 · S/N 22-4137Cancelled Feb 13, 2013 · Sale reported, canceled · Built 1956N3734MBeech 76 · S/N ME-366Cancelled Jan 28, 2013 · Exported to Kenya · Built 1980 · Plane Exchange IncN9842LCessna 320B · S/N 320B0042Cancelled Dec 19, 2012 · Sale reported, pending cancellation · Built 1963N4754RBell 47G-5 · S/N 7924Cancelled Dec 13, 2012 · Registration expired, pending cancellation · Built 1969 · Ainsworth Rodger LN777YDFrahm/Oranges/Ross CHRISTEN EAGLE II · S/N FRAHAM 0001Cancelled Nov 19, 2012 · Registration expired, pending cancellation · Frahm Brad KN2250ZBell 47G-4 · S/N 3356Cancelled Oct 16, 2012 · Registration expired, pending cancellation · Built 1965 · Eccles Richard DN66969Cessna T-50 · S/N 3520Cancelled Sep 5, 2012 · Revoked, canceled · Weber Charles MN67636Cessna T-50 · S/N 1945Cancelled Sep 5, 2012 · Revoked, canceled · Built 1942 · Liddicoat Curtis AN111BVBeech 76 · S/N ME-338Cancelled Jul 12, 2012 · Expired dealer · Built 1980 · Creative AviationN444ABAuger AUGER N TWIN · S/N 1Cancelled Jul 9, 2012 · Revoked, canceled · Auger Allen DN2879BBell 47G-2 · S/N 1692Cancelled Feb 15, 2012 · Sale reported, pending cancellation · Built 1957N714BXCessna 150M · S/N 15079060Cancelled Sep 6, 2011 · Exported to India · Built 1976 · Creative AviationN152BRCessna 152 · S/N 15285232Cancelled Mar 2, 2011 · Exported to India · Creative AviationN9215NPiper PA-34-220T · S/N 3448011Cancelled Feb 9, 2011 · Exported to India · Built 1990 · Creative AviationN233CAGates Lear Jet 25B · S/N 133Cancelled Dec 8, 2010 · Exported to India · Built 1973 · Creative AviationN4935HCessna 152 · S/N 15284030Cancelled Dec 7, 2010 · Exported to India · Built 1979 · Creative AviationN89707Cessna 152 · S/N 15282833Cancelled Dec 7, 2010 · Exported to India · Built 1978 · Creative AviationN3BBennett BREEZY SPECIAL HB69 · S/N HB-69Cancelled Jul 26, 2010 · Built 1969 · Duraflame IncN49397Cessna 152 · S/N 15281236Cancelled May 4, 2010 · Exported to India · Built 1977 · Creative AviationN49392Cessna 152 · S/N 15281232Cancelled Mar 25, 2010 · Exported to India · Built 1977N49441Cessna 152 · S/N 15281270Cancelled Mar 22, 2010 · Exported to India · Built 1978 · Creative AviationN2107NCessna T206H · S/N T20608450Cancelled Feb 5, 2010 · Exported to India · Built 2004 · Creative AviationN45066Cessna 150M · S/N 15076720Cancelled Oct 28, 2009 · Exported to Fiji · Built 1975 · Shibler DeanN4012JRobinson Helicopter R22 BETA · S/N 1420Cancelled Oct 19, 2009 · Exported to India · Built 1990 · Creative AviationN5484QCessna 150L · S/N 15073384Cancelled Oct 19, 2009 · Exported to India · Built 1972 · Creative AviationN5175MCessna 152 · S/N 15284503Cancelled Sep 25, 2009 · Exported to India · Built 1980 · Delta Flying Club LLC
Back to Stockton, CA