OpenAirDocs.org
Clearwater, FL

Cancelled registrations · 259

Query with SQL
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 = 'CLEARWATER'
  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.

N914RDDavis R L RV-4 · S/N 291-ACancelled Oct 2, 2025 · Built 1992 · Schlenk Susanne EN976SHRobinson Helicopter R22 BETA · S/N 4064Cancelled Sep 25, 2025 · Exported to Ecuador · Built 2006 · Heli Guide Leasing IncN63SGMikoyan Gurevich MIG 21 · S/N 0241Cancelled Mar 1, 2025 · Sale reported, canceledN501KKCessna 501 · S/N 5010027Cancelled Sep 7, 2024 · Built 1977 · Greased Assets LLCN2826ZPiper PA-22-150 · S/N 22-6821Cancelled Sep 12, 2023 · Revoked, canceled · Built 1959 · Clearwater Flying CompanyN96ASLet BLANIK L-13 · S/N 027020Cancelled Feb 4, 2023 · Registration expired, pending cancellation · Built 1978 · Dinucci GinoN53SDAerospatiale AS350 B2 ECUREUIL · S/N 2446Cancelled Aug 16, 2022 · Exported to Canada · Built 1991 · Pinellas County Sheriffs OfficeN711JABeech F33A · S/N CE-478Cancelled Dec 4, 2021 · Registration expired, pending cancellation · Built 1973 · Logical Choice Aviation N711ja IncN404TBRobinson Helicopter R22 BETA · S/N 3747Cancelled Dec 5, 2020 · Registration expired, pending cancellation · Built 2005 · Clearwater Helicopters IncN3HSStrickman TEENIE II · S/N 510007Cancelled May 15, 2020 · Revoked, canceled · Built 1974 · Strickman Howard TN97552Stinson 108 · S/N 108-552Cancelled Mar 25, 2020 · Revoked, canceled · Built 1946 · Bedford Stanley CN1401JRockwell International 112A · S/N 401Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Built 1975 · Benedict Marc AN408TBeech 95-C55 · S/N TE-193Cancelled Jul 26, 2019 · Registration expired, pending cancellation · Built 1966 · Sun West Aviation IncN6153AKrucker CYGNET · S/N H 20020Cancelled Jan 9, 2019 · Registration expired, pending cancellation · Built 2004 · Morgan Steven RN113SLPiaggio P180 · S/N 1020Cancelled Oct 22, 2018 · Registration expired, pending cancellation · Built 1993 · Clear Aircraft IncN372JTDJI INSPIRE 1 · S/N W13DCA18020790Cancelled Oct 12, 2018 · Registration pending, canceledN80WAPiper PA-34-200 · S/N 34-7250195Cancelled Jul 13, 2018 · Registration expired, pending cancellation · Built 1972 · National Aviation Aircraft Services IncN122PAPiaggio P180 · S/N 1038Cancelled Apr 24, 2018 · Registration expired, pending cancellation · Built 2001 · Midsouth Services IncN1586VCessna 172M · S/N 17263682Cancelled Apr 10, 2018 · Revoked, canceled · Built 1974 · Brown Flying School IncN38TRBeech C90 · S/N LJ-908Cancelled Mar 13, 2018 · Registration expired, pending cancellation · Built 1980 · National Aviation Aircraft Services IncN4789LPiper PA-28-180 · S/N 28-4125Cancelled Mar 13, 2018 · Registration expired, pending cancellation · Marsh AnthonyN70035Robinson Helicopter R22 BETA · S/N 3641Cancelled Jan 24, 2018 · Registration expired, pending cancellation · Built 2004 · T K Rotors IncN4468UCessna 150D · S/N 15060468Cancelled Jan 23, 2018 · Registration expired, pending cancellation · Built 1964 · Campton John RN902CRRushing Glen J MINIMAX · S/N GR002Cancelled Jan 18, 2018 · Registration expired, pending cancellation · Built 2008 · Rushing Glen JN2626NRobinson Helicopter R22 BETA · S/N 3644Cancelled Jan 12, 2018 · Registration expired, pending cancellation · Built 2004 · Fly N ChoppersN5276UCessna 172RG · S/N 172RG0319Cancelled Jan 4, 2018 · Registration expired, pending cancellation · Built 1980 · N5276u Enterprise LLCN1881HPiper PA-28R-201 · S/N 28R-7737015Cancelled Nov 17, 2017 · Built 1977 · Clearwater Helicopters IncN5885WOrdes Wayne QUICKSILVER SPORT 2S · S/N 0254Cancelled Sep 28, 2017 · Registration expired, pending cancellation · Ordes WayneN8349SCessna 182H · S/N 18256449Cancelled Sep 5, 2017 · Exported to Venezuela · Built 1965 · Multicorp LLCN4258XFairchild Hiller FH-1100 · S/N 63Cancelled Jul 20, 2017 · Registration expired, pending cancellation · Richard P Naylor Inc DBAN30USMacmillan Walton R KB-2 · S/N 1923Cancelled Jul 18, 2017 · Registration expired, pending cancellation · Built 1985 · Macmillan Walton RN9626MMooney M20F · S/N 670203Cancelled Jul 14, 2017 · Registration expired, pending cancellation · Built 1966 · Jeremiahs Intl Trading Co IncN319KCessna 172 · S/N 46479Cancelled Jul 7, 2017 · Registration expired, pending cancellation · Built 1959 · Coral Air International IncN158THNaylor Todd D2000 · S/N 0002Cancelled Jun 30, 2017 · Registration expired, pending cancellation · Naylor ToddN993FLLassen Finn VANS RV-3A FINN LASE · S/N 488Cancelled Jun 21, 2017 · Registration expired, pending cancellation · Built 2000 · Lassen FinnN15263Piper PA-28-180 · S/N 28-7305045Cancelled May 31, 2017 · Registration expired, pending cancellation · Built 1972 · Suncoast Aviation IcN3NMBeech 35-C33 · S/N CD-1001Cancelled Apr 18, 2017 · Registration expired, pending cancellation · Built 1965 · Herrlin Ralph CN6622SCessna 150H · S/N 15067422Cancelled Apr 7, 2017 · Registration expired, pending cancellation · Built 1967 · Toth BelaN314PACessna 421C · S/N 421C1042Cancelled Feb 17, 2017 · Registration expired, pending cancellation · Pinnacle Aviation LLCN130SLPiaggio P180 · S/N 1084Cancelled Dec 19, 2016 · Third renewal notice · Built 2004 · Aspen Aviation LLCN134SLPiaggio P180 · S/N 1100Cancelled Dec 19, 2016 · Third renewal notice · Byers BobN162SLPiaggio P180 · S/N 1130Cancelled Dec 19, 2016 · Third renewal notice · Built 2007 · Cca Of Tennessee IncN24949Cessna 152 · S/N 15280466Cancelled Jun 28, 2016 · Exported to Philippines · Built 1977 · Black Thomas DN470MCBeech 35 · S/N D-570Cancelled Dec 5, 2015 · First renewal notice · Built 1947 · Tampa Bay Aircraft Sales IncN8672GCessna 150F · S/N 15062772Cancelled Oct 5, 2015 · First renewal notice · Built 1966 · Beaman Thomas FN40REBeech A36TC · S/N EA-162Cancelled Aug 24, 2015 · Exported to Russia · Built 1980N265CPRockwell International NA-265-65 · S/N 465-48Cancelled Jun 15, 2015 · Third renewal notice · Built 1980 · N265cp IncN9099PPiper PA-24-260 · S/N 24-4575Cancelled May 21, 2015 · Registration expired, pending cancellation · Built 1966 · National Aviation Academy Of Mississippi IncN2038DBeech C35 · S/N D-3390Cancelled May 20, 2015 · Registration expired, pending cancellation · Built 1952 · Mcinnis David CN708RAPiper PA-28-161 · S/N 28-7716045Cancelled May 20, 2015 · Registration pending, canceled · Built 1977
Back to Clearwater, FL