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.

N86512Cessna 337E · S/N 33701215Cancelled Feb 4, 2017 · Revoked, canceled · Built 1969 · Aviation Facilities IncN86524Lockheed 749A-79 · S/N 2660Cancelled Feb 4, 2017 · Revoked, canceled · Built 1951 · Crosson Jack AN8925RAeronca 7GC · S/N 7GC153Cancelled Feb 4, 2017 · Revoked, canceled · Built 1959 · Helair IncN8926RAeronca 7GC · S/N 7GC154Cancelled Feb 4, 2017 · Revoked, canceled · Built 1959 · Helair IncN8927RAeronca 7GC · S/N 7GC155Cancelled Feb 4, 2017 · Revoked, canceled · Built 1959 · Helair IncN90094Cessna 140 · S/N 9155Cancelled Feb 4, 2017 · Revoked, canceled · Built 1946 · Weaver Ruth EN90757Douglas DC-6B · S/N 43269Cancelled Feb 4, 2017 · Revoked, canceled · Built 1951 · American Airline Sales CorpN9076ZNorth American TB-25N · S/N 4430772Cancelled Feb 4, 2017 · Revoked, canceled · Built 1959 · Nico IncN116LACessna 550 · S/N 550-0016Cancelled Jan 27, 2017 · Exported to Venezuela · Built 1978 · R S Global LLCN5291BMooney M20 · S/N 1154Cancelled Jan 24, 2017 · Revoked, pending cancellation · Built 1957 · Johnson WilliamN50277Cessna U206F · S/N U20601912Cancelled Jan 17, 2017 · Exported to Zambia · Built 1972 · Africair IncN906RDouglas DC-8-63F · S/N 46087Cancelled Dec 27, 2016 · Third renewal notice · Built 1969 · Miami Leasing IncN463CCirrus Design SR22 · S/N 0402Cancelled Dec 22, 2016 · First renewal notice · Built 2002 · Strato Cirrus LLCN380MPEurocopter EC120B · S/N 1406Cancelled Dec 20, 2016 · Exported to South Africa · Built 2005 · Miami Police DepartmentN129ERCessna U206E · S/N U20601690Cancelled Dec 15, 2016 · Exported to Guyana · Built 1971 · E A R Administrative LLCN361AGSaab-Scania SAAB 340B · S/N 340B451Cancelled Nov 23, 2016 · Exported to Cayman Islands · Built 1998 · Jahn361ag LLCN23DFGrumman G-21A · S/N 1133Cancelled Nov 16, 2016 · Third renewal notice · Built 1942 · Worldwide Aviation Distributors IncN2579BGrumman G-21A · S/N 37821Cancelled Nov 16, 2016 · Third renewal notice · Worldwide Aviation Distributors IncN7123JTextron 208B · S/N 208B5298Cancelled Nov 16, 2016 · Exported to Bahamas · Built 2016 · Africair IncN7146ZTextron 208B · S/N 208B5279Cancelled Nov 15, 2016 · Exported to Kenya · Built 2016 · Africair Aviation Leasing LLCN523HPCessna T206H · S/N T20608206Cancelled Nov 8, 2016 · Exported to Venezuela · R & V Aviation Services IncN48687Grumman Acft ENG Cor-Schweizer G-164B · S/N 157BCancelled Nov 3, 2016 · Exported to Venezuela · Built 1976 · R & V Aviation Services IncN198TWCessna 172S · S/N 172S9198Cancelled Nov 1, 2016 · Exported to Ethiopia · Built 2002 · Africair Inc DBAN17HFAero Commander 690A · S/N 11127Cancelled Oct 26, 2016 · Exported to Guatemala · Built 1973 · Vortex Capital Group IncN325TAPiper PA-31-325 · S/N 31-7712019Cancelled Oct 20, 2016 · Exported to Venezuela · Built 1977 · Bs Airlines Supply CorpN316ATAirbus A320-214 · S/N 992Cancelled Oct 5, 2016 · Sale reportedN512LPPiper PA-34-220T · S/N 3449184Cancelled Sep 15, 2016 · Exported to Brazil · Rolim Freight Forward IncN111APDouglas DC-6B · S/N 45218Cancelled Aug 31, 2016 · Third renewal notice · Built 1957 · Nighthawk Air Systems IncN737TPCessna 172N · S/N 17269665Cancelled Aug 17, 2016 · First renewal notice · Built 1977 · Lily Aviation CorpN90291Beech TC-45J · S/N 66431Cancelled Aug 17, 2016 · Revoked, pending cancellation · Built 1964 · Doog IncN63903Piper PA-23-250 · S/N 27-7854048Cancelled Jul 27, 2016 · Exported to Venezuela · Built 1977 · R And V Aviation Services IncN100SGPiper PA-34-200T · S/N 34-7570194Cancelled Jul 12, 2016 · Exported to Venezuela · Built 1975 · R & V Aviation Services IncN4199RPiper PA-32-300 · S/N 32-40681Cancelled Jul 12, 2016 · Exported to Venezuela · Built 1969 · R & V Aviation Services IncN5660MBell Helicopter Textron Canada 407 · S/N 54616Cancelled Jul 11, 2016 · Exported to Kenya · Built 2015 · Africair IncN922CTTextron T206H · S/N T20609212Cancelled Jun 29, 2016 · Exported to Kenya · Built 2016 · Africair IncN1342VCessna R172K · S/N R1722174Cancelled Jun 24, 2016 · Exported to Bolivia · Built 1976 · International Jet Center IncN148NDPiper PA-28-161 · S/N 2841338Cancelled Jun 3, 2016 · Non-citizen corporation, flight hours not reported · Built 1992 · Pan Am Ab Initio Training IncN411ACBeech 76 · S/N ME-108Cancelled Jun 3, 2016 · Non-citizen corporation, flight hours not reported · Built 1979 · Pan Am Ab Initio Training IncN746RAPiper PA-28-161 · S/N 2841136Cancelled Jun 2, 2016 · Non-citizen corporation, flight hours not reported · Built 1989 · Pan Am Ab Initio Training IncN107TWAviat A-1C-180 · S/N 3232Cancelled May 19, 2016 · Exported to Zambia · Built 2015 · Africair IncN2669CCessna R182 · S/N R18200203Cancelled May 16, 2016 · Exported to Venezuela · Built 1978 · R & V Aviation Services IncN757ECCessna TR182 · S/N R18201220Cancelled May 13, 2016 · Exported to Dominican Republic · Built 1979 · Salegna MichelN8427FCessna 340 · S/N 340-0158Cancelled May 4, 2016 · Exported to Venezuela · Built 1972 · R & V Aviation Services IncN83WMGates Learjet 55 · S/N 043Cancelled Apr 28, 2016 · Exported to Venezuela · Built 1982 · L55-043 Leasing LLCN7054ZPiper PA-25-235 · S/N 25-2823Cancelled Apr 27, 2016 · Exported to Brazil · Rolim Freight Forward IncN4736UCessna U206G · S/N U20605072Cancelled Mar 3, 2016 · Exported to Venezuela · Built 1979 · R&V Aviation Services IncN277KBeech 35-C33A · S/N CE-89Cancelled Mar 2, 2016 · Exported to Venezuela · Built 1966 · R&V Aviation Services IncN31044Cessna 208B · S/N 208B5181Cancelled Feb 23, 2016 · Exported to Kenya · Built 2015 · Africair Aviation Leasing LLCN13198Cessna 172M · S/N 17262565Cancelled Feb 22, 2016 · Exported to Venezuela · Built 1973 · Lima Bravo Group CorpN307JAGates Learjet 55 · S/N 101Cancelled Feb 17, 2016 · Exported to Venezuela · Built 1984 · Alderidge Aviation Holdings Inc
Back to Miami, FL