OpenAirDocs.org
Sunrise, FL

Cancelled registrations · 78

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

N5280ZPiper PA-23-250 · S/N 27-7305154Cancelled Jan 2, 2025 · Exported to Bahamas · Built 1973 · Skycrown Aviation LLCN455RLBell Helicopter Textron 206L-1 · S/N 45503Cancelled Nov 27, 2024 · Exported to Colombia · Built 1980 · Good Fly-Thx Ut LLCN774TSHawker Siddeley BH.125-400A · S/N NA774Cancelled May 30, 2023 · Exported to MexicoN914RCPiper PA-34-220T · S/N 34-8233061Cancelled Dec 31, 2022 · Registration expired, pending cancellation · Built 1981 · Avioelectronica IncN661EPEmbraer-Empresa Brasileira De EMB-500 · S/N 50000123Cancelled Apr 18, 2022 · Registration expired, pending cancellation · Built 2009 · Executive Aviation Investors IncN758JAGates Learjet 35A · S/N 497Cancelled Jan 6, 2022 · Exported to Mexico · Jet Access CorpN141MCCessna 402B · S/N 402B0547Cancelled Jun 5, 2021 · Registration expired, pending cancellation · Built 1974 · On Time Charters And Leasing LLCN5814ABeechcraft G58 · S/N TH-2424Cancelled Aug 20, 2020 · Exported to Mexico · Built 2014 · Yl Aviation 2 LLCN9141NPiper PA-31-350 · S/N 318253009Cancelled Feb 11, 2020 · Registration expired, pending cancellation · Built 1982 · Avioelectronica IncN4939UCessna 210E · S/N 21058639Cancelled Nov 8, 2019 · Exported to Mexico · Built 1965 · Manic AnirudhN4619CCessna T303 · S/N T30300114Cancelled Jul 10, 2019 · Exported to Colombia · Built 1982 · Avioelectronica IncN188TGPiper PA-31-350 · S/N 31-7752167Cancelled Apr 18, 2018 · Registration expired, pending cancellation · Avioelectronica IncN7351RBeech 58 · S/N TH-481Cancelled Mar 20, 2018 · Registration expired, pending cancellation · Built 1974 · Touch N Go Aeroworks LLCN6077HEurocopter AS 350 BA · S/N 2693Cancelled Mar 1, 2018 · Exported to Panama · Built 1992N1991CWestern Ultralight FLIGHTSTAR II · S/N FS2-8947Cancelled Feb 27, 2018 · Registration expired, pending cancellation · Built 1994 · Smith John AN3828TPiper PA-28R-180 · S/N 28R-30146Cancelled Feb 7, 2018 · Registration expired, pending cancellation · Built 1967 · Fay Barry HN447WGGray Warron KR 2S · S/N 8770/KR2S 323Cancelled Jan 23, 2018 · Registration expired, pending cancellation · Gray Warron DN1524YCessna 172C · S/N 17249224Cancelled Apr 13, 2017 · Registration expired, pending cancellation · Built 1962 · Ruffner H E JrN425UEBritish Aerospace BAE JETSTREAM 3101 · S/N 798Cancelled Apr 13, 2017 · Registration expired, pending cancellation · Built 1988 · Quassar LLCN742VLCessna 208B · S/N 208B1100Cancelled Dec 10, 2015 · Exported to Colombia · Built 2004 · Lima Romeo Aviation IncN97NBell Helicopter Textron 206L-1 · S/N 45771Cancelled Oct 8, 2015 · Exported to Colombia · Built 1983 · Avioelectonica IncN177CLBell 206L-3 · S/N 51106Cancelled Aug 10, 2015 · Exported to Colombia · Avioelectronica IncN250MSGulfstream American G-1159 · S/N 045Cancelled Mar 24, 2015 · Sale reported, pending cancellation · Built 1969N470CBCessna 421C · S/N 421C0482Cancelled Mar 10, 2015 · Third renewal notice · Built 1978 · Executive Flyers IncN229VKCessna 162 · S/N 16200200Cancelled Feb 18, 2015 · Exported to Colombia · Built 2012 · Lima Romeo Aviation IncN4502LPiper PA-31-350 · S/N 31-8052178Cancelled Feb 18, 2015 · Exported to Colombia · Built 1980 · Avio Electronica IncN105TGPiper PA-31-350 · S/N 317652004Cancelled Nov 18, 2014 · Exported to Colombia · Avioelectronica IncN54506Cessna 172P · S/N 17274993Cancelled Oct 27, 2014 · Registration expired, pending cancellation · Built 1981 · Meredith LarryN233PGPiper PA-32R-301 · S/N 32R-8013075Cancelled Oct 24, 2014 · Exported to Colombia · Avidelectronica IncN74FFPiper PA-34-200T · S/N 34-7570300Cancelled Sep 5, 2014 · Exported to Colombia · Built 1976 · Avioelectronica IncN9998MCessna TU206G · S/N U20604645Cancelled May 29, 2014 · Exported to Colombia · Built 1978 · Avioelectronica IncN701ATBeech B90 · S/N LJ390Cancelled May 27, 2014 · Third renewal notice · Global Sky Aviation CorpN428JRPiper PA-31-350 · S/N 31-8253007Cancelled May 13, 2014 · Exported to Colombia · Built 1982 · Avio Electronica IncN47733Piper PA-34-200T · S/N 34-7770433Cancelled Apr 11, 2014 · Exported to Brazil · Built 1977 · Veralube LLCN154EJPiper PA-31-350 · S/N 317752147Cancelled Feb 19, 2014 · Exported to Colombia · Avioelectronica IncN54SWBoeing 737-2H4 · S/N 21535Cancelled Aug 21, 2013 · Sale reported, canceled · Built 1978N258TBBenton Thomas J BABY PT-19 · S/N BPT19-6878Cancelled Jul 18, 2013 · Registration expired, pending cancellation · Escandell OrestesN5528JPiper PA-32-260 · S/N 32-989Cancelled Jun 27, 2013 · Registration expired, pending cancellation · Built 1967 · Bradshaw Theodore E JrN900HFCessna T206H · S/N T20608049Cancelled Jun 18, 2013 · Exported to Colombia · Built 1999 · AvioelectronicaN37482Balloon Works FIREFLY 7 · S/N F7-123Cancelled Jun 6, 2013 · Registration expired, pending cancellation · Built 1983 · Akridge Alvin DN3697FBeech 200C · S/N BL-14Cancelled May 31, 2013 · Exported to Colombia · Built 1980N84240Piper PA-34-220T · S/N 34-8133193Cancelled May 30, 2013 · Registration expired, pending cancellation · Mccarthy KevinN43582Piper PA-28-151 · S/N 28-7415530Cancelled Nov 21, 2012 · Registration expired, pending cancellation · Built 1974 · Balogh Attila WN5205JCessna 402B · S/N 402B0892Cancelled Jul 26, 2012 · Exported to Venezuela · Built 1975 · Toda Exports LLCN90EJBeech C90 · S/N LJ-749Cancelled May 10, 2012 · Exported to Colombia · Built 1977 · Lima Romeo Aviation IncN5053UCessna 206 · S/N 2060053Cancelled Jan 9, 2012 · Exported to Brazil · Built 1964 · Veralube LLCN2203SCessna T210L · S/N 21061161Cancelled Sep 7, 2011 · Exported to Colombia · Built 1976 · Lima Romeo Aviation IncN761MQCessna T210M · S/N 21062367Cancelled Jun 3, 2011 · Exported to Honduras · Built 1977 · First Class Air Services LLCN13PBPiper PA-34-200T · S/N 34-7870003Cancelled May 18, 2011 · Exported to Colombia · Built 1977 · Avioelectronica IncN1784XCessna T210L · S/N 21060804Cancelled Jan 11, 2011 · Exported to Honduras · Built 1975 · First Class Air Services LLC
Back to Sunrise, FL