OpenAirDocs.org
Marysville, CA

Cancelled registrations · 69

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

N3570ZPiper PA-22-150 · S/N 22-7486Cancelled Oct 31, 2023 · Revoked, canceled · Built 1960 · Dekellis Thomas EN7521NBeech V35A · S/N D-8844Cancelled Feb 4, 2023 · Registration expired, pending cancellation · Built 1968 · Branscum Chris LN6787KGrumman Acft ENG Cor-Schweizer G-164C · S/N 37 CCancelled Feb 5, 2022 · Registration expired, pending cancellation · Built 1978 · Haughey Burton AN48475Grumman Acft ENG Cor-Schweizer G-164B · S/N 33BCancelled May 8, 2019 · Registration expired, pending cancellation · Yuba River Farms IncN3246ZPiper PA-22-150 · S/N 22-7194Cancelled Apr 5, 2018 · Revoked, canceled · Built 1959 · De Kellis Thomas EN4623YPiper PA-25-235 · S/N 25-4336Cancelled Nov 13, 2017 · Exported to Mexico · Yuba River Farms IncN205KMBell UH-1H · S/N 66-16122Cancelled Jul 14, 2017 · Registration expired, pending cancellation · Rice Aircraft Services IncN8178WRobinson Robert G FISHER HORIZON 1 · S/N H098Cancelled Feb 28, 2017 · Registration expired, pending cancellation · Built 1994 · Jennings Carlton EN9332FHughes 269B · S/N 0039Cancelled Feb 17, 2017 · Registration expired, pending cancellation · Built 1964 · Rick Patterson IncN83132Aeronca 7AC · S/N 7AC1793Cancelled Feb 4, 2017 · Revoked, canceled · Built 1946 · Paul EarlN9187EAeronca 11AC · S/N 11AC821Cancelled Sep 3, 2014 · Registration expired, pending cancellation · Built 1955 · Watt James R DBAN4481NSaldivar Frank Ralph KR-2 · S/N 3781Cancelled Nov 7, 2013 · Registration expired, pending cancellation · Built 1982 · Richmond David FN1051Baird HP-14 · S/N 17JBCancelled Aug 21, 2013 · Sale reported, canceled · Built 1967N13CNCessna 140 · S/N 11877Cancelled Aug 6, 2013 · Sale reported, canceled · Built 1947N9801LRaven Industries RX6 · S/N RX6-147Cancelled Jul 1, 2013 · Registration expired, pending cancellation · Built 1975 · Gajda Esther SueN4906VConsolidated Vultee L-13B · S/N 47-397Cancelled Jun 18, 2013 · Registration expired, pending cancellation · Built 1947 · Marquis BudN169KMBell UH-1H · S/N 66-01169Cancelled May 13, 2013 · Registration expired, pending cancellation · Rice Aircraft Services IncN68849Consolidated Vultee L-13 · S/N 46-155Cancelled May 2, 2013 · Registration expired, pending cancellation · Marquis L C BudN6250ACessna 182 · S/N 33050Cancelled Apr 29, 2013 · Registration expired, pending cancellation · Built 1956 · Lane Glenn HN9253BCessna 175 · S/N 55053Cancelled Mar 18, 2013 · Sale reported, canceled · Built 1958N3270EAeronca 11AC · S/N 11AC-1645Cancelled Nov 6, 2012 · Registration expired, pending cancellation · Built 1947 · Hathaway Harold RN7010ACessna 172 · S/N 29110Cancelled Oct 26, 2012 · Exported to New Zealand · Built 1956 · Krueger Eric JN74489Bellanca 14-13-3 · S/N 1602Cancelled Oct 19, 2012 · Sale reported, pending cancellation · Built 1948N79235Cessna T-50 · S/N 1454Cancelled Sep 10, 2012 · Revoked, canceled · Built 1941 · Perkins Avia IndustriesN58520Cessna T-50 · S/N 4508Cancelled Aug 30, 2012 · Revoked, canceled · Built 1943 · Perkins Aviation IndustriesN45099Naval Aircraft Factory N3N-3 · S/N 1978Cancelled Jul 19, 2012 · Revoked, canceled · Built 1940 · Marquis L CN728XGrumman G-164 · S/N 282Cancelled Jul 9, 2012 · Registration pending, canceled · Built 1964N111WPBeech 65 · S/N LC-132Cancelled May 24, 2012 · Registration expired, pending cancellation · Built 1961 · Rose Thomas JN40208Ayres S2R-T34 · S/N T34-023Cancelled Apr 19, 2010 · Triennial form not returned · Built 1980 · G N Dibble IncN724WCCessna TU206G · S/N U20606597Cancelled May 25, 2005 · Exported to Mexico · Built 1982 · Chase & Philpott Inc DBAN6557KAerostar International RX-7 · S/N RX7-3103Cancelled Oct 26, 2000 · Triennial form not returned · Mozingo Esther SueN7915UCessna 172F · S/N 17251915Cancelled Aug 27, 1996 · Triennial form not returned · Watkins Steven JN54RKKutschbach Robert COZY · S/N 54Cancelled Apr 28, 1992 · Triennial form not returned · Kutschbach Robert L DdsN7910JBell 206B · S/N 675Cancelled Feb 5, 1991 · Triennial form not returned · Hofman RanchN4017DAyres S2R-T34 · S/N T34-001Cancelled May 25, 1983 · Built 1979 · G N Dibble IncN2318DCessna 170B · S/N 20470Cancelled Aug 30, 1982 · Grant Gary BN28524Dekellis HOMEBUILT MODEL 2 · S/N 2Cancelled Dec 28, 1976 · Dekellis Thomas EN66760Boeing A75N1 · S/N 75-3090Cancelled Jun 24, 1976 · Marquis BudN570BBeech A35 · S/N D-1590Cancelled Jun 3, 1975 · Mcclure William JN4734APiper PA-18A 150 · S/N 184959Cancelled Jul 24, 1974 · Moe'S Crop Dusting ServiceN706YGrumman G-164 · S/N 316Cancelled Jun 25, 1973 · Moes Crop Dusting ServiceN16059Cessna 150L · S/N 15073449Cancelled Jun 5, 1973 · Built 1972 · Comet Airways IncN56290Consolidated Vultee BT-13A · S/N 6433Cancelled Dec 6, 1971 · J C Wood CompanyN7122ZPiper PA-25-235 · S/N 25-2924Cancelled Nov 29, 1971 · Harrison ThomasN37255Interstate S-1A · S/N 98Cancelled Sep 23, 1970 · Harold HarmonN48718Aeronca 0-58B · S/N 058B 4862Cancelled Aug 17, 1970 · Lawrence R WyckoffN8282UCessna 172F · S/N 17252182Cancelled Dec 14, 1965 · Comet Airways IncN75195Consolidated Vultee BT-15 · S/N 8331Cancelled May 26, 1965 · Marquis L CN66743Convair BT-13B · S/N 9-1423Cancelled May 21, 1965 · Marquis BudN68801Cessna T-50 · S/N 4200Cancelled May 21, 1965 · Marquis L C
Back to Marysville, CA