Skip to content

Punta Gorda, FL

Cancelled registrations · 89

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 = 'PUNTA GORDA' 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 = 'PUNTA GORDA'
  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 = 'PUNTA GORDA'
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.

N691RSBeech 60 · S/N P-81Cancelled Oct 2, 2025 · Exported to Brazil · Built 1969 · Florida Manufacturing Consulting Co LLC N820LLearjet 23 · S/N 23-020Cancelled Jul 6, 2024 · Sale reported, canceled · Built 1965 N302JCCessna 208 · S/N 20800535Cancelled Jun 4, 2024 · Exported to Canada · Jc Aviation Services Florida LLC N54ARRomanazzi Anthony L BUCCANEER SX B1B 503 · S/N BIB-516-503Cancelled Nov 5, 2022 · Registration expired, pending cancellation · Built 1989 · Sterling Robert C N5543YPiper PA-23-250 · S/N 27-2643Cancelled Apr 2, 2022 · Registration expired, pending cancellation · Built 1964 · Aeronautical Services Inc N2686HErcoupe 415-C · S/N 3311Cancelled Jul 10, 2020 · Registration expired, pending cancellation · Built 1946 · Bailey Frederick T N944JUDJI MAVIC PRO PLATINUM · S/N 08QCE BGP02AHG3Cancelled Sep 13, 2019 · Sale reported, canceled N55KVYakovlev YAK-55 · S/N 930907Cancelled Jul 12, 2019 · Exported to Australia · Built 1993 · Caldwell Daniel E N3923MPiper PA-12 · S/N 12-2819Cancelled Jan 15, 2019 · Revoked, canceled · Built 1947 · Jack John R Jr N51NKPitts Special SC1 · S/N 105-MCancelled Sep 13, 2018 · Registration expired, pending cancellation · Built 1970 · Howe Eric D N27265Besarick SKYBOLT · S/N WHB-2Cancelled Aug 23, 2018 · First renewal notice · Built 1981 · Lewis Gerald C N102PParrish Don B8M · S/N DMP-1Cancelled Jun 18, 2018 · Third renewal notice · Parrish Don M N354TWPiper PA-23-250 · S/N 27-2882Cancelled Jun 8, 2018 · Registration expired, pending cancellation · Built 1965 · Piana Joseph M N5079QMini Max 1100 · S/N 98 KEN 85Cancelled May 30, 2018 · Sale reported, canceled · Built 1999 N109CSBell OH-58C · S/N 72-21282Cancelled Mar 19, 2018 · Registration expired, pending cancellation · Charlotte County Sheriffs Office N524VT781569 FX 210 · S/N FW06060021Cancelled Mar 13, 2018 · Registration expired, pending cancellation · Built 2006 · 781569 Inc N4420XRife Ronald S KOLB FIRESTAR · S/N FS2530Cancelled Feb 28, 2018 · Registration expired, pending cancellation · Built 1989 · Rife Ronald S N2626CMakela Urho J RV-4 · S/N 1775Cancelled Jan 11, 2018 · Third renewal notice · Loy Jesse J N72AHAeropro CZ S R O A240 · S/N 32511Cancelled Oct 26, 2017 · Registration expired, pending cancellation · Built 2011 · Hayden Andrew C N42001Piacibello Franco KITFOX 4-1200 · S/N LCU135Cancelled Jun 21, 2017 · Registration expired, pending cancellation · Stinnett Michael H N69MSStinnett Michael H PITBULL · S/N MHS001Cancelled Mar 21, 2017 · Registration expired, pending cancellation · Stinnett Michael H N191ABeech C90 · S/N LJ-765Cancelled Feb 22, 2017 · Registration expired, pending cancellation · Built 1978 · Punta Gorda Transport LLC N4550JDouglas DC3C-S4C4G · S/N 6055Cancelled Sep 20, 2016 · Exported to Russia N207CSBell OH-58A · S/N 71-20599Cancelled Oct 28, 2015 · Third renewal notice · Charlotte County Sheriff'S Office N1281XMooney M20E · S/N 154Cancelled May 18, 2015 · Registration expired, pending cancellation · Florida Aircraft Sales & Rental N135MPMooney M20L · S/N 260015Cancelled May 8, 2015 · Registration expired, pending cancellation · Florida Aircraft Sales & Rental Inc N74860Grumman American Avn. AA-5B · S/N AA5B0381Cancelled Nov 18, 2014 · Registration expired, pending cancellation · Built 1976 · Florida Aircraft Sales & Rental N106CSBell OH-58C · S/N 70-15162Cancelled Sep 16, 2014 · First renewal notice · Charlotte County Sheriffs Office N555MXSport Copter VORTEX · S/N 0160Cancelled Sep 19, 2013 · Second renewal notice · Miller John N766EACessna 402B · S/N 402B0401Cancelled Sep 13, 2013 · Registration expired, pending cancellation · Built 1973 · Cal Aero Jet Center LLC N17DTTurner Dale E ACEY DEUCY P-70 · S/N 411Cancelled Sep 12, 2013 · Built 1985 · Turner Dale E N4SMPiper PA-23-160 · S/N 23-1263Cancelled Aug 15, 2013 · Registration expired, pending cancellation · Gignac Edward C N4207RBell UH-1H · S/N 66-16045Cancelled Jul 25, 2013 · Sale reported, canceled N79364Mooney M20E · S/N 574Cancelled Jul 23, 2013 · Registration expired, pending cancellation · Built 1965 · Mod Works Inc N9162STsgs International TSGS-1 · S/N 101Cancelled Jun 7, 2013 · Registration expired, pending cancellation · Tsgs International Inc N8MDDauer TEENIE TWO · S/N 5-10438Cancelled May 13, 2013 · Registration expired, pending cancellation · Built 1974 · Hill Douglas E N4211ZBell UH-1H · S/N 67-17805Cancelled May 10, 2013 · Sale reported, canceled N5864QMooney M20C · S/N 3140Cancelled Apr 23, 2013 · Registration expired, pending cancellation · Built 1965 · Scheu Charles R N8681NPiper PA-32-300 · S/N 32-7240027Cancelled Mar 7, 2013 · Sale reported, canceled · Built 1971 N3160HEngineering & Research 415-C · S/N 3785Cancelled Mar 4, 2013 · Second renewal notice · Built 1946 · Griffin Robert C N69EROsborne John R CHALLENGER II · S/N CH2-0291-CW0649Cancelled Jan 30, 2013 · Registration expired, pending cancellation · Built 1991 · Goss John H N1435JRockwell International 112A · S/N 435Cancelled Oct 11, 2012 · Registration expired, pending cancellation · Built 1976 · Koedding Glen F N69786Cessna 310Q · S/N 310Q0978Cancelled Sep 20, 2012 · Revoked, canceled · Built 1973 · Air Southwest Florida Corp N136APApollo MONSOON · S/N 00007Cancelled Aug 7, 2012 · Registration pending, canceled · Built 2008 N7068XSchultz Brad TEENIE TWO · S/N 15-2089Cancelled Apr 13, 2012 · Registration expired · Mastro William A N969GRans S12 · S/N 1094526Cancelled Aug 17, 2011 · Exported to Belize · Built 2008 · Miley Russ N41765Piper PA-28-151 · S/N 28-7415327Cancelled Aug 1, 2011 · Expired dealer · Built 1974 · Universel Technologies/Unitec Inc N221ESMooney M20F · S/N 670435Cancelled Jan 3, 2011 · Expired dealer · Built 1967 · Mod Works Inc N129PADiamond Aircraft Ind DA20-C1 · S/N C0346Cancelled May 13, 2010 · Exported to Germany · Built 2005 · Mark Purkey LLC N371CSBeech 58P · S/N TJ-371Cancelled Jun 29, 2009 · Triennial form not returned · Built 1981 · Charlotte County Sheriffs Office

Back to Punta Gorda, FL