OpenAirDocs.org
Mulberry, FL

Cancelled registrations · 30

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

N27WGKern David H LANCEAIR-4 · S/N LIV159Cancelled Feb 5, 2022 · Registration expired, pending cancellation · Built 2000 · Kern David HN395RKern David H SPARROWHAWK II · S/N S-02-00020Cancelled May 1, 2020 · Registration expired, pending cancellation · Built 2008 · Kern David HN503CTFlight Design CTSW · S/N 05-11-14Cancelled Aug 12, 2019 · Exported to Colombia · Built 2005 · Beyer Wayne AN8511JCessna 150G · S/N 15066411Cancelled Feb 6, 2019 · Registration expired, pending cancellation · Built 1967 · Short Terry LN175CCAerosport USA IKARUS C42E · S/N 1105-7159Cancelled Oct 27, 2017 · Registration expired, pending cancellation · Aerosport USAN211RCessna 170B · S/N 20672Cancelled Jan 20, 2016 · Built 1952 · Trembley Sharon LN906LAEvektor-Aerotechnik SPORTSTAR PLUS · S/N 2007 0906Cancelled Dec 10, 2014 · Sale reported, pending cancellation · Built 2007N132BWWyllia Bill D SCORPION 2 · S/N 1372Cancelled Sep 19, 2013 · Registration expired, pending cancellation · Built 1979 · Stoneking Gary AN307AHFoht Richard ELF · S/N 0001Cancelled Aug 23, 2013 · Sale reported, canceledN48288Kertesz WOODY PUSHER · S/N 273-44-6773Cancelled Jun 13, 2013 · Sale reported, canceled · Built 1975N44768Naval Aircraft Factory N3N-3 · S/N 2005Cancelled Aug 28, 2012 · Sale reported, canceled · Built 1940N132CCAerosport USA IKARUS C42E · S/N 1105-7158Cancelled Jul 16, 2012 · Exported to Canada · Aerosport USAN175TKSouth Florida Ultralights S-6 · S/N 01080571Cancelled Jul 7, 2011 · South Florida Ultralights IncN235TKSouth Florida Ultralights S-12XL · S/N 0308 1235Cancelled Jul 7, 2011 · South Florida Ultralights IncN235WPSouth Florida Ultralights XSTD · S/N TD 0308Cancelled Jul 7, 2011 · South Florida Ultralights IncN236WPSouth Florida Ultralights S12 · S/N 001Cancelled Jul 7, 2011 · South Florida Ultralights IncN152LSSouth Florida Ultralights S-19 · S/N 72240124Cancelled Apr 5, 2011 · South Florida Ultralights IncN157LSSouth Florida Ultralights S-19 · S/N 72250124Cancelled Apr 5, 2011 · South Flordia Ultralights IncN174TKSouth Florida Ultralights S-6 · S/N 01080471Cancelled Apr 5, 2011 · South Florida Ultralights IncN747TKSouth Florida Ultralights RV-9A · S/N 0129001Cancelled Apr 5, 2011 · South Florida Ultralights IncN957SMPiper PA-23-250 · S/N 27-2136Cancelled Mar 18, 2011 · Expired dealer · Built 1962 · Nickerson Aircraft Sales IncN151RGLoehle P5151 · S/N 5151-14087785Cancelled Jul 8, 2008 · Triennial form not returned · Gentry Robert CN34115Commonwealth REARWIN 185 · S/N 1849Cancelled Jun 7, 2006 · Exported to Canada · Fodor Alex JN52042Short Terry L MICRO MONG · S/N 101Cancelled Apr 14, 2003 · Triennial form not returned · Short Terry LN50924Veitch Tom BUCCANEER B2B · S/N B2B501582Cancelled Feb 19, 1997 · Wolf Donald JN7388XMXL II MXL II · S/N 1201Cancelled Jul 14, 1993 · Triennial form not returned · Lia John AN76RBRosinbaum Daryl A CHRISTEN EAGLE II · S/N R-0042Cancelled Dec 6, 1984 · Rosinbaum Daryl AN7079ECessna 175A · S/N 56579Cancelled Jun 24, 1970 · Mulberry Construction And Welding CoN23982Aeronca 50-C · S/N C-6409Cancelled May 21, 1965 · Built 1939 · Polk Dale EugeneN46620Taylorcraft DCO-65 · S/N 4644Cancelled Mar 31, 1955 · Built 1942 · Gilvary K Mc
Back to Mulberry, FL