Buena Park, CA

Cancelled registrations · 40

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 = 'BUENA PARK'
  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.

N9944ACessna 170A · S/N 19414Cancelled Oct 1, 2022 · Registration expired, pending cancellation · Built 1950 · Brown GordonN24634Piper PA-38-112 · S/N 38-79A1139Cancelled Mar 2, 2021 · Exported to New Zealand · Built 1979 · Foster Marlene JN19050Taylorcraft A · S/N 156Cancelled Mar 20, 2020 · Revoked, canceled · Built 1937 · Mcmillin Donald LN66693Stinson L-5 · S/N 76183Cancelled Mar 20, 2020 · Revoked, canceled · Built 1943 · Liapis GeorgeN5851HPiper PA-16 · S/N 16-468Cancelled Jan 24, 2020 · Revoked, canceled · Built 1949 · Willshon Raymond EN63CBBanks Charles L VARI EZE · S/N 1168Cancelled Feb 5, 2018 · Sale reported, pending cancellationN8840DPiper PA-22-150 · S/N 22-6010Cancelled Feb 4, 2017 · Revoked, canceled · Built 1958 · Painter Erskine G IVN64193Cessna 172M · S/N 17265078Cancelled May 19, 2015 · Registration expired, pending cancellation · Built 1975 · Bryant Patrick WN2556DPiper PA-38-112 · S/N 38-79A0371Cancelled Sep 22, 2014 · Registration expired, pending cancellation · Built 1978 · Crowder Kenneth IN7039JLeister Gene RANS S-12 · S/N 0291062Cancelled Sep 26, 2013 · Registration expired, pending cancellation · Leister GeneN6412Gregg BENSEN B-8M · S/N 1Cancelled Aug 6, 2013 · Revoked, canceled · Built 1973 · Brawley William RN62132Derusha BENSEN B-8M · S/N WCD-1Cancelled Aug 5, 2013 · Revoked, canceled · Built 1975 · Derusha William CN88961Mac Bensen B-8M · S/N 601Cancelled Jul 9, 2013 · Registration expired, pending cancellation · Built 1966 · Mcnutt Clarence AN4439ZNish Kevin M KR-2 · S/N 1Cancelled Jun 12, 2013 · Registration expired, pending cancellation · Built 1984 · Nish Kevin MN8854NPiper PA-28-140 · S/N 28-25708Cancelled May 15, 2013 · Registration expired, pending cancellation · Built 1969 · Sims Kenneth LN8168Schempp-Hirth CIRRUS · S/N 65Cancelled May 13, 2013 · Registration expired, pending cancellation · Built 1969 · Hatfield Daniel VictorN6GWPiper PA-31-350 · S/N 31-7405139Cancelled Apr 26, 2013 · Registration expired, pending cancellation · Built 1973 · Weston Thomas JN4134PPiper PA-23-160 · S/N 23-1614Cancelled Mar 11, 2013 · Registration expired, pending cancellation · Built 1959 · Shepard Richard LN3123ACessna 170B · S/N 25767Cancelled Nov 6, 2012 · Registration expired, pending cancellation · Built 1953 · Barber Smedley ON82756Let BLANIK L-13 · S/N 025511Cancelled Feb 25, 2012 · Third renewal notice · Built 1973 · Orange County Soaring AssociationN4924SCessna TR182 · S/N R18201463Cancelled Jun 14, 2010 · Exported to Philippines · Long Beach Travel Center IncN90620Let BLANIK L-13 · S/N 025616Cancelled Jan 26, 1998 · Triennial form not returned · Orange County Soaring AsscN3079KHaddix Dan R KOLB TWINSTAR MK II · S/N M2204Cancelled Dec 16, 1993 · Haddix Dan RN8620NPiper PA-32-300 · S/N 327140012Cancelled Apr 25, 1992 · Triennial form not returned · Nathaniel Sheldon JN88962June Bensen B-8M · S/N 602Cancelled Feb 6, 1991 · Triennial form not returned · Mcnutt June DN64400Terry JEANIES TEENIE · S/N A1GTCancelled Dec 24, 1981 · Yaberg Forrest LN2468SCessna T337C · S/N 337-0768Cancelled Sep 30, 1981 · Built 1967 · Glaser Leon HN9SLLemire-Schultz FORMULA SL-1 · S/N 001Cancelled Feb 23, 1981 · Lemire William LN30748Cessna 177 · S/N 17701441Cancelled Mar 9, 1978 · Built 1969 · Jacobs Stanley RN21DDDoyle SCORPION TOO · S/N 7894Cancelled Feb 7, 1977 · Dellow DoyleN421WBCessna 411 · S/N 411-0018Cancelled Jan 27, 1975 · Built 1965 · Modern Materials IncN15118Bell HTL-4 · S/N 238Cancelled Jan 7, 1971 · Built 1966 · Dick John MN84500Aeronca 7AC · S/N 7AC-3196Cancelled Dec 31, 1970 · Crapo David LN8681RSchweizer SGS 1-26A · S/N 206Cancelled Aug 27, 1970 · Built 1963 · Orange County Soaring Assn IncN7321DPiper PA-22-150 · S/N 22-5109Cancelled Jun 9, 1970 · California Alliagator FarmN46116Cessna 172I · S/N 17257050Cancelled Feb 12, 1969 · Built 1968 · Sutter Clifford M Et AlN78902Mooney M20B · S/N 1916Cancelled Jan 30, 1969 · Exported to Canada · Brundage Richard MN7172TCessna 172A · S/N 46772Cancelled Nov 13, 1967 · Berns Bernard CN48957Aeronca 0-58B · S/N 3292Cancelled Oct 29, 1963 · Smith James PaulN49625Piper J-3C · S/N G-215Cancelled Nov 5, 1957 · Exported to Switzerland · Cordova Jack
Back to Buena Park, CA