Anaheim, CA

Cancelled registrations · 151

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

N323DWWilliams Dillard G HURRICAN H P · S/N 072Cancelled Dec 20, 2005 · Williams Dillard GN6210RCessna 172RG · S/N 172RG0116Cancelled Aug 25, 2004 · Triennial form not returned · Built 1979 · Funderburk Raymond TN4247MAvions Mudry ET Cie CAP 10B · S/N EPC-165Cancelled Mar 31, 2004 · Exported to United Kingdom · Built 1982 · Owens Randy DN42KBBrock Kenneth E THORP T-18 · S/N 1439Cancelled Mar 31, 2004 · Triennial form not returned · Built 1982 · Brock Kenneth EN9201BCessna 175 · S/N 55001Cancelled Mar 25, 2003 · Triennial form not returned · Built 1957 · Steinbrink Walter WN364MNicholson Kenneth F LANCAIR 320 · S/N 001Cancelled Mar 19, 2003 · Triennial form not returned · Built 1998 · Nicholson Kenneth FN555HGCessna T210M · S/N 21062929Cancelled Aug 21, 2002 · Exported to Mexico · Built 1978 · Ledbetter Pete GN7QVJacobs John Leicester QUESTAIR VENTURE · S/N 74Cancelled Jun 14, 2002 · Triennial form not returned · Jacobs John LN30034Cessna T210L · S/N 21059878Cancelled Sep 29, 2000 · Triennial form not returned · Beggs Ray ON3788XAero Commander 100 · S/N 283Cancelled Mar 31, 1997 · Exported to Mexico · Knight Douglas EN86234Cessna 337D · S/N 3371120Cancelled Nov 8, 1995 · Triennial form not returned · Ibarra DanN1840FCessna 210F · S/N 21058740Cancelled Oct 3, 1994 · Triennial form not returned · Child Michael TN16RMMcinroy DER JAGER DIX · S/N 165Cancelled Mar 29, 1994 · Triennial form not returned · Ramer Fred MN9691NLockheed C-130A · S/N 57518Cancelled May 17, 1993 · Exported to Mexico · Military Aircraft Restoration CorpN82857Piper PA-28-161 · S/N 288316004Cancelled Aug 12, 1992 · Triennial form not returned · Ruiz Carlos ON9012PJunkers JU-52 · S/N T2B140Cancelled Aug 11, 1992 · Exported to Germany · Military Aircraft Restoration CorpN7346CCessna TU206G · S/N U20603885Cancelled May 1, 1992 · Exported to Mexico · Underground Shoring Specialists IncN2688SCessna T337D · S/N 3370988Cancelled Sep 25, 1991 · Nix Dale WN7700Bolkow PHOEBUS A-1 · S/N 774Cancelled Jan 24, 1985 · Lyman Chester C & Lyman VioletN4906GCessna 172N · S/N 17273453Cancelled Nov 10, 1983 · Built 1979 · Cohen Ronald MN5075CBeech B35 · S/N D2337Cancelled Sep 29, 1983 · Bogar Steven GN14ACCessna 421B · S/N 421B0123Cancelled Sep 24, 1982 · Registration revoked · Sky Charter IncN756XCCessna TU206G · S/N U20604430Cancelled Aug 23, 1982 · Wurth Larry MN877BMooney M20 · S/N 1039Cancelled Dec 17, 1981 · Minklein Glen EN5879GCessna 150K · S/N 15071379Cancelled Jun 15, 1976 · Baldwin Thomas JN2855WBeech A60 · S/N P-229Cancelled Jun 11, 1975 · Sigalos AnthonyN822FCessna 150F · S/N 15064508Cancelled Jun 10, 1975 · Strickland RogerN9076XCessna 182D · S/N 18253476Cancelled May 9, 1975 · Alderdice Wayne BN51342Cessna 150J · S/N 15069938Cancelled Feb 6, 1975 · Built 1968 · Jackson CharlesN9678ZKeb GYRO · S/N KEB1001Cancelled Oct 24, 1974 · Brock KennethN8490ZCessna 210-5A(205A) · S/N 205-0490Cancelled Apr 24, 1974 · Built 1964 · Woodruff Larry E And Grandfield Charles AN2442WSchweizer SGS 2-32 · S/N 45Cancelled Apr 10, 1974 · Bleadon WilliamN2283RCessna T210J · S/N T210-0433Cancelled Apr 8, 1974 · Gray Gordon E / Frisbie Jr James HN3822Barnett J 3M GYRO · S/N RSB-1Cancelled Sep 13, 1973 · Barnett Rollo SN4025Chas Philbrick BG-12BD · S/N 186Cancelled Jun 8, 1972 · Jennings C EN3681KPiper PA-28-140 · S/N 28-23686Cancelled Mar 22, 1972 · Stein VictorN6012XMooney M20A · S/N 1600Cancelled Jan 25, 1972 · S A Equipment CoN7847RBeech 36 · S/N E-131Cancelled Nov 18, 1971 · Done Harris N DdsN6113Keb Bensen Hydrocopter B-8MW · S/N 1003Cancelled Feb 10, 1971 · Kenneth BrockN8764KStinson 108 · S/N 108-1764Cancelled Jan 5, 1971 · Howard M HoopsN1320Craigcraft 1 · S/N 1Cancelled Jul 21, 1970 · Craig Edward L SrN74744Mooney M20B · S/N 1744Cancelled Jul 10, 1970 · Kent David A & Wiles Danny JN1371WMooney M20C · S/N 2652Cancelled Jun 14, 1968 · Norman Myron AN74132Thomson Ersol D TSV-2 · S/N 1Cancelled Aug 16, 1965 · Thomson Ersol DuaneN3062HErcoupe 415-C · S/N 3687Cancelled Sep 15, 1964 · Built 1946 · Viens Joseph PN19676Taylorcraft A · S/N 283Cancelled Jul 28, 1958 · Burkholder HaroldN4941ACessna 180 · S/N 32338Cancelled Feb 18, 1957 · Mabee RoyN30866Piper J3C-65 · S/N 5160Cancelled Oct 7, 1955 · Airborne Agricultural Service CorpN5462Waco GXE · S/N 1490Cancelled Apr 1, 1940 · Built 1928 · Gregg Jack SN793HStearman C3-R · S/N 5035Cancelled Aug 7, 1933 · Riedell Albert C
Back to Anaheim, CA