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.

N9232ZDouglas DC-6A · S/N 44915Cancelled May 22, 2013 · Registration expired, pending cancellation · Built 1956 · Quo Vadis IncorporatedN9241YPiper PA-31-310 · S/N 31-313Cancelled May 22, 2013 · Registration expired, pending cancellation · Built 1968 · Terry StevensN92453Cessna 172N · S/N 17261578Cancelled May 22, 2013 · Registration expired, pending cancellation · Built 1973 · T & T Motor HomesN9288HCessna 172M · S/N 17266069Cancelled May 22, 2013 · Registration expired, pending cancellation · Built 1975 · International Flight Center IncN132LAAero Commander 1121B · S/N 133Cancelled May 21, 2013 · Registration expired, pending cancellation · Built 1968 · Herreos Alberto PN245HGDouglas DC-8-53 · S/N 45662Cancelled May 21, 2013 · Registration expired, pending cancellation · G&B AviationN896JBLockheed PV-1 · S/N 5500Cancelled May 17, 2013 · Registration expired, pending cancellation · Built 1961 · Night Hawk Air Systems IncN90447Douglas C-118A · S/N 44608Cancelled May 17, 2013 · Registration expired, pending cancellation · Built 1981 · Jacobs HarryN90766Bell 47D5A · S/N 51-13974Cancelled May 17, 2013 · Registration expired, pending cancellation · Built 1951 · Foster C TomN9109VMooney M20F · S/N 690025Cancelled May 17, 2013 · Registration expired, pending cancellation · Built 1969 · Coral Beauties IncN8592TCessna 182C · S/N 52492Cancelled May 15, 2013 · Registration expired, pending cancellation · Built 1959 · Fahey Thomas KN86427North American TB-25N · S/N 44-29121Cancelled May 15, 2013 · Registration expired, pending cancellation · Built 1962 · Visionair International IncN872ADouglas DC3A · S/N 7403Cancelled May 15, 2013 · Registration expired, pending cancellation · Built 1942 · Six Brothers IncN8751PPiper PA-24-250 · S/N 24-3682Cancelled May 15, 2013 · Registration expired, pending cancellation · Built 1964 · Frometa AlfredoN87ZNorth American B-25J · S/N 44-86873ACancelled May 15, 2013 · Registration expired, pending cancellation · Built 1944 · Ortiz Marcelo RN880WAConvair 22 · S/N 51Cancelled May 15, 2013 · Registration expired, pending cancellation · Built 1961 · Faix Vincent JN410JRBoeing 757-29J · S/N 27204Cancelled May 14, 2013 · Sale reported, pending cancellationN587LMDouglas C-117D · S/N 43369Cancelled May 14, 2013 · Registration expired, pending cancellation · Tmf Aircraft IncN8215HDouglas DC-7C · S/N 45212Cancelled May 14, 2013 · Registration expired, pending cancellation · Built 1960 · Airlift International IncN8218HDouglas DC-7C · S/N 45191Cancelled May 14, 2013 · Registration expired, pending cancellation · Built 1957 · Airlift International IncN44UADouglas DC-8F-54 · S/N 45800Cancelled May 13, 2013 · Registration expired, pending cancellation · Built 1965 · Miami Leasing IncN48192Henry BENSEN B-8M · S/N 44824Cancelled May 13, 2013 · Sale reported, canceled · Built 1975N8021GCessna 177RG · S/N 177RG0021Cancelled May 13, 2013 · Registration expired, pending cancellation · Built 1970 · Slotsky S PhillipN818UJCessna 421B · S/N 421B0003Cancelled May 13, 2013 · Registration expired, pending cancellation · Built 1970 · Cherco LimitedN821FDouglas DC-8-21 · S/N 45433Cancelled May 13, 2013 · Registration expired, pending cancellation · Built 1960 · International Airline Support GroupN8CWBeech J50 · S/N JH-165Cancelled May 13, 2013 · Registration expired, pending cancellation · Built 1962 · Doktors Aviation IncN6115UCessna T210R · S/N 21064904Cancelled May 10, 2013 · Sale reported, canceledN63MUGulfstream Aerospace G-IV · S/N 1152Cancelled May 10, 2013 · Sale reported, pending cancellation · Built 1990N8338JCessna 150G · S/N 15066238Cancelled May 10, 2013 · Sale reported, canceled · Built 1967N924LDouglas DC-9-32 · S/N 47324Cancelled May 10, 2013 · Sale reported, canceled · Built 1969N2558XCessna P206 · S/N P206-0058Cancelled May 9, 2013 · Exported to Bolivia · Built 1964 · Alas Srl CorpN3900NBeech 35 · S/N D-1146Cancelled May 9, 2013 · Sale reported, canceled · Built 1947N77ACCessna 421A · S/N 421A0078Cancelled May 9, 2013 · Registration expired, pending cancellation · Built 1969 · Transcontinental Tvl Pvt Tours IncN780BPAero Commander 690 · S/N 11052Cancelled May 9, 2013 · Registration expired, pending cancellation · Long Star Air Service IncN7947YPiper PA-30 · S/N 30-1043Cancelled May 9, 2013 · Registration expired, pending cancellation · Built 1966 · Ace Aeromotive IncN7437LPiper PA-31-310 · S/N 31-824Cancelled May 8, 2013 · Registration expired, pending cancellation · Built 1972 · Martin Michael GN74902Piper PA-31-350 · S/N 31-7305031Cancelled May 8, 2013 · Registration expired, pending cancellation · Built 1973 · Track CorporationN75033Piper PA-32R-300 · S/N 32R-7680247Cancelled May 8, 2013 · Registration expired, pending cancellation · Built 1976 · Kelly Steven KN75338Curtiss Wright C-46A · S/N 26814Cancelled May 8, 2013 · Registration expired, pending cancellation · Built 1945 · Riddle Airlines IncN7589UCessna 150M · S/N 15077756Cancelled May 8, 2013 · Registration expired, pending cancellation · Built 1975 · Dade County Public SchoolsN76JTPiper PA-23-250 · S/N 27-503Cancelled May 8, 2013 · Registration expired, pending cancellation · Built 1961 · Melendez JesusN76KWDouglas DC3C · S/N 9397Cancelled May 8, 2013 · Registration expired, pending cancellation · Built 1943 · Coastal Airways IncN6608YPiper PA-23-250 · S/N 27-4393Cancelled May 7, 2013 · Revoked, pending cancellation · Built 1969 · Smith Spencer LN725CABoeing 707-321 · S/N 17603Cancelled May 7, 2013 · Registration expired, pending cancellation · Built 1959 · General Air Services IncN738PQCessna 172N · S/N 17270134Cancelled May 7, 2013 · Registration expired, pending cancellation · Built 1977 · Xanadu Properties IncN73958Cessna 172N · S/N 17267764Cancelled May 7, 2013 · Registration expired, pending cancellation · Built 1976 · Natural Organic Matter IncN73SAPiper PA-28-140 · S/N 28-7125623Cancelled May 7, 2013 · Registration expired, pending cancellation · Built 1971 · Wanschek DanN83DWPiper PA-31-310 · S/N 31-7612104Cancelled May 7, 2013 · Exported to Colombia · Built 1976 · Check Mark Aviation LLCN6003JCessna A150L · S/N A1500303Cancelled May 6, 2013 · Exported to Paraguay · Built 1971 · Morena IncN721ZCPiper PA-31-310 · S/N 31-81Cancelled May 6, 2013 · Registration expired, pending cancellation · Built 1967 · Fernandez Robert
Back to Miami, FL