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.

N94250Convair 240 · S/N 107Cancelled Mar 20, 2013 · Sale reported, canceled · Built 1948N5022FHofmann Matthew A MONERAI-S · S/N 0028Cancelled Mar 19, 2013 · Registration expired, pending cancellation · Hofmann Matthew AN60FBBeech A60 · S/N P-159Cancelled Mar 18, 2013 · Sale reported, canceled · Built 1970N9044YPiper PA-31-310 · S/N 31-64Cancelled Mar 18, 2013 · Sale reported, canceled · Built 1967N9061HDouglas DC3C-S1C3G · S/N 19737Cancelled Mar 18, 2013 · Sale reported, canceled · Built 1943N90801Douglas DC-7C · S/N 45113Cancelled Mar 18, 2013 · Sale reported, canceled · Built 1956N9208YPiper PA-31-310 · S/N 31-271Cancelled Mar 18, 2013 · Sale reported, canceled · Built 1968N922LDouglas DC-9-32 · S/N 47108Cancelled Mar 18, 2013 · Sale reported, canceled · Built 1968N999QMPiper PA-31-325 · S/N 31-7912012Cancelled Mar 18, 2013 · Registration pending, canceled · Built 1978N271ATAirbus A320-212 · S/N 420Cancelled Mar 15, 2013 · Aeroturbine IncN4527TPiper PA-28R-200 · S/N 28R-7235079Cancelled Mar 11, 2013 · Registration expired, pending cancellation · Built 1972 · Korman Investments IncN8824LPiper PA-25-235 · S/N 25-5332Cancelled Mar 11, 2013 · Sale reported, canceled · Built 1971N883EBeech 65-88 · S/N LP-7Cancelled Mar 11, 2013 · Sale reported, canceled · Built 1965N9015XBeech 65-B80 · S/N LD-317Cancelled Mar 11, 2013 · Sale reported, canceled · Built 1966N211DACessna 150L · S/N 15073829Cancelled Mar 8, 2013 · Second renewal notice · Built 1972 · Rossie Pedro TN2222UPiper PA-34-200T · S/N 34-7970154Cancelled Mar 7, 2013 · Sale reported, pending cancellation · Built 1979N4090LCessna 402B · S/N 402B0337Cancelled Mar 7, 2013 · Registration expired, pending cancellation · Built 1973 · C F L Charter CorpN59GDouglas DC3-G202A · S/N 4988Cancelled Mar 7, 2013 · Sale reported, canceled · Built 1942N852CDouglas DC3C · S/N 9471Cancelled Mar 7, 2013 · Sale reported, canceledN2025XCessna 208B · S/N 208B2348Cancelled Mar 4, 2013 · Exported to Kenya · Built 2012 · Africair IncN777RXPiper PA-23-250 · S/N 27-4728Cancelled Feb 28, 2013 · Exported to Guatemala · Built 1971 · International Jet Center IncN12060Wsk-Pzl Meilec PZL M18B · S/N 1Z026-17Cancelled Feb 27, 2013 · Sale reported, canceled · Built 1996N8054HFink Charles B MONERAI-S · S/N 0089Cancelled Feb 27, 2013 · Sale reported, canceled · Built 1981N8061YGeneral Dynamics 240-27 · S/N 347Cancelled Feb 27, 2013 · Sale reported, canceledN809LAero Commander 680FL · S/N 1457-84Cancelled Feb 27, 2013 · Sale reported, canceled · Built 1965N8139ZCessna 210-5(205) · S/N 2050139Cancelled Feb 27, 2013 · Sale reported, canceled · Built 1962N8281KGulfstream-Schweizer A/C GULFSTREAM AM G-164B · S/N 645-BCancelled Feb 27, 2013 · Sale reported, canceled · Built 1979N8287KGulfstream-Schweizer A/C GULFSTREAM AM G-164B · S/N 647-BCancelled Feb 27, 2013 · Sale reported, canceled · Built 1980N8STPiper PA-31-350 · S/N 31-7552097Cancelled Feb 27, 2013 · Sale reported, canceled · Built 1975N758NMCessna R172K · S/N R1723229Cancelled Feb 26, 2013 · Sale reported, canceled · Built 1979N77CCCurtiss Wright C-46F · S/N 22382Cancelled Feb 26, 2013 · Sale reported, canceled · Built 1945N33FBCessna 401 · S/N 401-0028Cancelled Feb 25, 2013 · Registration expired, pending cancellation · Built 1966 · Ruiz Ruben JN6WXWatts Henry F FRANKLIN SPECIAL · S/N HW-6Cancelled Feb 25, 2013 · Registration expired, pending cancellation · Watts Henry FN2881BBell 47J · S/N 1560Cancelled Feb 21, 2013 · Registration expired, pending cancellation · Built 1957 · Foster C TomN58091Douglas B-23 · S/N 2714Cancelled Feb 21, 2013 · Revoked, canceled · Built 1940 · Lorenair IncN75019Beech RC-45J · S/N 023789Cancelled Feb 21, 2013 · Sale reported, canceledN75431Douglas DC3C · S/N 4489Cancelled Feb 21, 2013 · Sale reported, canceled · Built 1942N75TDouglas DC3C · S/N 12726Cancelled Feb 21, 2013 · Sale reported, canceled · Built 1942N357JRBeech 65-90 · S/N LJ-5Cancelled Feb 20, 2013 · Sale reported, canceled · Built 1964N709GAero Commander 680-E · S/N 680E-865-82Cancelled Feb 20, 2013 · Sale reported, canceled · Built 1960N72522Douglas DC-6B · S/N 44697Cancelled Feb 20, 2013 · Sale reported, canceled · Built 1955N2212SBeech SNB-5 · S/N 23836Cancelled Feb 19, 2013 · Sale reported, pending cancellation · Built 1951N8277ZBoeing 727-23 · S/N 19132Cancelled Feb 14, 2013 · Sale reported, canceledN358TNPiper PA-31-350 · S/N 31-7552032Cancelled Feb 13, 2013 · Sale reported, canceled · Built 1975N6313ZCessna TU206G · S/N U20606229Cancelled Feb 13, 2013 · Sale reported, canceled · Built 1981N642BBeech D18S · S/N A-467Cancelled Feb 13, 2013 · Sale reported, canceled · Built 1948N6491LPiper PA-31-300 · S/N 31-455Cancelled Feb 13, 2013 · Sale reported, canceled · Built 1969N6750NCessna T210N · S/N 21063152Cancelled Feb 13, 2013 · Sale reported, canceled · Built 1978N6828YPiper PA-23-250 · S/N 27-4168Cancelled Feb 13, 2013 · Sale reported, canceled · Built 1969N6922YPiper PA-23-250 · S/N 27-4278Cancelled Feb 13, 2013 · Sale reported, canceled · Built 1969
Back to Miami, FL