Sunnyvale, CA

Cancelled registrations · 97

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

N9288XPiper PA-32R-301T · S/N 3257027Cancelled May 3, 2007 · Exported to Brazil · Tenedorio Jaime GN4390DPiper PA-28-161 · S/N 28-8516028Cancelled Mar 19, 2007 · Exported to Canada · Built 1985 · Garcia JavierN107BCPZL MI-2 · S/N 5310928069Cancelled Feb 16, 2006 · Exported to Venezuela · Kaplunovsky YulieN581ARBereznak Bradley J LANCAIR 360 · S/N BJB-1Cancelled Mar 31, 2005 · Triennial form not returned · Bereznak Bradley J TrusteeN8481ECessna 172N · S/N 17272211Cancelled Mar 8, 2004 · Exported to Philippines · Built 1979 · Etem Kamil LN6183QCessna 320F · S/N 320F-0033Cancelled Jul 24, 2003 · Exported to Canada · Built 1967 · Heaton RickN28299Grumman American Avn. AA-5B · S/N AA5B0537Cancelled Apr 2, 2001 · Triennial form not returned · Haas Catherine SN4329KPeterson Charles Eugene REVLTN MINI-500 BRVO · S/N 0421Cancelled Feb 21, 2001 · Peterson Charles EN8343DBeech J35 · S/N D-5431Cancelled Mar 19, 1999 · Triennial form not returned · Imago DataN5082WPiper PA-28 · S/N 2891Cancelled May 6, 1997 · Triennial form not returned · Wright Carol LN69SWWorthington Sean T BD-5B · S/N 001Cancelled Aug 21, 1996 · Triennial form not returned · Worthington Sean TN28117Raven S-60A · S/N S60A415Cancelled Nov 13, 1995 · Triennial form not returned · Civiletti Joseph JN63CMCalifornia Microwave CM-44B · S/N 003Cancelled Jan 28, 1993 · Triennial form not returned · California Microwave IncN112CMCalifornia Microwave CM-44B · S/N 002Cancelled Jan 26, 1993 · Triennial form not returned · California Microwave IncN827MCBeech F33A · S/N CE1230Cancelled Apr 20, 1992 · Triennial form not returned · Toyota SunnyvaleN72AUHunter Neil LONG-EZ · S/N 317Cancelled Feb 27, 1992 · Triennial form not returned · California Microwave IncN3226VBeech 35 · S/N D-669Cancelled Jun 15, 1984 · Administratively canceled · Kirkham George DN67145Piper PA-28-180 · S/N 28-3525Cancelled May 27, 1983 · Walker Beverly AnnN528QBeech E33A · S/N CE191Cancelled Nov 15, 1982 · Plucinski Francis AN94322Cessna 182Q · S/N 18266408Cancelled Oct 14, 1982 · Administratively canceled · Szajvolt BelaN757BDCessna 152 · S/N 15279602Cancelled Dec 17, 1981 · Crowley Ross F & EvaN5611GCessna 150J · S/N 15071111Cancelled Jun 3, 1981 · Lockheed Employees Recreation AssocN5650O R Craig B-8M · S/N 1Cancelled Jun 3, 1981 · Craig Oren RN733HGCessna 172N · S/N 172-68302Cancelled Dec 23, 1980 · Fink Lyle DN95887Taylorcraft BC12-D · S/N 8187Cancelled Jun 22, 1979 · Wildman Richard A Wildman Pierre CN5394Sircco MJ55F2 · S/N 158Cancelled Jul 8, 1977 · Moots Elmer E JrN710BBeech A35 · S/N D-1715Cancelled Sep 2, 1976 · Warbrick Warren LN5519RCessna 172F · S/N 17253095Cancelled Jun 13, 1976 · Hendricks Dewayne LN4612RPiper PA-28-140 · S/N 28-21361Cancelled Nov 24, 1975 · Weckerle Richard C Et AlN5250XChampion 7KCAB · S/N 224Cancelled Aug 14, 1975 · De Lateur Robert EN6371FCessna 337A · S/N 337-0371Cancelled Apr 9, 1975 · Exported to Canada · Hensien Herbert SN8680NPiper PA-32-300 · S/N 32-7240024Cancelled Sep 20, 1974 · Alaburda Dennis AN4717VBellanca 17-30 · S/N 30058Cancelled Apr 23, 1974 · Bates Donald RN3879Bensen B-8-KC · S/N 10345Cancelled Nov 15, 1972 · Built 1971 · Slocum RogerN3427RPiper PA-28-180 · S/N 28-5677Cancelled Aug 14, 1972 · Kelsey PattersonN10364Schweizer SGS 1-23H-15 · S/N 47Cancelled Sep 2, 1971 · Calcondors Soaring ClubN2875CCessna 170B · S/N 26418Cancelled Mar 1, 1971 · Kenneth D Cornwell DBA C&A BuildersN2800GNorth American T-28A · S/N 49-1628Cancelled Sep 4, 1970 · Rivera Jose GeorgeN55FBeech 35 · S/N D-254Cancelled Sep 1, 1970 · Pelzl John And Pelzl JanetN5937TCessna 150D · S/N 15060637Cancelled Jun 25, 1970 · Grant W StephensenN5385LPiper PA-28-180 · S/N 28-4692Cancelled Jun 18, 1970 · San Jose Flying Jaguars IncN1608LLockheed Aircraft Intl 402-2 · S/N 1025Cancelled Jun 8, 1970 · Built 1962 · Lockheed Employees Recreation AssocN4919Homebuilt MINIPLANE · S/N VTOL-1Cancelled Nov 14, 1967 · Green Max RN68274Schweizer TG3A · S/N 103Cancelled Nov 27, 1961 · Ames Soaring ClubN37052Luscombe 8C · S/N 1713Cancelled May 8, 1951 · Built 1941 · Liddell RobertN97309Stinson 108 · S/N 108-309Cancelled Aug 30, 1949 · H G Wanderer & H G DiesnerN6162LAmerican AA-1 · S/N AA1-0362Cancellation date not recorded · Weil John R Jr
Back to Sunnyvale, CA