Skip to content

Santa Maria, CA

Cancelled registrations · 125

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

N88990Sherman EAA BIPLANE · S/N AS1Cancelled Feb 16, 2023 · Built 1965 · Bunning Walter B N664NWaco ASO · S/N C-3205Cancelled Jul 30, 2022 · Registration expired, pending cancellation · Bartal Larry J Trustee N10002Texas Helicopter OH-13H/M74A · S/N 79-030Cancelled Jan 30, 2021 · Registration expired, pending cancellation · Built 1979 · English Air Service N1955DBeech C35 · S/N D-3236Cancelled Jan 9, 2021 · Registration expired, pending cancellation · Built 1952 · Popp Robert J N8548FBell 47G-3B-1 · S/N 6507Cancelled Jan 8, 2021 · Registration pending, canceled · Built 1963 N59400Bell 47G-5A · S/N 25138Cancelled Dec 8, 2020 · Registration expired, pending cancellation · Built 1973 · English Air Service Inc N8501XCessna 175C · S/N 17557101Cancelled Jul 19, 2018 · Revoked, canceled · Built 1961 · Sheffield Eugene E N8625CPiper PA-22-135 · S/N 22-1309Cancelled Mar 16, 2018 · Revoked, canceled · Built 1953 · Basye Phillip L N75348Galeana Alfredo TITAN TORNADO · S/N T97503COHK0251Cancelled Jan 26, 2018 · Registration expired, pending cancellation · Built 1998 · Galeana Alfredo N9YBPiper PA-30 · S/N 30-597Cancelled Jan 24, 2018 · Registration expired, pending cancellation · Built 1964 · Poindexter Mark T N231DAMooney M-20G · S/N 680159Cancelled Jul 12, 2017 · Registration expired, pending cancellation · Built 1968 · Anderson Daryl D N9711CDavis Homebuilt Glider CHEROKEE II · S/N 1-1963Cancelled Feb 22, 2017 · Registration expired, pending cancellation · Built 1963 · Lentini Michael N536AMBell 47G · S/N 67-15951Cancelled Feb 1, 2017 · Registration expired · R And S Cropdusters Inc N64832Bell 47G · S/N 994Cancelled Feb 1, 2017 · Third renewal notice · Built 1955 · R And S Cropdusters Inc N725GCBell 47G · S/N 67-15950Cancelled Jan 3, 2017 · Second renewal notice · R And S Cropdusters Inc N5469TPiper PA-28R-200 · S/N 28R-7235233Cancelled May 18, 2016 · Built 1972 · Smith Gary P N27021Bognuda Joseph Wade BOGNUDA SKYBOLT · S/N 001Cancelled May 20, 2015 · Registration expired, pending cancellation · Bognuda Joseph W N238PTreadwell Walter L .55 SCALE P38 · S/N 003Cancelled May 15, 2015 · Registration expired, pending cancellation · Built 1997 · Santa Maria Museum Of Flight N44656Superior CULVER V · S/N V-47Cancelled Apr 30, 2015 · Registration expired, pending cancellation · Built 1946 · Rockwood Richard A N59541Bell 206B · S/N 1412Cancelled Apr 9, 2015 · Second renewal notice · Built 1974 · English Air Service Inc N321EWWilliams Fred H JR MONI · S/N 62Cancelled Dec 22, 2014 · Registration expired, pending cancellation · Built 1989 · Santa Maria Museum Of Flight N9KBBrown Kerry D AIR COMMAND 532 · S/N KB1186AMCancelled Dec 22, 2014 · Registration expired, pending cancellation · Built 1986 · O Roark Roger L N629BJGrimm William H RV-9A · S/N 91051Cancelled Nov 25, 2014 · Registration expired, pending cancellation · Built 2006 · Grimm William H N9754TPiper PA-38-112 · S/N 38-78A0186Cancelled Nov 25, 2014 · Registration expired, pending cancellation · Built 1978 · Wilson Michael Lance N8008HParker Sailplane RP9 · S/N 101Cancelled Nov 19, 2014 · Registration expired, pending cancellation · Built 1962 · Santa Maria Museum Of Flight N5913BCessna 182A · S/N 33913Cancelled Oct 29, 2014 · Registration expired, pending cancellation · Built 1956 · Macdonald Vivian S N343AASikorsky S-76B · S/N 760299Cancelled Apr 17, 2014 · Exported to Canada · Built 1984 · Arctic Air Service Inc N349AAAerospatiale AS 355F1 · S/N 5189Cancelled Mar 24, 2014 · Exported to Australia · Arctic Air Service Inc N833JWCessna T210M · S/N 21062160Cancelled Nov 1, 2013 · Exported to Mexico · N833jw LLC N8856TCessna 182C · S/N 52756Cancelled Oct 24, 2013 · Registration expired, pending cancellation · Built 1960 · D Angelo Dale N491SYExperimental Aircraft Assn 491 KR 2 · S/N 1790Cancelled Sep 20, 2013 · Registration expired, pending cancellation · Santa Maria Museum Of Flight N9280HStinson VULTEE V-77 · S/N 77-104Cancelled Sep 19, 2013 · Registration expired, pending cancellation · Built 1943 · Santa Maria Museum Of Flight Inc N9767NExperimental Aircraft Assn 491 FLYBABY · S/N 87-491Cancelled Sep 17, 2013 · Registration expired, pending cancellation · Built 1988 · Santa Maria Museum Of Flight N25HMMiller Homer RV4 · S/N 1809Cancelled Jun 27, 2013 · Registration expired, pending cancellation · Built 1997 · Dahlin Ryan N3964UNaas Tom ROTEC RALLY 3 · S/N 9385Cancelled Jun 11, 2013 · Registration expired, pending cancellation · Built 1985 · Naas Tom P N333JEIsgrigg John AIRCOMMAND 532 ELITE · S/N JI-1-263Cancelled Jun 5, 2013 · Sale reported, canceled N9789TCessna 172A · S/N 47589Cancelled May 30, 2013 · Registration expired, pending cancellation · Built 1960 · Jarrett Onivea N7629BBrewster FLEET 2 · S/N 157Cancelled May 8, 2013 · Registration expired, pending cancellation · Built 1929 · Santa Maria Museum Of Flight Inc N736HQCessna R172K · S/N R1722543Cancelled May 7, 2013 · Registration expired, pending cancellation · Built 1977 · Fagerlin Mark L N7045Mareik B-8M · S/N 4711Cancelled May 3, 2013 · Registration expired, pending cancellation · Built 1973 · Mareik Lothar N5962JCessna A150L · S/N A1500262Cancelled Apr 25, 2013 · Registration expired, pending cancellation · Built 1971 · Walker Stephen M N5925DPiper PA-22-150 · S/N 22-4587Cancelled Apr 24, 2013 · Registration expired, pending cancellation · Built 1956 · Lentini Michael N24906Cessna 152 · S/N 15280444Cancelled Apr 15, 2013 · Registration expired, pending cancellation · Built 1977 · Crew Raymond L N5677CCessna 140A · S/N 15633Cancelled Nov 13, 2012 · Revoked, canceled · Built 1950 · Barritt Charles R N320SMCessna 320 · S/N 320-0056Cancelled Nov 6, 2012 · Registration expired, pending cancellation · Built 1961 · Mann J Donald Md N32502Piper PA-28-151 · S/N 28-7515172Cancelled Oct 2, 2012 · Registration expired, pending cancellation · Built 1974 · Aviation Unlimited LLC N21771Lockheed 18 · S/N 1930Cancelled Aug 10, 2012 · Sale reported, canceled · Built 1940 N348AASikorsky S-76A · S/N 760043Cancelled Apr 19, 2012 · Exported to Canada · Arctic Air Service Inc N34301Meyers OTW-145 · S/N 45Cancelled Mar 30, 2011 · Exported to United Kingdom · Built 1941 N224SPCessna 172S · S/N 172S8220Cancelled Dec 4, 2009 · Exported to New Zealand · Built 1999 · Aviation Unlimited LLC

Back to Santa Maria, CA