OpenAirDocs.org
San Francisco, CA

Cancelled registrations · 941

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 FRANCISCO'
  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.

N696WGFilby Gerry RV-9 · S/N 90842Cancelled Feb 28, 2026 · Built 2006 · Filby GerryN311AGBoeing 727-17 · S/N 20512Cancelled Oct 27, 2025 · Built 1971 · Getty Gordon PN43854Taylorcraft BF · S/N 7513Cancelled Feb 10, 2024 · Revoked, canceled · Built 1946 · Tachikawa Air Base Aero ClubN512NGPilatus PC-12/45 · S/N 512Cancelled Jan 19, 2024 · Exported to Poland · Built 2003 · Boutique Air IncN554WNBoeing 737-7BX · S/N 30746Cancelled May 18, 2023 · Built 2002 · Alc B377 30746 LLCN725SHBoeing 767-3Q8 · S/N 27993Cancelled Mar 4, 2023 · Registration expired, pending cancellation · Pacific Aircorp 27993 IncN638SHMcdonnell Douglas DC-9-83(MD-83) · S/N 49845Cancelled Feb 1, 2023 · Registration expired, pending cancellation · Pegasus Aviation II LLCN639SHMcdonnell Douglas DC-9-87 · S/N 49780Cancelled Feb 1, 2023 · Registration expired, pending cancellation · Pacific Aircorp 49780 IncN723SHMcdonnell Douglas DC-9-83(MD-83) · S/N 49741Cancelled Feb 1, 2023 · Registration expired, pending cancellation · Pacific Aircorp 49741 IncN724SHMcdonnell Douglas DC-9-83(MD-83) · S/N 49904Cancelled Feb 1, 2023 · Registration expired, pending cancellation · Pacific Aircorp 49904 IncN60BGBurkhart Grob Flugzeugbau G109 · S/N 6066Cancelled Jan 5, 2023 · Sale reported, canceled · Built 1981N28589Grumman American Avn. AA-5B · S/N AA5B0694Cancelled Oct 1, 2022 · Registration expired, pending cancellation · Built 1978 · Oaten Stewart RexN7943CPiper PA-28-151 · S/N 28-7615068Cancelled Oct 1, 2022 · Registration expired, pending cancellation · Built 1975 · Munka Aviation LLCN608VNVolans-I C20 · S/N 86592200008Cancelled Jun 14, 2022 · Registration expired, pending cancellation · Volans I IncN610VNVolans-I C20 · S/N 86592200010Cancelled Jun 14, 2022 · Registration expired, pending cancellation · Volans-I IncN611VNVolans-I C20 · S/N 86592200011Cancelled Jun 14, 2022 · Registration expired, pending cancellation · Volans-1 IncN612VNVolans-I C20 · S/N 86592200012Cancelled Jun 14, 2022 · Registration expired, pending cancellation · Volans-I IncN614VNVolans-I C20 · S/N 86592200014Cancelled Jun 14, 2022 · Registration expired, pending cancellation · Volans-I IncN23560Hiller OH-23B · S/N 51-16261Cancelled Jun 4, 2022 · Registration expired, pending cancellation · Built 1976 · San Francisco Community College DistrictN23561Hiller OH-23B · S/N 51-16339Cancelled Jun 4, 2022 · Registration expired, pending cancellation · Built 1976 · San Francisco Community College DistrictN949PGBoeing 737-236 · S/N 23159Cancelled Mar 9, 2022 · Pacific Aircorp 23159 IncN544XCDJI PHANTOM 2 · S/N PH646025742Cancelled Dec 16, 2021 · Non-citizen corporation, flight hours not reported · Climate CorpN577QCDJI PHANTOM 2 · S/N PH645343579Cancelled Dec 16, 2021 · Non-citizen corporation, flight hours not reported · Climate CorpN11817Douglas DC-6A · S/N 44653Cancelled Oct 5, 2021 · Revoked, canceled · Built 1953 · Slick AirwaysN635SHBoeing 757-236 · S/N 24370Cancelled Sep 22, 2021 · Registration expired, pending cancellation · Pegasus Aviation IV IncN960PGBoeing 767-3P6 · S/N 24349Cancelled Sep 22, 2021 · Registration expired, pending cancellation · Pegasus Aviation II LLCN11BVDassault FALCON 2000 · S/N 21Cancelled Sep 9, 2021 · Exported to Canada · Built 1995 · Strategic Project Solutions IncN600VNVolans-I C20 · S/N 86592200000Cancelled Sep 4, 2021 · Registration expired, pending cancellation · Volans-I IncN601VNVolans-I C20 · S/N 86592200001Cancelled Sep 4, 2021 · Registration expired, pending cancellation · Volans-I IncN602VNVolans-I C20 · S/N 86592200002Cancelled Sep 4, 2021 · Registration expired, pending cancellation · Volans-I IncN603VNVolans-I C20 · S/N 86592200003Cancelled Sep 4, 2021 · Registration expired, pending cancellation · Volans-I IncN604VNVolans-I C20 · S/N 86592200004Cancelled Sep 4, 2021 · Registration expired, pending cancellation · Voland-I IncN605VNVolans-I C20 · S/N 86592200005Cancelled Sep 4, 2021 · Registration expired, pending cancellation · Volans-I IncN606VNVolans-I C20 · S/N 86592200006Cancelled Sep 4, 2021 · Registration expired, pending cancellation · Volans-I IncN607VNVolans-I C20 · S/N 86592200007Cancelled Sep 4, 2021 · Registration expired, pending cancellation · Volans-I IncN609VNVolans-I C20 · S/N 86592200009Cancelled Sep 4, 2021 · Registration expired, pending cancellation · Volans 1 IncN622WGRobinson Helicopter R44 II · S/N 10402Cancelled Sep 4, 2021 · Registration expired, pending cancellation · Built 2004 · Skyryse IncN401VNLatitude Engineering HQ-40D · S/N 015Cancelled Jul 31, 2021 · Registration expired, pending cancellation · Volans-I IncN544WCDJI PHANTOM 2 · S/N PH646025729Cancelled Jul 31, 2021 · Registration expired, pending cancellation · Climate CorpN544YCDJI PHANTOM 2 · S/N PH646025788Cancelled Jul 31, 2021 · Registration expired, pending cancellation · Climate CorpN545ECDJI PHANTOM 2 · S/N PH646015600Cancelled Jul 31, 2021 · Registration expired, pending cancellation · Climate CorpN547QCDJI PHANTOM 2 · S/N PH645230035Cancelled Jul 31, 2021 · Registration expired, pending cancellation · Climate CorpN67782Fairchild M-62A · S/N T424182Cancelled Jul 19, 2021 · Revoked, canceled · Built 1942 · Black W WN633SHBoeing 757-200 SERIES · S/N 24714Cancelled Jul 3, 2021 · Registration expired, pending cancellation · Pegasus Aviation IV IncN514CACobalt Aircraft Industries CO50 VALKYRIE · S/N PX02Cancelled Apr 13, 2021 · Non-citizen corporation, flight hours not reported · Built 2014 · Cobalt Aircraft Industries IncN577GBBashforth Glenn E GB'S SOLUTION · S/N 001Cancelled Jan 30, 2021 · Registration expired, pending cancellation · Built 2012 · Melero Ivan VN505ZZAir Creation CLIPPER 912 · S/N 00097Cancelled Jan 15, 2021 · Exported to Argentina · Built 2000 · Paul CarolineN480SRSkyryse PEGASUS · S/N SRP0002Cancelled Dec 8, 2020 · Registration expired, pending cancellation · Skyryse IncN528VNLatitude Engineering HQ-40 · S/N 0000Cancelled Oct 31, 2020 · Registration expired, pending cancellation · Volans-I IncN9665RCessna TU206G · S/N U20606926Cancelled Aug 7, 2020 · Exported to Mexico · Airdine LLC
Back to San Francisco, CA