Lake Wales, FL

Cancelled registrations · 52

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 = 'LAKE WALES'
  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.

N299PGWilliam Millette ADVENTURE FUNFLYER 2 · S/N 1111ATTCancelled Oct 30, 2021 · Registration expired, pending cancellation · Millette William SN49TEEvans Thomas L SR GP-4 · S/N 49Cancelled May 8, 2021 · Registration expired, pending cancellation · Built 2001 · Evans Thomas L SrN824KWLeon Wacker SKYMAX · S/N 001Cancelled Apr 5, 2021 · Registration expired, pending cancellation · Built 2017 · Aviator Ppg LLCN609GW3D Robotics SOLO · S/N S111A5500503Cancelled Apr 19, 2019 · Registration expired, pending cancellation · Wine David EN307RPPowrachute PC 2000 · S/N A 307POWCancelled Feb 9, 2019 · Sale reported, canceled · Built 2002N44102Destiny DESTINY XLT · S/N 4C0586Cancelled Mar 14, 2018 · Registration expired, pending cancellation · Built 2006 · Lienhart John WN577CBAmmons C D/Ammons B L WARNER REVOLUTION · S/N WR 299S181Cancelled Feb 16, 2018 · Registration expired, pending cancellation · Ammons Curtis DN747CSHinshaw Carl F GYROCPTER-BENSON B8M · S/N 4Cancelled Jan 29, 2018 · Registration expired, pending cancellation · Hinshaw Carl FN15QBell 206B · S/N 2235Cancelled Dec 13, 2017 · Exported to Guatemala · Helicopter Logistics IncN1308PPiper PA-23 · S/N 23-348Cancelled May 13, 2015 · Registration expired, pending cancellation · Built 1955 · Lake Wales Air Services IncN7051CJones Jay XP 503 · S/N 453Cancelled May 4, 2015 · Registration expired, pending cancellation · Jones Jay HN60MAMaxair DR 532 · S/N 452Cancelled Nov 13, 2014 · Registration expired, pending cancellation · Maxair Aircraft CorpN550HLPiper PA-23 · S/N 23-430Cancelled Oct 27, 2014 · Registration expired, pending cancellation · Built 1956 · Lake Wales Air Services IncN1382LFranklin Dennis F FRANKLIN F · S/N 0002FPCancelled Oct 7, 2014 · Registration expired, pending cancellation · Franklin Dennis WN39842Bellanca 17-30A · S/N 73-30521Cancelled Oct 6, 2014 · Registration expired, pending cancellation · Built 1972 · Lake Wales Air Services IncN341WDouglas DC3C · S/N 13041Cancelled Oct 2, 2014 · Registration expired, pending cancellation · Built 1950 · Lake Wales Air Services IncN134DDouglas DC3 · S/N 11731Cancelled Sep 5, 2014 · Registration expired, pending cancellation · Built 1942 · Southern Flyer IncN3473PPiper PA-23-160 · S/N 23-1447Cancelled Sep 27, 2013 · Registration expired, pending cancellation · Built 1958 · Lake Wales Air Services IncN7761TCessna 172A · S/N 47361Cancelled Aug 28, 2013 · Registration expired, pending cancellation · Built 1960 · Lake Wales Air Services IncN366MXMaxair DR 532 · S/N DR0366Cancelled Jul 30, 2013 · Registration expired, pending cancellation · Maxair Aricraft CorpN65DFFranklin Dennis W DRIFTER XP503 · S/N DR-0365Cancelled Jul 15, 2013 · Registration expired, pending cancellation · Franklin Dennis WN177FAAntonio Flavio J DR-503 · S/N 177Cancelled Jun 13, 2013 · Registration expired, pending cancellation · Built 1985 · Franklin Dennis WN7756ECessna 150 · S/N 17556Cancelled May 9, 2013 · Registration expired, pending cancellation · Built 1959 · Terry Cecil JN7523BChampion 7FC · S/N 7FC-26Cancelled May 8, 2013 · Registration expired, pending cancellation · Built 1957 · Lake Wales Air Services IncN4067BBellanca 17-30A · S/N 76-30811Cancelled Apr 22, 2013 · Registration expired, pending cancellation · Built 1976 · Lake Wales Air Service IncN310KDouglas DC-3A-S1C3G · S/N 4843Cancelled Apr 15, 2013 · Registration expired, pending cancellation · Built 1941 · Southern Flyer IncN45860Douglas DC3C · S/N 12528Cancelled Dec 7, 2012 · Registration expired, pending cancellation · Built 1944 · Southern Flyer IncN1021GDouglas C-47 · S/N 15280Cancelled Oct 11, 2012 · Registration expired, pending cancellation · Lake Wales Air Services IncN3636JCessna 150G · S/N 15064936Cancelled Oct 9, 2012 · Registration expired, pending cancellation · Built 1966 · Lake Wales Air Services IncN3121KCessna 421 · S/N 421-0102Cancelled Sep 12, 2012 · Registration pending, canceled · Built 1968N42187Piper J3C-65 · S/N 14429Cancelled Jun 12, 2012 · Revoked, canceled · Ward Aero Services IncN179DLLockwood Phillip J D-2000 · S/N 179Cancelled Aug 31, 2009 · Second triennial mailing, no response · Lockwood Phillip JN431PLLockwood Phillip DR 277 · S/N 431Cancelled Aug 31, 2009 · Second triennial mailing, no response · Lockwood Phillip JN229JDSukhoi SU-29 · S/N 74-05Cancelled Mar 29, 2005 · Exported to Hungary · Timmer WilliamN823PTCessna 172K · S/N 17258708Cancelled Jun 5, 2000 · Exported to Canada · Thompson Edward RN3275ZPiper PA-22 · S/N 22-7227Cancelled Nov 17, 1999 · Triennial form not returned · Geiger William GN3052PPiper PA-23 · S/N 23964Cancelled Nov 18, 1996 · Triennial form not returned · Geiger William GN84BBBarber William D FALCON XP · S/N FXP111Cancelled Feb 5, 1996 · Triennial form not returned · Barker William DN212SSHudson Jeffrey Alan RANS S-12 · S/N 0192156Cancelled Jul 23, 1994 · Hudson Jeffrey AlanN7065XCessna 150A · S/N 15059165Cancelled Dec 10, 1984 · Lake Wales Air Services IncN7091JBell 47G-5 · S/N 25036Cancelled Oct 16, 1984 · Exported to Mexico · Bogle RandyN7373VBellanca 17-31 · S/N 32-9Cancelled Oct 8, 1982 · Chalet SuzanneN78PDHess-Fleming VARI-EZE · S/N 1610Cancelled Aug 30, 1982 · Hess Darrell EN2317NCessna 140 · S/N 12557Cancelled Jul 10, 1974 · R C HutchinsonN7178XCessna 150 · S/N 15059278Cancelled May 7, 1974 · Built 1961 · Lake Wales Air Services IncN35046Piper J5A · S/N 5-558Cancelled Jun 18, 1970 · World Evangelism IncN4173CStinson 108-3 · S/N 108-5173Cancelled Sep 10, 1963 · Exported to Nicaragua · World Evangelism IncN3292NPiper J3C-65 · S/N 22488Cancelled Mar 23, 1956 · Built 1946 · Ward Aero Services IncN23545Aeronca 65-C · S/N C5029Cancelled Nov 22, 1955 · Built 1939 · Lake Wales Aero Club IncN92572Piper PA-12 · S/N 12-102Cancelled Aug 7, 1952 · Exported to Honduras · Simms V A
Back to Lake Wales, FL