OpenAirDocs.org
Sanford, FL

Cancelled registrations · 145

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

N148VPPiper PA-23-250 · S/N 27-3167Cancelled Dec 28, 2024 · Sale reported, canceled · Built 1966N484DACirrus Design SR20 · S/N 1829Cancelled Dec 31, 2022 · Registration expired, pending cancellation · Built 2007 · Aerosim Academy IncN52566Cessna 172P · S/N 17274556Cancelled Dec 31, 2022 · Registration expired, pending cancellation · Built 1980 · Aerosim Academy IncN2503SCessna 337C · S/N 337-0803Cancelled Nov 6, 2021 · Sale reported, canceled · Built 1967N3755NBeech 35 · S/N D-975Cancelled Nov 6, 2021 · Sale reported, canceled · Built 1947N321FGPiper PA-32-260 · S/N 32-1Cancelled Jul 24, 2021 · Sale reported, canceledN167CAPiper PA-44-180 · S/N 4496129Cancelled Oct 31, 2020 · Registration expired, pending cancellation · Built 2002 · Aerosim Academy IncN178CAPiper PA-44-180 · S/N 4496111Cancelled Oct 31, 2020 · Registration expired, pending cancellation · Built 2002 · Aerosim Academy IncN166CAPiper PA-44-180 · S/N 4496124Cancelled Jul 10, 2020 · Registration expired, pending cancellation · Built 2002 · Aerosim Academy IncN2180BPiper PA-44-180 · S/N 44-7995101Cancelled Jul 10, 2020 · Registration expired, pending cancellation · Built 1978 · Aerosim Academy IncN2219FPiper PA-44-180 · S/N 44-7995159Cancelled Jul 10, 2020 · Registration expired, pending cancellation · Built 1978 · Aerosim Academy IncN163CAPiper PA-44-180 · S/N 4496117Cancelled May 1, 2020 · Registration expired, pending cancellation · Built 2002 · Aerosim Academy IncN666UCDJI SPREADING WINGS S900 · S/N 0370063423Cancelled Jan 6, 2020 · Registration expired, pending cancellation · Rkc Media Solutions LLCN429TSDiamond Aircraft Ind DA 42 · S/N 42.AC019Cancelled Aug 7, 2019 · Exported to Portugal · Built 2006 · L3 Commercial Training Solutions Airline AcademyN133GSGrabiec/Depalma/Hanning GLASTAR · S/N 5172Cancelled May 4, 2019 · Registration expired, pending cancellation · Built 2002 · Active Pro Aero LLCN81EFPiper PA-44-180 · S/N 44-7995127Cancelled Feb 27, 2019 · Registration expired, pending cancellation · Built 1978 · Aerosim Academy IncN9955YChampion 402 · S/N 402-11Cancelled Feb 2, 2019 · Registration expired, pending cancellation · Built 1963 · Orlando Sanford Aircraft Services IncN89989Cessna 172P · S/N 17276019Cancelled Sep 14, 2018 · Registration expired, pending cancellation · Built 1983 · Aerosim Academy IncN355HVertical Avia Technologies HUMMINGBIRD · S/N RSA 01Cancelled Jul 17, 2018 · Exported to Canada · Built 2008 · Vertical Aviation Technologies IncN3986MPiper PA-28R-201 · S/N 28R-7837150Cancelled Jun 8, 2018 · Registration expired, pending cancellation · Built 1978 · Aerosim Academy IncN4ABPiper PA-23-160 · S/N 23-1457Cancelled May 24, 2018 · Registration pending, canceled · Built 1958N824Bryan CASSUTT 111M · S/N 259Cancelled Mar 30, 2018 · Registration expired, pending cancellation · Built 1973 · Moreland James RN14TZQuad City Parts CH II · S/N 014Cancelled Mar 21, 2018 · Registration expired, pending cancellation · Built 2007 · Fyock Joe AnthonyN5548MCessna 152 · S/N 15284611Cancelled Jan 25, 2018 · Registration expired, pending cancellation · Built 1980 · Van Zyl Adrian FranciosN66VPHesser Clarence E HESSER VP II · S/N 1176Cancelled Jan 25, 2018 · Registration expired, pending cancellation · Built 1993 · Berger JonN4094XBrooks Mike HUMMINGBIRD · S/N 0693Cancelled Jan 18, 2018 · Registration expired, pending cancellation · Vertical Aviation Technologies IncN1927BTeal Harry H SONERAI II STRETCH · S/N 071604-0693Cancelled Jan 3, 2018 · Registration expired, pending cancellation · Built 2009 · Teal Harry HN503DELY Dennis R HM-290 · S/N 001Cancelled Nov 14, 2017 · Second renewal notice · Ely Dennis RN25PEPiper PA-44-180 · S/N 44-7995184Cancelled Oct 27, 2017 · Registration expired, pending cancellation · Built 1978 · Aerosim Academy IncN2105PPiper PA-44-180 · S/N 44-7995231Cancelled Oct 6, 2017 · Registration expired, pending cancellation · Built 1979 · Aerosim Academy IncN115HMCessna 172RG · S/N 172RG0490Cancelled Jun 30, 2017 · Registration expired, pending cancellation · Aerosim Academy IncN271EPCessna 172N · S/N 17273207Cancelled Apr 18, 2017 · Registration expired, pending cancellation · Built 1979 · Kreusch PatrickN130AAAmerican Champion 8KCAB · S/N 902-2002Cancelled Feb 27, 2017 · Exported to Argentina · Built 2002 · Orlando Sanford Aircraft Services IncN49009Cessna 152 · S/N 15281098Cancelled May 19, 2015 · Registration expired, pending cancellation · Built 1977 · Aerosim Academy IncN21JRRichards STARDUSTER TOO · S/N 001Cancelled May 13, 2015 · Registration expired, pending cancellation · Stairs Karl ON54066Sikorsky HO5-S1 · S/N 52006Cancelled May 12, 2015 · Registration expired, pending cancellation · Florida Helicopter CorpN120DTBill Parsons Gyros AIR COMMAND 1000 · S/N 027Cancelled May 5, 2015 · Registration expired, pending cancellation · Bill Parsons Gyros IncN270PBill Parsons Gyros AIR COMMAND 1000 · S/N 029Cancelled May 5, 2015 · Registration expired, pending cancellation · Bill Parsons GyrosN67415Cessna 152 · S/N 15281824Cancelled May 4, 2015 · Registration expired, pending cancellation · Built 1978 · Aerosim Academy IncN5786MCessna 310P · S/N 310P0086Cancelled Apr 30, 2015 · Registration expired, pending cancellation · Built 1969 · Paulucci Jeno FN370HBill Parsons Gyros AIR COMMAND 1000 · S/N 028Cancelled Dec 22, 2014 · Registration expired, pending cancellation · Bill Parsons GyrosN9018QSikorsky S-52-3 · S/N 52071Cancelled Nov 20, 2014 · Registration expired, pending cancellation · Florida Helicopter CorpN90408Sikorsky UH-19F · S/N 138601Cancelled Nov 20, 2014 · Registration expired, pending cancellation · Built 1971 · Rotor Parts IncN7127FCessna 150F · S/N 15063727Cancelled Nov 13, 2014 · Registration expired, pending cancellation · Built 1966 · St George Anthony RN5771XCessna 320 · S/N 320-0071Cancelled Oct 30, 2014 · Registration expired, pending cancellation · Built 1961 · Florida Aircraft Sales & Leasing IncN54060Sikorsky S-52-3 · S/N 52063Cancelled Oct 27, 2014 · Registration expired, pending cancellation · Built 1952 · Florida Helicopter CorpN2014ZTeal Harry H RCKY MTN WGS MDL TWO · S/N 22Cancelled Oct 9, 2014 · Registration expired, pending cancellation · Teal Harry HN4645SSikorsky S-52-3 · S/N 125526Cancelled Oct 9, 2014 · Registration expired, pending cancellation · Built 1958 · Florida Helicopter CorpN118LBeech D18S · S/N A-258Cancelled Nov 13, 2013 · Registration expired, pending cancellation · Built 1946 · Delno Harry HN44688Sikorsky S55B · S/N 57-5928Cancelled Nov 8, 2013 · Registration expired, pending cancellation · Orlando Aviation Inc
Back to Sanford, FL