Compton, CA

Cancelled registrations · 111

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

N61011Cessna 150J · S/N 15070732Cancelled Oct 16, 1972 · B T FloydN91315Douglas C-47B · S/N 33542Cancelled Jan 12, 1971 · Mansdorf LeeN43514Taylorcraft BC12-D · S/N 7173Cancelled Jan 11, 1971 · Fleetwing Flying ClubN80190Beech D18S · S/N A-291Cancelled Jan 5, 1971 · Built 1946 · Stanley OrrN7160XCessna 150A · S/N 15059260Cancelled Jan 4, 1971 · Stephens Clifford DN2433UCessna 172D · S/N 17250033Cancelled Dec 4, 1970 · James H WhitmoreN91637North American NAVION · S/N NAV4158Cancelled Aug 19, 1970 · Livesay Bros Plbg IncN3326BPiper PA-22-135 · S/N 22-2141Cancelled Jun 29, 1970 · 47 Flying Service IncN67224Cessna AT 17B · S/N 3050Cancelled Jun 29, 1970 · Compton Truck & Equipment CoN3554UCessna 182F · S/N 18254954Cancelled Mar 27, 1968 · Benner Elmer E DBA Ben Air AviationN2353QBeech 23 · S/N M-421Cancelled Mar 8, 1968 · Claus Leslie VN89805Cessna 120 · S/N 8854Cancelled Feb 7, 1966 · Conran William JN4642ZPiper PA-22 · S/N 22-8161Cancelled Jan 26, 1966 · 47 Flying Service IncN50220Timm N2T-1 · S/N 296Cancelled Jun 5, 1965 · Berry Russell JustinN9829CConsolidated Vultee P4Y-2 · S/N 59932Cancelled May 28, 1965 · Walter Metals CoN4303VCessna 195 · S/N 7202Cancelled Dec 28, 1964 · Mcmahon Eugene EN5756WPiper PA-28-150 · S/N 28-1517Cancelled Dec 12, 1964 · Brown Richard V EtalN2742MPiper PA-12 · S/N 12-1145Cancelled Mar 29, 1963 · Built 1946 · Woodley EarlN71140Luscombe 8A · S/N 2567Cancelled Jan 5, 1959 · Built 1946 · Causey Richard WN77100Cessna 120 · S/N 11558Cancelled Jul 19, 1957 · Lane John LN65177Stinson VULTEE V-77 · S/N 77-183Cancelled Mar 12, 1957 · Salesmakers Co IncN52209Consolidated Vultee BT-13A · S/N 3563Cancelled Mar 29, 1956 · J H Johnson And E E GrovesN66664Consolidated Vultee BT-13A · S/N 6121Cancelled Mar 14, 1956 · Cooper PhillN86917Bellanca 14-13-2 · S/N 1279Cancelled Feb 20, 1956 · Layton Edwin LN1096KLuscombe 8A · S/N 3823Cancelled Feb 14, 1956 · Wysong John WN56007Ryan Aeronautical PT-22 · S/N 2090Cancelled Jul 11, 1955 · Beese John JN30018Consolidated Vultee BT-13 · S/N 7397Cancelled Mar 23, 1955 · Earl WoodleyN48908Taylorcraft L-2M · S/N 5419Cancelled Mar 4, 1955 · Bertle F PalmerN68148Cessna T-50 · S/N 6356Cancelled Feb 9, 1955 · Compton Tool & Die CoN34555Aeronca 65-CA · S/N CA-15731Cancelled Jul 21, 1954 · Smith J RN6818MStinson 108-3 · S/N 108-4818Cancelled Jul 21, 1954 · Exported to Canada · Woodley EarlN36108Taylorcraft BF-65 · S/N 3075Cancelled May 28, 1953 · Shamblin Delmer AN92758Piper PA-12 · S/N 12-200Cancelled Oct 28, 1952 · Woodley EarlN3710KGlobe GC-1B · S/N 1403Cancelled Aug 25, 1952 · Lynn Mechanical DevelopmentN54748Fairchild M-62A · S/N T43-5061Cancelled Mar 7, 1952 · Woodley EarlN948DStinson 108-2 · S/N 108-2948Cancelled Jan 2, 1952 · Woodley EarlN14683Waco CUC · S/N 4282Cancelled Mar 9, 1951 · Nagel John HN8308KStinson 108-1 · S/N 108-1308Cancelled Jun 21, 1949 · Built 1946 · Briggs Charles ON1019Stinson SM-1 · S/N M-205-ACancelled May 18, 1949 · Towers Ernest Alfred & Bain ChesterN2775Waco 9 · S/N 253Cancelled Jul 12, 1948 · Built 1926 · Kolstad Selvin LN14264Kinner SPORTSTER K · S/N 46Cancelled Apr 21, 1948 · Built 1937 · Compton Junior College DistrictN14471Porterfield 35-70 · S/N 131Cancelled Apr 14, 1948 · Built 1935 · Nagel John H DBAN218YKinner Airplane & Motor KINNER 100-K · S/N 22Cancelled Mar 26, 1948 · Built 1933 · Harris John EN218YKinner SPORTSTER K · S/N 22Cancelled Mar 25, 1948 · Glen K BaconN29308Waco UPF-7 · S/N 5335Cancelled Mar 23, 1948 · Towers Ernest AN8435KStinson 108-1 · S/N 108-1435Cancelled Feb 10, 1948 · Pacific Aircraft ComponentsN93577Ercoupe 415-C · S/N 900Cancelled Feb 10, 1948 · Built 1946 · Pacific Aircraft ComponentsN14460Cessna C-34 · S/N 300Cancelled Jun 15, 1946 · Nagel John HN25594Porterfield LP-65 · S/N 694Cancelled Jan 20, 1944 · John George Coulter/Benn Calvin ScottN728VFleet 2 · S/N 341Cancelled May 6, 1943 · Built 1930 · Gage Flying Service
Back to Compton, CA