OpenAirDocs.org
San Pedro, CA

Cancelled registrations · 51

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 = 'SAN PEDRO'
  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.

N2ZEPage/Le Master VARI-EZE · S/N 522Cancelled May 17, 2023 · Built 1983 · Swift Air International IncN94737Engineering & Research ERCOUPE 415-CD · S/N 4848Cancelled Mar 23, 2023 · Abrams Linda TN4931Briegleb BG12B · S/N 113-ABCancelled Dec 16, 2019 · First renewal notice · Cueto William EN1994BLuscombe 8A · S/N 6421Cancelled Sep 6, 2019 · Revoked, canceled · Built 1948 · Fogg Harold JrN1555Stolp-Adams SA-100 · S/N A-1Cancelled May 15, 2019 · Revoked, canceled · Built 1968 · Albrigt Allen H Co OwN94406Engineering & Research ERCOUPE 415-G · S/N 5038Cancelled Jun 4, 2018 · Sale reported, canceled · Built 1949N1730CCoates Michael F CHALLENGER I · S/N CW1190-L30Cancelled Jul 19, 2017 · Registration expired, pending cancellation · Coates Michael FN304FMAerospatiale Potez Air Fouga CM170 · S/N 328Cancelled Nov 8, 2016 · Exported to France · Swift Air International IncN5681BCessna 182 · S/N 33681Cancelled Dec 12, 2015 · Second renewal notice · Built 1956 · Seixas James BN225RJCessna T210G · S/N T210-0287Cancelled Dec 2, 2014 · Registration expired, pending cancellation · Built 1967 · Munoz FredN15LTBeech 35-C33 · S/N CD-956Cancelled Sep 20, 2013 · Registration expired, pending cancellation · Built 1965 · Kim EricN5798KBell UH-1H · S/N 65-09848Cancelled Aug 22, 2013 · Sale reported, canceledN2996WBell 47G-5A · S/N 25083Cancelled Jul 18, 2013 · Registration expired, pending cancellation · Built 1972 · Zeta Fishing Company IncN90LMMay James F 5151 · S/N 001Cancelled Jul 10, 2013 · Sale reported, canceled · Built 1991N98KTSud SE 210 CARAVELLE VIR · S/N 102Cancelled May 30, 2013 · Registration expired, pending cancellation · Built 1961 · Mpc Barton Associates L PN4927ESikorsky S-51 · S/N 51214Cancelled Dec 18, 2012 · Registration expired, pending cancellation · Petkow Louis HN4789RCessna 172RG · S/N 172RG0032Cancelled Dec 13, 2012 · Registration expired, pending cancellation · Built 1979 · Iacono Frank MN3874Walters DUSTER BJ1B · S/N 63Cancelled Nov 14, 2012 · Registration expired, pending cancellation · Built 1973 · Eagers Claire AN211CBBell 47G-5A · S/N 25073Cancelled Oct 16, 2012 · Registration expired, pending cancellation · Built 1972 · Eta Fishing CompanyN11694Bellanca 7GCAA · S/N 238-72Cancelled Jun 4, 2012 · Sale reported, canceled · Built 1972N1109NHughes Helicopters HUGHES 369D · S/N 1100846DCancelled May 25, 2011 · Registration pending, canceled · Built 1980N707MTOyama Masaaki Frank OYAMA TWIN 503SL · S/N TWIN 2000Cancelled Jan 28, 2008 · Exported to Mexico · Built 2000 · Oyama Masaaki FrankN62799Cessna 172P · S/N 17275339Cancelled Jan 3, 2002 · Exported to Thailand · Built 1981 · South Bay International Flight Association IncN923APLezie James P AIR COMMAND 532 · S/N JL1Cancelled Jul 2, 1996 · Lezie James PN235JSScott Jerry DRAGONFLY · S/N 829Cancelled Aug 26, 1992 · Moon Maurice DN5257VCessna 172RG · S/N 172RG0487Cancelled Feb 26, 1992 · Triennial form not returned · Bacon Robert WN8174LCessna 172H · S/N 17256374Cancelled Nov 29, 1983 · Administratively canceled · Singleton Patricia MN12BSSater THORP T-18 · S/N 804Cancelled Oct 4, 1976 · Sater Robert AN18CSGrumman G-21A · S/N B-59Cancelled Jun 16, 1976 · Catalina Seaplanes IncN16431Piper PA-28-180 · S/N 28-7305253Cancelled Nov 15, 1973 · Marsh Terrell L / Marsh BarbaraN9196WPiper PA-28-235 · S/N 28-10854Cancelled Feb 23, 1972 · Immigration & Naturalization ServiceN3429VCessna 195 · S/N 7166Cancelled Sep 28, 1971 · Katten Stanley LN8916TCessna 182C · S/N 52816Cancelled Jul 15, 1971 · Ravanell Robert GN4017KRyan NAVION A · S/N NAV-4-1017Cancelled Jan 18, 1971 · Baggs J E &/Or Baggs Marjorie RN4088ZPiper PA-18 · S/N 18-8103Cancelled Oct 6, 1970 · Built 1964 · Immigration & Naturalization ServiceN325Grumman G-21A · S/N B127Cancelled Oct 21, 1968 · Catalina Seeplanes IncN28PPiper PA-23 · S/N 23-117Cancelled Jun 12, 1965 · Tipich Carol AnneN86801Bellanca 14-13-2 · S/N 1162Cancelled May 24, 1965 · Demott Leslie DN4389VCessna 195 · S/N 7311Cancelled May 22, 1965 · Cromp A LarsN6789DBeech F35 · S/N D-4347Cancelled May 22, 1965 · James H Cornell JrN543ABellanca 14-19 · S/N 2096Cancelled May 18, 1965 · Schmit Robert A MdN8574DPiper PA-18-150 · S/N 18-6230Cancelled Jul 13, 1961 · Immigration And Naturalization ServiceN3535CCessna 170B · S/N 26578Cancelled Nov 19, 1959 · Exported to Mexico · Whalen JackN49194Taylorcraft DCO-65 · S/N L-5820Cancelled Sep 11, 1959 · Exported to Mexico · Petersen Donald WN2317DCessna 170B · S/N 20469Cancelled Jan 23, 1959 · Exported to Mexico · Whalen John EN6306MStinson 108-3 · S/N 108-4306Cancelled Sep 12, 1957 · Maynor Jack W & Helena A MaynorN1916APiper PA-18 · S/N 18-1777Cancelled Jul 23, 1956 · Exported to Mexico · Department Of JusticeN68331Consolidated Vultee BT-13 · S/N 373Cancelled Feb 17, 1956 · Grice William LN74274Bellanca 14-13-2 · S/N 1387Cancelled Dec 12, 1955 · S Andre ShallenbergerN17378Fetters R/Morrison W 002 · S/N 2Cancelled Jun 27, 1939 · Built 1937 · Morrison Warren Etal
Back to San Pedro, CA