Skip to content

Chula Vista, CA

Cancelled registrations · 83

Query with SQL

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 = 'CHULA VISTA' ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

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 = 'CHULA VISTA'
  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.

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 = 'CHULA VISTA'
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N999GABeech 200 · S/N BB-929Cancelled Dec 29, 2022 · Registration expired, pending cancellation · Built 1981 · Gamez Jose Abel N619TDPhysical Sciences INSTANTEYE MK-2 GEN3 · S/N 0030200300634Cancelled Dec 8, 2020 · Registration expired, pending cancellation · Chula Vista Police Foundation N147KJJames Keith W RAPTOR · S/N AR-2003-1Cancelled Nov 25, 2020 · First renewal notice · Built 2003 · Leyva Ralph R N858JEPhysical Sciences INSTANTEYE MK-2 GEN3 · S/N 0030200300635Cancelled Oct 31, 2020 · Registration expired, pending cancellation · Chula Vista Police Foundation N7840KCessna P210N · S/N P21000435Cancelled Aug 2, 2020 · Registration expired, pending cancellation · Built 1979 · Van Wormer Edward A N8618JCessna 150G · S/N 15066518Cancelled Oct 17, 2019 · Exported to Mexico · Dale Arthur A N8090PCameron Balloons US Z-105 · S/N 6278Cancelled Jun 26, 2018 · Registration pending, canceled · Built 2001 N865AAGulfstream Aerospace G1159B · S/N 048Cancelled Apr 2, 2018 · Registration expired, pending cancellation · Built 1969 · Sky Opt LLC N29914Waco UPF-7 · S/N 5411Cancelled Mar 23, 2018 · Revoked, canceled · Built 1940 · Spiers Woodson M N425SVGulfstream American G-1159A · S/N 360Cancelled Mar 16, 2018 · Registration expired, pending cancellation · Sky Opt LLC N75418Beech C18S · S/N 4245Cancelled Feb 28, 2018 · Registration expired, pending cancellation · Built 1942 · Babcock Alan N7541SSmith AEROSTAR 600 · S/N 600172076Cancelled Feb 28, 2018 · Registration expired, pending cancellation · Built 1974 · Babcock Alan N327RSSmith Ralph D ASAP CHINOOK +2 · S/N 2206XSCancelled Feb 15, 2018 · Sale reported, canceled · Built 2001 N4708FCessna P206B · S/N P206-0308Cancelled Oct 31, 2017 · Registration expired, pending cancellation · Built 1967 · Hodges Arthur E III N8070YRotec PANTHER 2+ · S/N Z1000Cancelled Jul 18, 2017 · Registration expired, pending cancellation · Trumble Gloria Conservator N77092Cessna 120 · S/N 11550Cancelled May 23, 2017 · Registration expired, pending cancellation · Built 1946 · Johnson Donald A N7437MCessna 175 · S/N 55737Cancelled Feb 4, 2017 · Revoked, canceled · Built 1958 · Smith J P Jr N47750Aeronca 0-58A · S/N 42-7794Cancelled May 20, 2015 · Registration expired, pending cancellation · Built 1945 · Maioroff Robert N2269FFeuling-Robert AX-8P · S/N 001Cancelled May 15, 2015 · Registration expired, pending cancellation · Built 1978 · Feuling Robert J N2260RCessna T210J · S/N T2100410Cancelled May 13, 2015 · Registration expired, pending cancellation · Built 1968 · Zamora Daniel N3774QBeech 95-C55 · S/N TE-320Cancelled Apr 30, 2015 · Registration expired, pending cancellation · Built 1967 · Earl A Bauer Jr Md Inc N955WSiai-Marchetti S.205/22R · S/N 4-155Cancelled Nov 24, 2014 · Registration expired, pending cancellation · Built 1969 · Ruble Jesse L N2452JCessna 150G · S/N 15065552Cancelled Sep 22, 2014 · Registration expired, pending cancellation · Built 1966 · Schneider Charles N2231QDelgado Victor M RANS S-12 AIRAILE · S/N 1191153Cancelled Nov 7, 2013 · Registration expired, pending cancellation · Delgado Victor Manuel N732KMCessna T210L · S/N 21061573Cancelled Oct 24, 2013 · Registration expired, pending cancellation · Built 1976 · Angulo Javier A N67627Convair BT-13 · S/N 355Cancelled Oct 23, 2013 · Revoked, canceled · Built 1940 · Davies Aubert V N6528XBoykin Samuel Alfred QUICKSILVER MXL II · S/N 1047Cancelled Oct 18, 2013 · Registration expired, pending cancellation · Built 1991 · Boykin Samuel A N75399Pegasus 912q Q2 · S/N 7479Cancelled Sep 30, 2013 · Sale reported, canceled · Built 1998 N8066JHitchcock Greg E GYRACAR BG5 · S/N 1Cancelled Aug 28, 2013 · Registration expired, pending cancellation · Hitchcock Greg E N460CACessna 310C · S/N 35957Cancelled Aug 14, 2013 · Sale reported, canceled · Built 1959 N3447UCessna 182F · S/N 18254847Cancelled Aug 13, 2013 · Registration expired, pending cancellation · Built 1963 · Reed John M N390DSSerra Donald W CGS HAWK A · S/N H-8-390-KCancelled Jul 30, 2013 · Registration expired, pending cancellation · Serra Donald W N19573Cessna 150L · S/N 15074497Cancelled Apr 11, 2013 · Registration expired, pending cancellation · Built 1973 · Price James B N31EAPetersen EAGLET · S/N 31Cancelled Mar 25, 2013 · Sale reported, canceled N48MJBillings Roy H SUPER SEAHAWK · S/N 001Cancelled Mar 25, 2013 · Sale reported, canceled · Built 2001 N6871RCessna T210G · S/N T210-0271Cancelled Feb 15, 2013 · Sale reported, canceled · Built 1967 N2509JCessna 150E · S/N 15061009Cancelled Oct 18, 2012 · Registration expired, pending cancellation · Built 1964 · Bennett James E N5718Wagner B-8M · S/N 1153Cancelled Sep 25, 2012 · Sale reported, pending cancellation · Built 1974 N1570KLuscombe 8 · S/N 4297Cancelled Aug 8, 2012 · Registration expired, pending cancellation · Built 1946 · Bennett Michael R N1406QCessna TU206F · S/N U20602897Cancelled Jan 19, 2012 · Exported to Mexico · Contreras Vicente DBA N1471MCessna U206E · S/N U20601471Cancelled Nov 1, 2010 · Exported to Mexico N42193Guzman Antonio P B8M · S/N AG-001Cancelled Sep 1, 2009 · Second triennial form not returned · Guzman Antonio P N2455Brem-Ramey-Stahlheber BENSEN B8 · S/N 1Cancelled Jul 14, 2009 · Registration revoked · Built 1970 · Stahlheber Alvin H N86076Cessna 337D · S/N 337-1067Cancelled Jul 31, 2008 · Exported to Mexico · Built 1969 · Paladin Aviation Inc N14GABoeing 727-227 · S/N 21246Cancelled Jul 8, 2002 · Exported to Ecuador · Built 1976 · Rohr Inc N77JTThomson John P ULTRA-PUP · S/N 3JCancelled Dec 18, 2001 · Built 2000 · Thomson John P N888BRCessna 210 · S/N 57115Cancelled Oct 24, 2000 · Exported to Mexico · Harshbarger Richard N5675ZPiper PA-22-108 · S/N 22-9501Cancelled Nov 9, 1999 · Triennial form not returned · Byrne Joseph M N70912Bartlett Kendall GYROPLANE · S/N 1Cancelled Mar 6, 1998 · Triennial form not returned · Bartlett Harrison K N3994KKramp Eugene H KR-2 · S/N 5600Cancelled Jun 29, 1994 · Triennial form not returned · Kramp Eugene H

Back to Chula Vista, CA