OpenAirDocs.org
California, MD

Cancelled registrations · 28

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 = 'MD' AND d.registrant_city = 'CALIFORNIA'
  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.

N3905WPiper PA-32-260 · S/N 32-851Cancelled Sep 16, 2024 · Revoked, pending cancellation · Built 1966 · Southern Maryland Aviation IncN6242Wood Sidney M JR WOOD KR-2 · S/N 7618Cancelled Apr 26, 2023 · Built 2011 · Wood Sidney M JrN947TSNavmar Applied Sciences TIGERSHARK BLOCK II · S/N 147Cancelled May 8, 2021 · Registration expired, pending cancellation · University Of Maryland Uas Test SiteN314MDUniversity Of Maryland DRAGON PI · S/N UMD-JG314Cancelled Feb 28, 2020 · Registration expired, pending cancellation · University Of MarylandN984MDUav Solutions PHOENIX ACE LE · S/N 102Cancelled Jan 6, 2020 · Registration expired, pending cancellation · University Of Maryland Uas Test SiteN995MDUav Solutions TALON 120LE · S/N 131Cancelled Sep 6, 2019 · Registration expired, pending cancellation · University Of Maryland Uas Test SiteN996MDUav Solutions TALON 120LE · S/N 130Cancelled Sep 6, 2019 · Registration expired, pending cancellation · University Of Maryland Uas Test SiteN284MDDJI PHANTOM 3 ADVANCED · S/N P76DCE15043863Cancelled Mar 16, 2019 · Registration expired, pending cancellation · University Of Maryland Uas Test SiteN290MDDJI PHANTOM 3 ADVANCED · S/N P76DCE26013267Cancelled Mar 9, 2019 · Registration expired, pending cancellation · University Of MarylandN794MDUav Solutions TALON 120LE · S/N 111Cancelled Feb 26, 2019 · Registration expired, pending cancellation · University Of Maryland Uas Test SiteN704TRCessna 150M · S/N 15078865Cancelled Feb 12, 2019 · Registration expired, pending cancellation · Built 1976 · Piedmont Flight Center IncN150MDHorizon Hobby APPRENTICE S15E · S/N AP001Cancelled Feb 9, 2019 · Registration expired, pending cancellation · University Of Maryland Uas Test SiteN795MD3D Robotics IRIS+ · S/N IRS1503400065Cancelled Feb 5, 2019 · Registration expired, pending cancellation · University Of Maryland Uas Test SiteN283MDDJI INSPIRE 1 · S/N W13DCE05031300Cancelled Jan 16, 2019 · Registration expired, pending cancellation · University Of Maryland Uas Test SiteN285MDDJI PHANTOM 3 ADVANCED · S/N P76DCE25013436Cancelled Jan 16, 2019 · Registration expired, pending cancellation · University Of Maryland Uas Test SiteN291MDDJI Innovations P330D · S/N P76DCE26013583Cancelled Jan 16, 2019 · Registration expired, pending cancellation · University Of Maryland Uas Test SiteN121UMUav Solutions TALON 120 · S/N 125Cancelled Jan 15, 2019 · Registration expired, pending cancellation · University Of Maryland Uas Test SiteN190UMUniversity Of Maryland Uas Tes IRIS · S/N 001Cancelled Oct 23, 2018 · Registration expired, pending cancellation · University Of Md Uas Test SiteN120UMUniversity Of Maryland Uas Tes TALON 120 · S/N 124Cancelled Oct 22, 2018 · Registration expired, pending cancellation · University Of Maryland Uas Test SiteN602BDUav Solutions PHOENIX 60 · S/N 136Cancelled May 30, 2018 · Sale reported, canceledN33XStevens Michael Hennis LONG EZ · S/N SA-1Cancelled Apr 24, 2015 · Registration expired, pending cancellation · Built 1988 · Stevens Michael HN27944Piper PA-31-350 · S/N 31-7952056Cancelled Aug 8, 2013 · Registration expired, pending cancellation · Built 1979 · Tigress Air IncN528WGRaytheon 200 · S/N BB-151Cancelled Nov 18, 2010 · Triennial form not returned · Built 1979 · Tigress Air III LLCN21964Cessna 150L · S/N 15074572Cancelled Aug 1, 2003 · Triennial form not returned · Built 1973 · S J B Holdings IncN5538JPiper PA-32-260 · S/N 32-1002Cancelled Mar 22, 2000 · Triennial form not returned · N5538j IncN2957VBeech 35 · S/N D352Cancelled Jun 26, 1992 · Leeland Clinton HN61082Cessna 150J · S/N 15070785Cancelled May 26, 1976 · King Jack WarrenN10GSmith Miniplane HG · S/N G-1234Cancelled Mar 26, 1976 · Berry Clifford D
Back to California, MD