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.

N6415YPiper PA-23-250 · S/N 27-3706Cancelled Nov 12, 2014 · Registration expired, pending cancellation · Built 1967 · Intercaribbean Aviation IncN6483ECessna T182 · S/N 18268369Cancelled Nov 12, 2014 · Registration expired, pending cancellation · Built 1984 · Commercial AviationN65699Lake LA-4-200 · S/N 604Cancelled Nov 12, 2014 · Registration expired, pending cancellation · Built 1974 · Artola Alfonso JrN66612Cessna 150M · S/N 15076154Cancelled Nov 12, 2014 · Registration expired, pending cancellation · Built 1974 · De Gongora LuisN27439Piper PA-31-325 · S/N 31-7812017Cancelled Nov 10, 2014 · Exported to Colombia · Built 1977 · Lcd Systems IncN533AUBoeing 737-3B7 · S/N 24515Cancelled Nov 6, 2014 · Expired dealer · Built 1989 · Magna Tech Aviation IncN3515Mcdonnell Douglas DC-9-82(MD-82) · S/N 49892Cancelled Nov 5, 2014 · Built 1990 · Aerothrust Holdings Leasing LLCN516AMMcdonnell Douglas DC-9-82(MD-82) · S/N 49893Cancelled Nov 5, 2014 · Built 1990 · Aerothrust Holdings Leasing LLCN7530Mcdonnell Douglas DC-9-82(MD-82) · S/N 49922Cancelled Nov 5, 2014 · Sale reported · Built 1990N5958YPiper PA-23-250 · S/N 27-3128Cancelled Oct 29, 2014 · Registration expired, pending cancellation · Built 1965 · All Aircraft ServicesN59716Piper PA-31-350 · S/N 31-7652020Cancelled Oct 29, 2014 · Registration expired, pending cancellation · Built 1975 · Dade Monroe Programming & AssocN6082WPiper PA-28-140 · S/N 28-20096Cancelled Oct 29, 2014 · Registration expired, pending cancellation · Built 1964 · Baptiste EmmanuelN6207JPiper PA-32R-300 · S/N 32R-7680318Cancelled Oct 29, 2014 · Registration expired, pending cancellation · Built 1976 · Scully Tom PN666RKMitsubishi MU-2B-10 · S/N 110Cancelled Oct 29, 2014 · Registration expired, pending cancellation · Built 1968 · Antroguz CorpN882APiper PA-31-350 · S/N 31-7652139Cancelled Oct 29, 2014 · Registration expired, pending cancellation · Built 1976 · Duran MiguelN53615Cessna 172S · S/N 172S9414Cancelled Oct 28, 2014 · Exported to Ethiopia · Diesel Flight Sales LLCN65787Cessna 172S · S/N 172S9759Cancelled Oct 28, 2014 · Exported to Ethiopia · Built 2004 · Diesel Flight Sales LLCN516PABeech 3 TM · S/N CA-163Cancelled Oct 27, 2014 · Registration expired, pending cancellation · Built 1952 · Lowery AircraftpartsN5172YPiper PA-23-250 · S/N 27-2213Cancelled Oct 27, 2014 · Registration expired, pending cancellation · Built 1962 · Future Air Freight IncN53034Cessna 172P · S/N 17274668Cancelled Oct 27, 2014 · Registration expired, pending cancellation · Built 1981 · Tamiami Jet CorpN5542AGrumman G-21A · S/N 37281Cancelled Oct 27, 2014 · Registration expired, pending cancellation · Coastal Air IncN1985GHead Balloons AX7-77 · S/N 142Cancelled Oct 20, 2014 · Registration expired, pending cancellation · Sunrise Community Promotions IncN808PDCessna 206H · S/N 20608076Cancelled Oct 20, 2014 · Exported to Brazil · Built 1999 · Rolim Freight Forward IncN169JHCessna 152 · S/N 15284845Cancelled Oct 14, 2014 · Registration expired, pending cancellation · Built 1981 · Husta Aviation IncN4759PPiper PA-23-250 · S/N 27-299Cancelled Oct 14, 2014 · Registration expired, pending cancellation · Built 1960 · D M L IncN4771ECessna 172N · S/N 17271636Cancelled Oct 14, 2014 · Registration expired, pending cancellation · Built 1979 · Cox Alicia EN503CConvair 240-14 · S/N 126Cancelled Oct 14, 2014 · Registration expired, pending cancellation · Gala Enterprise IncN983BBell 47H-1 · S/N 1356Cancelled Oct 14, 2014 · Revoked, pending cancellation · Built 1955 · Sun Line Helicopters IncN437BWPiper PA-31-310 · S/N 31-699Cancelled Oct 9, 2014 · Registration expired, pending cancellation · Built 1970 · Santre CorpN4556EAero Commander 680T · S/N 1614-48Cancelled Oct 9, 2014 · Registration expired, pending cancellation · Built 1967 · Laurean JamesN6401PBell 206B · S/N 4520Cancelled Oct 9, 2014 · Exported to Guatemala · Built 1999 · Jacobi International IncN8105NBoeing 727-25 · S/N 18256Cancelled Oct 9, 2014 · Registration expired, pending cancellation · Built 1964 · Northeast Airlines IncN3655LAir Tractor AT-301 · S/N 301-0295Cancelled Oct 8, 2014 · Registration pending, canceledN391UDouglas DC3-G202A · S/N 2218Cancelled Oct 6, 2014 · Registration expired, pending cancellation · Built 1940 · Jet Engine Support IncN4040UBalloon Works FIREFLY 7 · S/N 7837Cancelled Oct 6, 2014 · Registration expired, pending cancellation · Built 1979 · Coombs Elmer LN4062TBalloon Works FIREFLY 6 · S/N 6751Cancelled Oct 6, 2014 · Registration expired, pending cancellation · Vincent Lynn AN406EECessna 310F · S/N 310F-0151Cancelled Oct 6, 2014 · Registration expired, pending cancellation · Built 1961 · Aquaius Rising Aviation IncN41452Piper PA-32-260 · S/N 32-7400031Cancelled Oct 6, 2014 · Registration expired, pending cancellation · Built 1974 · E&E AviationN41JTCessna 421B · S/N 421B-0378Cancelled Oct 6, 2014 · Registration expired, pending cancellation · Built 1973 · Dynamic Auto Sales IncN707LEBoeing 707-321B · S/N 19361Cancelled Oct 6, 2014 · Registration expired, pending cancellation · Built 1967 · Legion Express IncN8552EAeronca 7GC · S/N 7GC131Cancelled Oct 6, 2014 · Revoked, pending cancellation · Built 1959 · Helair IncN338PBeech 65-A80 · S/N LD-178Cancelled Oct 2, 2014 · Registration expired, pending cancellation · Built 1964 · Walders MylesN3712WPiper PA-32-260 · S/N 32-625Cancelled Oct 2, 2014 · Registration expired, pending cancellation · Built 1966 · Knight KarlN3842XBoeing 707-227 · S/N 17692Cancelled Oct 2, 2014 · Registration expired, pending cancellation · Built 1959 · Monarch Aviation IncN230NWMcdonnell-Douglas DC-10-30 · S/N 46552Cancelled Sep 29, 2014 · Registration expired, pending cancellation · Picl Aviation III LLCN297FAero Commander 680 · S/N 680-405-82Cancelled Sep 29, 2014 · Registration expired, pending cancellation · Built 1956 · Land And Sea UnlimitedN328Grumman G-21A · S/N 1053Cancelled Sep 29, 2014 · Registration expired, pending cancellation · Built 1958 · Worldwide Aviation Distributors IncN268BPiper PA-31-310 · S/N 31-127Cancelled Sep 25, 2014 · Registration expired, pending cancellation · Wesson Henry H JrN2692XCessna P206A · S/N P206-0192Cancelled Sep 25, 2014 · Registration expired, pending cancellation · Built 1965 · Pugsley WilliamN276SPiper PA-34-200T · S/N 34-7670273Cancelled Sep 25, 2014 · Registration expired, pending cancellation · Built 1976 · Affordable Flight Time Inc
Back to Miami, FL