Skip to content

Santa Monica, CA

Cancelled registrations · 348

Query with SQL

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 = 'SANTA MONICA' ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

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 = 'SANTA MONICA'
  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.

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 = 'SANTA MONICA'
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N965BCGulfstream AM Corp Comm Div 695A · S/N 96071Cancelled Mar 24, 2025 · Registration pending, pending cancellation · Built 1984 N1315WMooney M20E · S/N 203Cancelled Apr 12, 2024 · Built 1963 · Bergland John E N643JKCzech Sport PIPER SPORT · S/N P1001019Cancelled Feb 24, 2023 · Santa Monica Flyers Inc N992AAAstraeus Aerial V.3CS · S/N 0006Cancelled Feb 4, 2023 · Registration expired, pending cancellation · Astraeus Aerial LLC N993AAAstraeus Aerial V.3CS · S/N 0007Cancelled Feb 4, 2023 · Registration expired, pending cancellation · Astraeus Aerial LLC N994AAAstraeus Aerial V.3CS · S/N 0008Cancelled Feb 4, 2023 · Registration expired, pending cancellation · Astraeus Aerial LLC N995AAAstraeus Aerial V.3CS · S/N 0009Cancelled Feb 4, 2023 · Registration expired, pending cancellation · Astraeus Aerial LLC N451DNHorizon Hobby CHROMA CAMERA DRONE · S/N 6751ACancelled Jul 14, 2022 · Due North Productions N223YDouglas DC-1 · S/N 1137Cancelled Apr 28, 2022 · Douglas Aircraft Co Inc N454DNMark Smith SPREADING WINGS 900 · S/N 0900ACancelled Feb 5, 2022 · Registration expired, pending cancellation · Due North Productions N556GCDJI FLAMEWHEEL F450 · S/N 0001ACancelled Oct 2, 2021 · Registration expired, pending cancellation · Due North Productions N37CNavion NAVION B · S/N NAV-4-2184-BCancelled Jun 10, 2021 · Built 1950 · Yoloa Corp N3636NPiper J3C-65 · S/N 22893Cancelled Nov 14, 2019 · Revoked, pending cancellation · Built 1947 · Miller Verret Aviation N644YJDJI INSPIRE 1 · S/N W13DCC28030106Cancelled May 6, 2019 · Registration expired, pending cancellation · Jelkin Jonathan J N3982TPiper PA-28R-180 · S/N 28R-30333Cancelled Mar 20, 2019 · Sale reported, canceled · Built 1967 N410ARDJI INSPIRE 1 · S/N W130CA29020491Cancelled Mar 9, 2019 · Registration expired, pending cancellation · American Rogue N375ARDJI S900 · S/N 0380050451Cancelled Jan 15, 2019 · Registration expired, pending cancellation · American Rogue N27547Taylorcraft BF · S/N 2189Cancelled Jan 14, 2019 · Revoked, canceled · Built 1940 · Palit Dawn T N5792XDJI Innovations DJI PHANTOM 2 P330Z · S/N PH645332174 V1.0Cancelled Jan 8, 2019 · Registration expired, pending cancellation · Hoovy LLC N739TDCessna 172N · S/N 17270785Cancelled Dec 31, 2018 · Exported to Mexico · Built 1978 · Santa Monica Aviation Inc N395ARDJI S1000+ · S/N 03P0010680Cancelled Dec 4, 2018 · Registration expired, pending cancellation · American Rogue N325ARDJI INSPIRE 1 · S/N W13DCC23020386Cancelled Dec 1, 2018 · Registration expired, pending cancellation · American Rogue N335ARDJI PHANTOM 2 · S/N PH645137038Cancelled Dec 1, 2018 · Registration expired, pending cancellation · American Rogue N789SBIsrael Aircraft Industries GULFSTREAM 200 · S/N 146Cancelled Nov 5, 2018 · Exported to Mexico · Built 2006 · Heir Bunky Inc N5361EBeech K35 · S/N D-5859Cancelled Sep 13, 2018 · Revoked, canceled · Built 1959 · Peterson Allan L N8641KStinson 108-1 · S/N 108-1641Cancelled Jun 26, 2018 · Registration pending, canceled N91737North American NAVION · S/N NAV4-189Cancelled Jun 1, 2018 · Sale reported, canceled · Built 1947 N80783Robinson Helicopter R22 BETA · S/N 1319Cancelled May 31, 2018 · Sale reported, canceled · Built 1990 N10ACBeech B200 · S/N BB-858Cancelled May 30, 2018 · Sale reported, canceled · Built 1981 N93329Engineering & Research 415-C · S/N 652Cancelled Apr 6, 2018 · Revoked, canceled · Built 1946 · Slauson James L N139SPiper PA-28-140 · S/N 28-20999Cancelled Mar 23, 2018 · Revoked, canceled · Built 1965 · Santa Monica Flyers N360MGBerkut Engineering And Design MOBIUS · S/N 001Cancelled Mar 22, 2018 · Exported to Paraguay · Berkut Engineering And Design Inc N3887ASchweizer SGS 1-26 · S/N 54Cancelled Mar 16, 2018 · Revoked, canceled · Built 1957 · Mahon James H N8290Mini-Hawk International TIGER-HAWK I · S/N MH-002Cancelled Mar 16, 2018 · Revoked, canceled · Mini Hawk International Inc N64030Cessna 172M · S/N 17264976Cancelled Feb 20, 2018 · Registration expired, pending cancellation · Built 1975 · Berlin Edward N69600Fairchild PT-23-AE · S/N 3863Cancelled Feb 12, 2018 · Registration expired, pending cancellation · Rudy & Sylvia Airways LLC N427LADehavilland DH104 DOVE 6BA · S/N 04353Cancelled Nov 18, 2017 · Revoked, canceled · Built 1952 · Los Angeles Air Taxi Service Inc N2321EAeronca 7AC · S/N 7AC5898Cancelled Oct 28, 2017 · Revoked, canceled · Built 1946 · Pattison Leonore O N41KACessna P210N · S/N P21000045Cancelled Oct 6, 2017 · Registration expired, pending cancellation · Built 1978 · Mcmillan M Sean N8258SPiper PA-28-161 · S/N 28-8116024Cancelled Jul 18, 2017 · First renewal notice · Built 1980 · Skyward Aviation Inc N454SAIniziative Industriali Italian SKY ARROW 600 SPORT · S/N LSA012Cancelled Jul 14, 2017 · Registration expired, pending cancellation · Built 2007 · Northfield Aviation LLC N65135Grumman/Liberty F8F-1 · S/N 001Cancelled Jul 12, 2017 · Registration expired, pending cancellation · Liberty Aero Corp N14278Lockheed 382C · S/N 382-4278Cancelled May 23, 2017 · Registration expired, pending cancellation · Airplane Sales International Corporation N34277Lockheed 382C · S/N 382-4277Cancelled May 23, 2017 · Registration expired, pending cancellation · Airplane Sales International Corporation N3743CRepublic RC-3 · S/N 272Cancelled May 15, 2017 · Registration expired, pending cancellation · Mauk J Don N3957Waco GXE · S/N 1239Cancelled Mar 24, 2017 · Registration expired, pending cancellation · Built 1927 · Museum Of Flying Support Fund N6233PPiper PA-24-250 · S/N 24-1337Cancelled Feb 4, 2017 · Revoked, canceled · Built 1959 · Pacific Piper Sales Inc N7173LGrumman American Avn. AA-1B · S/N AA1B-0453Cancelled Feb 4, 2017 · Revoked, canceled · Built 1974 · Clark Richard L N79560Cessna 172K · S/N 17258175Cancelled Feb 4, 2017 · Revoked, canceled · Built 1969 · California Airplane Leasing Inc N8545PPiper PA-24-260 · S/N 24-4002Cancelled Feb 4, 2017 · Revoked, canceled · Built 1964 · Clark Richard L

Back to Santa Monica, CA