Miami, FL

Cancelled registrations · 5,508

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

N5802UPiper PA-28-140 · S/N 28-26629Cancelled Feb 16, 2016 · Exported to Colombia · L C D Systems IncN162ATLockheed L-1011-385-3 · S/N 1220Cancelled Jan 12, 2016 · Exported to Panama · Barq Aviation IncN164ATLockheed L-1011-385-3 · S/N 1238Cancelled Jan 12, 2016 · Exported to Panama · Barq Aviation IncN194ATLockheed L-1011-385-1-15 · S/N 193B-1230Cancelled Jan 12, 2016 · Exported to Panama · Barq Aviation IncN112WYAviat A-1C-180 · S/N 3231Cancelled Dec 10, 2015 · Exported to Tanzania · Built 2015 · Africair IncN42HUAviat A-1C-180 · S/N 3235Cancelled Dec 9, 2015 · Exported to Tanzania · Built 2015 · Africair IncN525AAPiper PA-31-350 · S/N 31-8052111Cancelled Dec 2, 2015 · Exported to Colombia · Built 1980 · Venus America CorpN602YHCessna TU206G · S/N U20606230Cancelled Dec 2, 2015 · Exported to Colombia · Built 1981 · Venus America CorpN444USBoeing 737-4B7 · S/N 24862Cancelled Nov 20, 2015 · Exported to Venezuela · Built 1990 · Shell Aerospace Supplies LLCN246CRRhoads Charles F EUROPA XS · S/N A100Cancelled Nov 4, 2015 · Exported to Colombia · Built 2004 · Berkley International Trade Enterprise CorpN3103SCessna 208B · S/N 208B5212Cancelled Oct 26, 2015 · Exported to Cameroon · Built 2015 · Africair IncN6223DCessna 172N · S/N 17272643Cancelled Oct 13, 2015 · Built 1979 · Geotom IncN37BWAero Commander 690A · S/N 11129Cancelled Oct 7, 2015 · Exported to Venezuela · Built 1973 · A J Paradise LLCN7543AMcdonnell Douglas DC-9-82(MD-82) · S/N 53025Cancelled Sep 24, 2015 · Built 1990 · Aerothrust Holdings Leasing LLCN417USBoeing 737-401 · S/N 23984Cancelled Sep 22, 2015 · Exported to VenezuelaN333TNPiper PA-31T · S/N 31T-8020089Cancelled Sep 15, 2015 · Exported to Venezuela · Built 1980 · Atlantic Aviation Group IncN6084YPiper PA-23-250 · S/N 27-3286Cancelled Sep 14, 2015 · Exported to Venezuela · Built 1966 · Navas Carlos KoeslingN31055Cessna 208B · S/N 208B5184Cancelled Sep 9, 2015 · Exported to Kenya · Built 2015 · Africair IncN462UBBell Helicopter Textron Canada 412EP · S/N 36606Cancelled Sep 9, 2015 · Exported to Nigeria · Built 2012 · Africair IncN474NEBell Helicopter Textron Canada 412EP · S/N 36608Cancelled Sep 9, 2015 · Exported to Nigeria · Built 2012 · Africair IncN31037Cessna 208B · S/N 208B5215Cancelled Sep 3, 2015 · Exported to Uganda · Built 2015 · Africair IncN56WWBeech 95-B55 (T42A) · S/N TC-1705Cancelled Aug 24, 2015 · Sale reported · Built 1974N198NSCessna 550 · S/N 550-0133Cancelled Aug 17, 2015 · Exported to Venezuela · Built 1980 · Bs Airlines Supply CorpN25KHPiper PA-34-200T · S/N 34-7570192Cancelled Jul 29, 2015 · Exported to Venezuela · Built 1975 · Chief Aircraft Of AmericaN322RGSud SA 318C · S/N 2101Cancelled Jul 9, 2015 · Exported to El Salvador · Aviators II LLCN578ANCessna 680 · S/N 680-0293Cancelled Jun 17, 2015 · Exported to Angola · Africair IncN78045Universal GLOBE GC-1B · S/N 2045Cancelled Jun 16, 2015 · Exported to Brazil · Built 1946 · Pegasus Aircraft Parts And Systems IncN7194YPiper PA-31T2 · S/N 31T-8166064Cancelled Jun 15, 2015 · Exported to Ecuador · Built 1981 · Pan American Trading Co IncN4079YPiper PA-31-350 · S/N 31-8152079Cancelled Jun 10, 2015 · Exported to Colombia · Built 1981 · Venus America CorpN62RPPiper PA-28-181 · S/N 28-8090004Cancelled Jun 10, 2015 · Exported to El Salvador · Built 1979 · Tamiami Aircraft Services CorpN8118RCessna 208B · S/N 208B5118Cancelled Jun 10, 2015 · Exported to Angola · Built 2014 · Africair IncN4UEPiper PA-31-350 · S/N 31-8152061Cancelled Jun 9, 2015 · Exported to Colombia · Built 1980 · Venus America CorpN69192Cessna 152 · S/N 15282541Cancelled May 21, 2015 · Registration expired, pending cancellation · Built 1978 · Elide CorpN7083XCessna 150A · S/N 15059183Cancelled May 21, 2015 · Registration expired, pending cancellation · Built 1961 · George T Baker Aviation SchoolN739URCessna TR182 · S/N R18201007Cancelled May 21, 2015 · Registration expired, pending cancellation · Built 1979 · Rodriguez Gladys MercedesN941LFAirbus Industrie A320-233 · S/N 461Cancelled May 21, 2015 · Sale reported, canceledN2715RCessna 402C · S/N 402C0212Cancelled May 20, 2015 · Registration expired, pending cancellation · Executive Aircraft Of Central America LLCN281ACPiper PA-23-250 · S/N 27-4383Cancelled May 20, 2015 · Registration expired, pending cancellation · Built 1969 · Exuma Wings IncN53641Cessna 337G · S/N 33701749Cancelled May 20, 2015 · Registration expired, pending cancellation · Built 1976 · Bnc CorporationN6115QCessna 152 · S/N 15285140Cancelled May 20, 2015 · Registration expired, pending cancellation · Built 1981 · Elide Leasing IncN494EBCessna 411 · S/N 411-0144Cancelled May 19, 2015 · Registration expired, pending cancellation · Built 1965 · Jekir Enterprises IncN5394SCessna 337A · S/N 337-0494Cancelled May 19, 2015 · Registration expired, pending cancellation · Built 1966 · Gartner MikaelN66FAPiper PA-31-310 · S/N 31-629Cancelled May 19, 2015 · Registration expired, pending cancellation · Built 1970 · Spring Point IncN199NABoeing 737-222 · S/N 19949Cancelled May 18, 2015 · Registration expired, pending cancellation · Natco LtdN9535ZBeech C-45H · S/N AF-81Cancelled May 15, 2015 · Registration expired, pending cancellation · Built 1951 · Export Airmotive IncN1777TAero Commander 1121 · S/N 62Cancelled May 13, 2015 · Registration expired, pending cancellation · Westar Aviation IncN5182CAir Tractor AT-502B · S/N 502B-0499Cancelled May 13, 2015 · Sale reported, canceled · Built 1998N84789Cessna 172K · S/N 172-58612Cancelled May 13, 2015 · Registration expired, pending cancellation · Aritec USA IncN9911SRockwell International 700 · S/N 70011Cancelled May 13, 2015 · Registration expired, pending cancellation · Built 1978 · Air Antilles IncN11CPPiper PA-38-112 · S/N 38-78A0082Cancelled May 12, 2015 · Registration expired, pending cancellation · Built 1978 · Libardo Velez
Back to Miami, FL