Skip to content

Cancelled registrations · 58

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

N4966UCessna 210E · S/N 21058666Cancelled Feb 5, 2022 · Registration expired, pending cancellation · Built 1965 · Pagh Lonny L N33STYoungs Donald K VARIEZE · S/N 1364Cancelled Oct 2, 2021 · Registration expired, pending cancellation · Built 1979 · Reyes Randolph V N138WEarl Populair 1-A · S/N 103Cancelled Jul 3, 2021 · Registration expired, pending cancellation · Built 1930 · Tomsett Rafe N81115Funk B75L · S/N 245Cancelled Dec 5, 2020 · Registration expired, pending cancellation · Built 1946 · Reyes Randolph V N342KKDJI PHANTOM 3 PROFESSION · S/N P77DCE14010729Cancelled Nov 29, 2019 · Registration expired, pending cancellation · Inskeep Clayton N474CJDJI Innovations S900 · S/N 0370030103Cancelled Nov 29, 2019 · Registration expired, pending cancellation · Inskeep Clayton J N342CKDJI Innovations PHANTOM 3 PROFESSION · S/N P76DCH10017307Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Clayton John Inskeep N13ACCampbell TERN · S/N ABC/WTM-13-70Cancelled May 6, 2019 · Registration expired, pending cancellation · Built 1971 · Brosseau Stephen C N610HSDJI PHANTOM 3 PROFESSION · S/N P76DCF12013805Cancelled Mar 23, 2019 · Registration expired, pending cancellation · Sloop Christina M N335EMMoreno Ernest W SORRELL SNS-2 · S/N 335Cancelled Feb 9, 2019 · Expired dealer · Built 1996 · Papich George J N6368LAmerican AA-1A · S/N AA1A-0368Cancelled Apr 19, 2018 · Registration expired, pending cancellation · Built 1972 · Reyes Randolph V N707STSmith + Toly CHRISTIAN EAGLE II · S/N SMITH/TOLY 0001Cancelled Feb 23, 2018 · North Bay Air Museum N3903DArcher Norman C TITAN TORNADO · S/N T94277SOHK0091Cancelled Jan 18, 2018 · Registration expired, pending cancellation · Archer Norman C N25115Luscombe 8C · S/N 1039Cancelled Jan 12, 2018 · Registration expired, pending cancellation · Built 1939 · Borgnis Tracy C N100VHBeech A36 · S/N E-663Cancelled Aug 8, 2016 · Third renewal notice · Built 1975 · Strehl John DBA N15312Balloon Works FIREFLY 7 · S/N 10164Cancelled Apr 30, 2015 · Registration expired, pending cancellation · Built 1980 · High Adventure Ballooning N2258HBalloon Works FIREFLY 7 · S/N 7767Cancelled Dec 22, 2014 · Registration expired, pending cancellation · Built 1978 · High Adventure Ballooning N7973Lockheed P-38L · S/N 8006Cancelled Dec 18, 2014 · Sale reported, canceled N45041Beech U-8D · S/N 56-3705Cancelled Sep 12, 2013 · Registration expired, pending cancellation · Skyview Investments Inc N95239Taylorcraft BC12-D · S/N 9639Cancelled Aug 22, 2013 · Sale reported, canceled · Built 1946 N7515EChampion 7FC · S/N 7FC-231Cancelled Aug 20, 2013 · Sale reported, canceled · Built 1958 N6284TCessna 150E · S/N 15060984Cancelled Jul 2, 2013 · Registration expired, pending cancellation · Built 1964 · Lange John C N92025Piper J3C-65 · S/N 16458Cancelled Jun 10, 2013 · Sale reported, canceled · Built 1946 N8598VBellanca 7ECA · S/N 1077-75Cancelled May 10, 2013 · Sale reported, canceled · Built 1974 N46180Fairchild M-62A · S/N 230Cancelled May 9, 2013 · Sale reported, canceled · Built 1955 N2718ZSchweizer SGU 2-22E · S/N 187Cancelled Mar 19, 2013 · Sale reported, pending cancellation · Built 1964 N37027Balloon Works FIREFLY 7 · S/N F7-211Cancelled Mar 19, 2013 · Registration expired, pending cancellation · Built 1985 · Marshall Jimmy G N5007CBeech B35 · S/N D-2269Cancelled Mar 19, 2013 · Registration expired, pending cancellation · Built 1950 · Estrella Rafael M N6583XCessna 210A · S/N 21057583Cancelled Feb 13, 2013 · Sale reported, canceled · Built 1960 N6269Milligan SOPWITH SCOUT · S/N 1Cancelled Feb 11, 2013 · Sale reported, canceled · Built 1976 N4433VBeech 35 · S/N D-1237Cancelled Nov 30, 2012 · Registration expired, pending cancellation · Built 1947 · Hockett Roy G N67049Commonwealth 185 · S/N 1773Cancelled Oct 11, 2012 · Sale reported, pending cancellation · Built 1946 N3320YCessna 182E · S/N 18254320Cancelled Sep 10, 2012 · Sale reported, canceled · Built 1962 N1220FCessna 172N · S/N 17272975Cancelled Jun 12, 2012 · Registration expired, pending cancellation · Built 1979 · Castanedo Michelle C N74FTYakovlev YAK-3M · S/N 0470106Cancelled Sep 27, 2011 · Exported to New Zealand · Built 1995 N64058Cessna 172P · S/N 17275513Cancelled May 19, 2010 · Exported to Canada · Built 1981 · Hawkins Curtis D N9601AThomsen-Jes KR-2 · S/N JT-1Cancelled Oct 9, 2009 · Registration revoked · Thomsen Jes G N54TPfeifer-Sopwith PUP · S/N 101Cancelled Jun 29, 2009 · Exported to New Zealand · Built 1961 · Prevost Christopher David N1485Addems-Pfeifer NIEUPORT 11 · S/N 101Cancelled Mar 23, 2007 · Exported to New Zealand · Built 1962 · Prevost Chris N37138Balloon Works FIREFLY 8-24 · S/N F8-067Cancelled May 27, 2003 · Triennial form not returned · High Adventure Ballooning N89300Hunter-Nesmith COUGAR 1 · S/N 1Cancelled Apr 22, 2003 · Triennial form not returned · Built 1969 · Reyes Randolph N5566KRaven Industries RALLY RX7 · S/N RX7-183Cancelled Mar 24, 2003 · Second triennial mailing, no response · Built 1979 · Pagh Lonny N2952JCessna 150G · S/N 15065752Cancelled Mar 10, 2000 · Triennial form not returned · Carmichael John D N6423NCessna 210N · S/N 21062999Cancelled Jul 14, 1997 · Exported to Botswana · Geldard Betty Dawn N3010NCessna 120 · S/N 13268Cancelled Mar 9, 1995 · Triennial form not returned · Bowe Andrew J N16GLEndicott Thomas L KR-2 · S/N 7904Cancelled Oct 12, 1994 · Lewis George W N733PKCessna TU206G · S/N U20604785Cancelled Jul 5, 1994 · Triennial form not returned · Pemberton Jack A DBA N5527ECessna 150 · S/N 17027Cancelled Jun 1, 1994 · Exported to Canada N5358NBoeing E75 · S/N 755656Cancelled Mar 3, 1992 · Exported to France · Sonoma Valley Aircraft Inc N4347FPiper PA-28-151 · S/N 287715023Cancelled Apr 2, 1991 · Triennial form not returned · Melanephy Claire

Back to Sonoma, CA