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.

N162PABeech 200 · S/N BB-232Cancelled Oct 29, 2013 · Registration expired, pending cancellation · John Air Services IncN2118XNorth American SNJ-6 · S/N 112322Cancelled Oct 29, 2013 · Exported to Brazil · Built 1945 · Alj Engines Supply IncN236TACessna 206H · S/N 20608350Cancelled Oct 29, 2013 · Exported to Dominican Republic · Built 2012 · Africair Aviation Leasing LLCN39FSmith SMITH MINIPLANE · S/N DSA-50-1Cancelled Oct 29, 2013 · Registration expired, pending cancellation · Built 1964 · Bertrand William GN7046HDouglas DC-8F-54 · S/N 46011Cancelled Oct 29, 2013 · Registration expired, pending cancellation · Built 1968 · Miami Leasing IncN914LFDouglas DC-9-14 · S/N 45695Cancelled Oct 29, 2013 · Registration expired, pending cancellation · International Airline Support GroupN5224CCessna T206H · S/N T20608386Cancelled Oct 28, 2013 · Exported to Paraguay · Built 2003 · Aero Centro IncN68AFBoeing 737-222 · S/N 19058Cancelled Oct 28, 2013 · Registration expired, pending cancellation · Built 1968 · International Arln Support Group IncN739RPCessna 172N · S/N 17270747Cancelled Oct 28, 2013 · Exported to Brazil · Built 1978 · Pegasus Aircraft Parts & Systems IncN92718Cessna 172M · S/N 17261607Cancelled Oct 28, 2013 · Exported to Brazil · Built 1973 · Pegasus Aircraft Parts & Systems IncN9526QCessna 172R · S/N 17280457Cancelled Oct 28, 2013 · Exported to Ethiopia · Built 1998 · Africair IncN7922QCessna 401B · S/N 401B0022Cancelled Oct 25, 2013 · Registration expired, pending cancellation · Built 1970 · Miller George SandsN6548NCessna 210N · S/N 21063104Cancelled Oct 24, 2013 · Registration expired, pending cancellation · Built 1978 · Burnside Ott Avn Sales & Service IncN690BCDehavilland DH 114 HERON 2X · S/N 14066Cancelled Oct 24, 2013 · Registration expired, pending cancellation · Built 1954 · Air Management Associates Inc DBAN74ARAero Commander 680 · S/N 680-455-125Cancelled Oct 24, 2013 · Registration expired, pending cancellation · Knight Aircraft CorpN8040YCurtiss Wright C-46A · S/N 30.323Cancelled Oct 24, 2013 · Registration expired, pending cancellation · Aircraft Line MaintenanceN21748Douglas DC3A · S/N 2106Cancelled Oct 23, 2013 · Registration expired, pending cancellation · Built 1939 · Cuesta PedroN2290LDouglas DC3C-S1C3G · S/N 12289Cancelled Oct 23, 2013 · Registration expired, pending cancellation · Built 1944 · Diaz J JN3482WPiper PA-32-260 · S/N 32-359Cancelled Oct 23, 2013 · Registration expired, pending cancellation · Built 1966 · R And D Aero Service IncN35NPiper PA-31-310 · S/N 31-7401226Cancelled Oct 23, 2013 · Registration expired, pending cancellation · Built 1974 · Inter American Leasing CorpN37163Cessna 404 · S/N 404-0126Cancelled Oct 23, 2013 · Registration expired, pending cancellation · Built 1977 · Little Bridge Marina IncN4167VCessna 170 · S/N 18500Cancelled Oct 23, 2013 · Registration expired, pending cancellation · Built 1948 · Fisher Martin AN64324Boeing 727-231 · S/N 20099Cancelled Oct 23, 2013 · Registration expired, pending cancellation · Built 1969 · International Airline Support GroupN720GSBoeing 707-321C · S/N 19370Cancelled Oct 21, 2013 · Registration expired, pending cancellation · Built 1967 · Pan Aviation IncN757LACessna 152 · S/N 15279814Cancelled Oct 21, 2013 · Registration expired, pending cancellation · Built 1977 · 136 Aviation CorporationN808EDouglas DC-8-51 · S/N 45646Cancelled Oct 21, 2013 · Registration expired, pending cancellation · Built 1962 · Cohen Mark AN869JHCessna 152 · S/N 15283065Cancelled Oct 21, 2013 · Registration expired, pending cancellation · Built 1978 · Husta Aviation IncN12681Grumman JRF-5 · S/N 34089Cancelled Oct 18, 2013 · Registration expired, pending cancellation · Built 1946 · Worldwide Aviation Distributors IncN234ACCessna 402B · S/N 402B0922Cancelled Oct 18, 2013 · Registration expired, pending cancellation · Built 1975 · Caribair IncN727DHBoeing 727-228 · S/N 20204Cancelled Sep 30, 2013 · Registration expired, pending cancellation · Built 1969 · Air Trading International LLCN7377UCessna T210R · S/N 21064965Cancelled Sep 30, 2013 · Registration expired, pending cancellation · Built 1986 · Crystal Air Sales IncN814GBDouglas DC-8-61 · S/N 45913Cancelled Sep 30, 2013 · Registration expired, pending cancellation · Built 1968 · G & B Aviation IncN82256Piper PA-44-180T · S/N 44-8107004Cancelled Sep 30, 2013 · Registration expired, pending cancellation · Built 1980 · Diacsa IncN888ZPiper PA-24-250 · S/N 24-310Cancelled Sep 30, 2013 · Registration expired, pending cancellation · Built 1958 · Schlick Carl MN110XSHawker Siddeley GNAT · S/N XS110Cancelled Sep 27, 2013 · Registration expired, pending cancellation · International Jet Center IncN1976PDouglas DC-8-21 · S/N 45435Cancelled Sep 27, 2013 · Registration expired, pending cancellation · Built 1961 · International Airline Support GroupN3235GPilatus Britten-Norman BN-2B-27 · S/N C2111Cancelled Sep 27, 2013 · Registration expired, pending cancellation · Air Group IncN71903Robinson Helicopter R44 · S/N 1290Cancelled Sep 27, 2013 · Exported to Panama · Built 2003 · Moreno RamonN4525Cessna 310A · S/N 38044Cancelled Sep 26, 2013 · Registration expired, pending cancellation · Built 1957 · Air America Ventures IncN6787CBeech C18S · S/N 44-47212Cancelled Sep 26, 2013 · Revoked, canceled · Built 1944 · Knight KarlN68041Mcdonnell Douglas DC-10-10 · S/N 46900Cancelled Sep 26, 2013 · Registration expired, pending cancellation · Built 1972 · Miami Leasing IncN738XBCessna 172N · S/N 17270308Cancelled Sep 26, 2013 · Registration expired, pending cancellation · Built 1978 · Yuhr KeithN206VAMitsubishi YS-11-100 · S/N 2006Cancelled Sep 25, 2013 · Registration expired, pending cancellation · Built 1990 · Kingsley Aviation IncN256ADBeech 58 · S/N TH-424Cancelled Sep 24, 2013 · Exported to Brazil · Built 1974 · Rolim Freight Forward IncN463USBoeing 727-51 · S/N 18799Cancelled Sep 24, 2013 · Registration expired, pending cancellation · Built 1964 · International Airline Support GroupN490ACRockwell International 690B · S/N 11521Cancelled Sep 24, 2013 · Registration expired, pending cancellation · Built 1979 · Impoexport Trading IncN5265YCessna T210N · S/N 21064143Cancelled Sep 24, 2013 · Registration expired, pending cancellation · Built 1980 · Calzadilla OscarN6182YPiper PA-23-250 · S/N 27-3408Cancelled Sep 24, 2013 · Registration expired, pending cancellation · Built 1966 · Champlain Enterprises IncN93RTTrickel R/Trickel R A TRI-RT 1 · S/N 001Cancelled Sep 24, 2013 · Registration expired, pending cancellation · Built 1991 · Trickel Richard AN508DCDouglas DC-8-51 · S/N 45935Cancelled Sep 20, 2013 · Registration expired, pending cancellation · Built 1968 · Miami Leasing Inc
Back to Miami, FL