OpenAirDocs.org
Lantana, FL

Cancelled registrations · 73

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

N2762TBeech 95-C55 · S/N TE-381Cancelled Oct 1, 2022 · Registration expired, pending cancellation · Pefley Paul S IIIN946AHGrumman OV-1D · S/N 68-15946Cancelled Apr 2, 2022 · Registration expired, pending cancellation · Built 1968 · Mohawk Technologies LLCN7179ACessna 172 · S/N 29279Cancelled Feb 3, 2020 · Revoked, canceled · Built 1956 · Internatl Air Service IncN75RRCessna 172K · S/N 17257544Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Built 1968 · Romeo Romeo IncN3016LPiper PA-32RT-300 · S/N 32R-7985068Cancelled May 17, 2019 · First renewal notice · Built 1979 · Simmons Pet Properties LLCN6931PPiper PA-24 · S/N 24-2065Cancelled Feb 12, 2019 · Registration expired, pending cancellation · Built 1960 · Mohawk Technologies LLCN479ATRobinson Helicopter R44 · S/N 1768Cancelled Oct 27, 2018 · Built 2007 · Airmen Testing And Training Inc DBAN349AZX-Air/Christian P K AIRPLANE-XAIR · S/N 661Cancelled Sep 13, 2018 · Registration expired, pending cancellation · Built 2006 · Tanfield Theodore WN224TTGrumman OV-1D · S/N 67-18923Cancelled Apr 18, 2018 · Registration expired, pending cancellation · Mohawk Technolgies LLCN226TTGrumman OV-1D · S/N 67-15959Cancelled Apr 18, 2018 · Registration expired, pending cancellation · Mohawk Technologies LLCN8160UCessna 150M · S/N 15077904Cancelled Apr 6, 2018 · Revoked, canceled · Built 1976 · Florida Airmotive IncN666MEAero Commander 500-B · S/N 1531-190Cancelled Mar 12, 2018 · Registration expired, pending cancellation · Schiller James MN6747ECessna 175A · S/N 56247Cancelled Jan 26, 2018 · Registration expired, pending cancellation · Built 1959 · Bates Sam JrN6607XCessna 210A · S/N 21057607Cancelled Jun 30, 2017 · Registration expired, pending cancellation · Built 1960 · Koons Robert H JrN8213PPiper PA-24-250 · S/N 24-3466Cancelled Mar 24, 2017 · Registration expired, pending cancellation · Built 1963 · Hogan Charles DN7807BCessna 195 · S/N 7820Cancelled Feb 4, 2017 · Revoked, canceled · Built 1951 · William T DuvallN144TSDiamond Aircraft Ind DA 42 · S/N 42.AC005Cancelled Nov 23, 2015 · Exported to Argentina · Built 2006 · Mohawk Technologies LLCN456KGDiamond Aircraft Ind DA 42 · S/N 42.AC031Cancelled Nov 23, 2015 · Exported to Argentina · Built 2006 · Mohawk Technologies LLCN663TGDiamond Aircraft Ind DA 42 · S/N 42.AC057Cancelled Nov 23, 2015 · Exported to Argentina · Built 2007 · Mohawk Technologies LLCN25441Cessna 152 · S/N 15280661Cancelled May 15, 2015 · Registration expired, pending cancellation · Built 1977 · Slowflight IncN1032UPiper PA-34-200 · S/N 34-7250013Cancelled Apr 30, 2015 · Registration expired, pending cancellation · Built 1971 · Blue Wings IncN89MAero Commander 500 · S/N 659Cancelled Feb 5, 2015 · Third renewal notice · Built 1958 · Amx Aviation Services IncN37BLLearjet 23 · S/N 069Cancelled Dec 15, 2014 · Third renewal notice · Built 1965 · C G AviationN6256BAero Commander 500 · S/N 808Cancelled Oct 9, 2014 · Registration expired, pending cancellation · Built 1959 · Aviation Charter ServicesN3841CAero Commander 500 · S/N 707Cancelled Oct 2, 2014 · Registration expired, pending cancellation · Built 1959 · Advanced Airways IncN15MJCessna 172M · S/N 17263238Cancelled Sep 4, 2014 · Third renewal notice · Built 1974 · Wing Hirata IncN3365XMooney M20C · S/N 3375Cancelled Sep 3, 2014 · Sale reported, canceled · Built 1966N3824CAero Commander 500 · S/N 697Cancelled Aug 5, 2013 · Sale reported, canceled · Built 1959N6200TCessna 150E · S/N 15060900Cancelled Aug 5, 2013 · Revoked, canceled · Built 1964 · Axt Allan HN4985YCessna 310R · S/N 310R0540Cancelled Jun 12, 2013 · Registration expired, pending cancellation · Built 1975 · Kejval George JN7926RCessna 421B · S/N 421B-0370Cancelled Apr 11, 2013 · Registration expired, pending cancellation · Built 1973 · Jet Version IncN5093MCessna 152 · S/N 15284498Cancelled Mar 21, 2013 · Registration expired, pending cancellation · Built 1980 · Kemper Aviation Training Center IncN46129Cessna 152 · S/N 15283002Cancelled Dec 11, 2012 · Registration expired, pending cancellation · Built 1978 · Genesee Airways IncN427ALBell 427 · S/N 56018Cancelled Oct 18, 2012 · Southern Aviation Systems LLCN6617UMooney M20D · S/N 112Cancelled Oct 11, 2012 · Sale reported, pending cancellation · Built 1963N5412PPiper PA-24-250 · S/N 24-466Cancelled Sep 20, 2012 · Revoked, canceled · Built 1958 · Van Wyhe William KN22358Cessna 150H · S/N 15068235Cancelled Aug 24, 2012 · Registration pending, canceled · Built 1968N5240NBeech C18S · S/N 6796Cancelled Aug 14, 2012 · Revoked, canceled · Built 1944 · Withey Charles ShepardN19254Cessna 150L · S/N 15074277Cancelled Aug 6, 2012 · Sale reported, canceled · Built 1973N623RMCessna 150L · S/N 15075373Cancelled Jun 4, 2012 · Registration expired, pending cancellation · Built 1973 · Carib-Air Cargo IncN194BBeech C-45H · S/N AF872Cancelled Oct 9, 2009 · Registration revoked · Built 1952 · Miller K DavidN4062XRobinson Helicopter R22 BETA · S/N 2264Cancelled May 5, 2007 · Triennial form not returned · Built 1992 · Airman Testing And Training IncN2305JRobinson Helicopter R22 BETA · S/N 1874Cancelled Apr 6, 2005 · Exported to United Kingdom · Built 1991 · Asg Aviation IncN47346Cessna 152 · S/N 15283218Cancelled Mar 24, 2004 · Exported to Japan · Built 1979N738SNCessna 172N · S/N 17270202Cancelled Nov 30, 1999 · Exported to Spain · Lantana Air IncN488MBPiper PA-32-260 · S/N 327100004Cancelled Jan 15, 1999 · Triennial form not returned · Sunshine Media Enterprises IncN961QBeech B95A · S/N TD493Cancelled Jul 17, 1997 · Triennial form not returned · Ark Air IncN3266GBritten-Norman BN-2A-3 · S/N C1065Cancelled Jun 23, 1997 · Exported to United Kingdom · Florida Airmotive IncN3267JBritten-Norman BN-2A-3 · S/N C1072Cancelled Jun 23, 1997 · Exported to United Kingdom · Florida Airmotive IncN89405Cessna 152 · S/N 15282735Cancelled Oct 15, 1996 · Triennial form not returned · Genesee Airways Inc
Back to Lantana, FL