Skip to content

Winter Haven, FL

Cancelled registrations · 129

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 = 'FL' AND d.registrant_city = 'WINTER HAVEN' 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 = 'FL' AND d.registrant_city = 'WINTER HAVEN'
  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 = 'FL' AND d.registrant_city = 'WINTER HAVEN'
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.

N42822Piper J3C-65 · S/N 15140Cancelled Nov 5, 2022 · Registration expired, pending cancellation · Built 1945 · Browns Seaplane Base Inc N1402CAerofab LAKE LA-4-250 · S/N 15Cancelled Jun 4, 2022 · Registration expired, pending cancellation · Built 1984 · Amphibian Flyers LLC N198PCCashmer Philip M SONEX · S/N 1101Cancelled Apr 9, 2022 · Built 2011 · Cashmer Marian L N911RWBell OH-58A · S/N 72-21147Cancelled Jun 8, 2021 · Second renewal notice · Polk County Sheriffs Office N424WBGrumman American Avn. AA-5B · S/N AA5B0849Cancelled Dec 5, 2020 · Registration expired, pending cancellation · Built 1978 · Korinek Adam W N83832Aeronca 7AC · S/N 7AC2512Cancelled Sep 6, 2019 · Revoked, canceled · Built 1946 · Lichtenwalter E R N8821DPiper PA-22-160 · S/N 22-5990Cancelled Mar 7, 2019 · Registration expired, pending cancellation · Built 1958 · Stemple John T N22748Cessna 150H · S/N 15068492Cancelled Sep 7, 2018 · Exported to Argentina · Built 1968 · Kuell Brian M N91486Ryan NAVION · S/N NAV-4-141Cancelled Apr 4, 2018 · Registration expired, pending cancellation · Built 1946 · Emc Fly Inc N2753BRumbel Richard W KOLB FIRESTAR · S/N FS-152Cancelled Mar 13, 2018 · Registration expired, pending cancellation · Rumbel Richard W N3182PBalloon Works FIREFLY 7-15 · S/N F7-892Cancelled Mar 12, 2018 · Registration expired, pending cancellation · Sonora Services Inc N134GBButterworth Gerald V DERRINGER GB01 · S/N GNB6861998Cancelled Mar 9, 2018 · Registration expired, pending cancellation · Built 2011 · Butterworth Gerald N N3145LPhillips Verle Barbara CASSUTT · S/N 11717Cancelled Mar 5, 2018 · Registration expired, pending cancellation · Helton John H N270JBBrown John H KOLB FIRESTAR II · S/N FS 003 00027Cancelled Mar 1, 2018 · Registration expired, pending cancellation · Brown John H N3640YBalloon Works FIREFLY 7 · S/N F7-183Cancelled Mar 1, 2018 · Registration expired, pending cancellation · Built 1984 · Demartino Gary A N132GBLockheed T-33A · S/N GNB6861998Cancelled Feb 28, 2018 · Registration expired, pending cancellation · Butterworth Gerald N N137JKKatsefaras Joseph G AVENTURA HP · S/N APHP0021Cancelled Feb 28, 2018 · Registration expired, pending cancellation · Built 2005 · Katsefaras Joseph G N25RKSchempp-Hirth K G VENTUS A · S/N 11Cancelled Jan 12, 2018 · Registration expired, pending cancellation · Built 1980 · Ducharme Pierre R N2115WBeech C23 · S/N M-1452Cancelled Oct 28, 2017 · Revoked, pending cancellation · Built 1973 · Hammonds Janet D N6672MUniversal Stinson 108-3 · S/N 108-4672Cancelled Oct 26, 2017 · Registration expired, pending cancellation · Built 1948 · Riddell Joseph W N802RAAerofab LAKE LA-250 · S/N 47Cancelled Oct 26, 2017 · Registration expired, pending cancellation · Aircraft Innovation And Repair Services Inc N229BBurgoon Barry D BB1 · S/N 0192BBCancelled Oct 19, 2017 · Registration expired, pending cancellation · Built 1992 · Burgoon Barry D N911FHBell OH-58A · S/N 72-21909Cancelled Jul 5, 2017 · First renewal notice · Polk County Sheriffs Office N911JPBell OH-58A · S/N 71-20419Cancelled Jul 5, 2017 · First renewal notice · Polk County Sheriffs Office N310SBCessna 310F · S/N 310-0092Cancelled Jul 3, 2017 · Registration expired, pending cancellation · Built 1961 · Brown Mark A N187TBTeratorn TIERRA · S/N 87T107Cancelled Nov 12, 2015 · Third renewal notice · Built 1987 · De Reus Donald A N399JBBrown John WOODSTOCK · S/N W399-JBCancelled Apr 30, 2015 · Registration expired, pending cancellation · Brown John H N5544BCessna 182 · S/N 33544Cancelled Dec 22, 2014 · Registration expired, pending cancellation · Built 1956 · Williams Robert E N80468Cessna 172M · S/N 17266602Cancelled Nov 19, 2014 · Registration expired, pending cancellation · Built 1976 · Mark Bradley Corp N173HHelton John H PITTS S-1 · S/N 1Cancelled Apr 25, 2014 · Built 1986 · Helton John H N49909Cessna 152 · S/N 15281387Cancelled Oct 31, 2013 · Registration expired, pending cancellation · Built 1978 · Brown Jon K DBA N982ACT E A Time AIR COMMAND ELITE · S/N 59-2877496ACCancelled Oct 28, 2013 · Registration expired, pending cancellation · Built 1990 · T E A Time Inc N9CZCampbell James Richard EXPLORER · S/N ZOOM 007Cancelled Sep 26, 2013 · Registration expired, pending cancellation · Campbell James R N95BGBurkhart Grob Flugzeugbau G103 TWIN ASTIR · S/N 3602Cancelled Sep 17, 2013 · Registration expired, pending cancellation · Built 1981 · Freedom Sports Inc N48870Cessna 152 · S/N 15281015Cancelled Sep 16, 2013 · Registration expired, pending cancellation · Built 1977 · Britannia Flight Center Inc N4429Bledsoe Duke DUKE I · S/N 01Cancelled Sep 10, 2013 · Registration expired, pending cancellation · Built 2008 · Bledsoe Duke C N6813SAero Commander 680 · S/N 680-318-13Cancelled Aug 20, 2013 · Registration expired, pending cancellation · Built 1956 · Bolick Edward H N432BBPiper PA-23-160 · S/N 23-1829Cancelled Aug 19, 2013 · Sale reported, canceled · Built 1959 N9159PSampson Donald B BABY ACE MODEL D · S/N S005Cancelled Aug 16, 2013 · Sale reported, canceled N3083EHarrison Elaine A EIPPER QUICKSLVR MXL · S/N 1030Cancelled Jun 27, 2013 · Sale reported, canceled N385LSLet BLANIK L-13 · S/N 175112Cancelled Jun 27, 2013 · Sale reported, canceled · Built 1972 N8603EPiper PA-28-181 · S/N 28-7690179Cancelled Jun 27, 2013 · Registration expired, pending cancellation · Built 1976 · Mcfadden Robert E N4943YBurkhart Grob G 103 TWIN II · S/N 3855-K-101Cancelled Jun 12, 2013 · Registration expired, pending cancellation · Freedom Sports Inc N200PKCessna T210M · S/N 21061999Cancelled May 31, 2013 · Sale reported, pending cancellation N75415Sparks SKYBOLT-1 · S/N JS1Cancelled May 8, 2013 · Registration expired, pending cancellation · Summers Gary W N5668LAmerican AA-1 · S/N AA1-0068Cancelled Apr 22, 2013 · Registration expired, pending cancellation · Built 1969 · Dowdy Roy V N8600APiper PA-23-250 · S/N 27-3898Cancelled Mar 7, 2013 · Sale reported, canceled · Built 1968 N7722JPiper PA-32-260 · S/N 32-1124Cancelled Feb 26, 2013 · Sale reported, canceled · Built 1969 N6283YPiper PA-23-250 · S/N 27-4374Cancelled Feb 25, 2013 · Sale reported, pending cancellation · Built 1969 N563JLCurtis John P SEA REY · S/N 1MK320CCancelled Feb 8, 2013 · Registration expired, pending cancellation · Built 2005 · Curtis John P

Back to Winter Haven, FL