Skip to content

Miami Beach, FL

Cancelled registrations · 136

Query with SQL

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 BEACH' ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

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 BEACH'
  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.

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 BEACH'
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N987AHCirrus Design SR22 · S/N 1277Cancelled Aug 31, 2026 · Exported to Estonia · Hartman Family Aviation Holdings LLC N448JMEurocopter AS 355N · S/N 5627Cancelled Dec 29, 2025 · Exported to Hungary · Built 1997 · Bessenyei Istvan N49BXHelms Richard LANCAIR IVP · S/N LIV-465Cancelled Dec 15, 2025 · Built 2005 · Nguyen Anh-Thu N63JKCessna 680 · S/N 680-0290Cancelled Feb 26, 2025 · Exported to Australia · Built 2011 · N63jk LLC N575WBBombardier BD-700-1A10 · S/N 9114Cancelled Mar 5, 2024 · Exported to Canada · Built 2002 · Global Next Generation LLC N80JEBell Textron Canada 407 · S/N 56375Cancelled Jan 22, 2024 · Exported to China · Pji Enterprises Inc N804RRAirbus Industrie A320-231 · S/N 113Cancelled Nov 30, 2023 · Firedancer Asset Holding I LLC N9456UCessna 150M · S/N 15078404Cancelled Nov 30, 2023 · Exported to Philippines · Built 1976 · Kowalski Vianna Marcio N6547PPiper PA-24-250 · S/N 24-1669Cancelled Apr 1, 2023 · Registration expired, pending cancellation · Built 1960 · Spada Anthony N3YECessna 172N · S/N 17271056Cancelled Jan 11, 2023 · Registration pending, canceled · Built 1978 N83BAIcon A5 · S/N 00051Cancelled Jan 10, 2022 · First renewal notice · Built 2018 · Cg 422 LLC N38799Piper J3C-65 · S/N 7276Cancelled Dec 18, 2019 · Revoked, pending cancellation · Built 1940 · Yoas E Jaxon N612PFDJI INSPIRE 1 · S/N W13DCH04040436Cancelled Mar 8, 2019 · Registration expired, pending cancellation · Uashot Aerial Filmwork Inc N7968ALockheed PV-1 · S/N 151515Cancelled Mar 2, 2019 · Revoked, pending cancellation · Jones Ben N847QKDJI PHANTOM 4 PRO+ · S/N 0AXCEB20A30740Cancelled Nov 6, 2018 · Kean Alexander L N6807CWelniak-Budde III M · S/N 146Cancelled May 31, 2018 · Sale reported, canceled · Built 1982 N5508ACurtiss Wright C-46A · S/N 4346979Cancelled May 8, 2018 · Revoked, pending cancellation · Lone Star Inc N3323Van Der Bunt B-8M · S/N VDB69Cancelled Apr 5, 2018 · Revoked, canceled · Built 1969 · Vanderbunt John A N5213DCessna 180A · S/N 50111Cancelled Apr 5, 2018 · Revoked, canceled · Built 1957 · Sanson Antonio R N991BWWilliams Bruce GLASAIR SPORTSMAN 2+ · S/N 7318Cancelled Mar 9, 2018 · Registration expired, pending cancellation · Built 2012 · Buonfante Paolo N135CUCessna 172K · S/N 17258515Cancelled Feb 26, 2018 · Registration pending, pending cancellation · Built 1969 N11265Cessna 150L · S/N 15075284Cancelled Jan 2, 2018 · Registration expired, pending cancellation · Built 1973 · Pizzi Olga E N7224CLockheed PV-2 · S/N 151233Cancelled Nov 21, 2017 · Revoked, canceled · Jones Ben T N245DLDiamond Aircraft Ind DA 40 NG · S/N 40.N260Cancelled May 10, 2017 · Exported to Japan · Built 2015 · Delta Lima Leasing LLC N3TBPiper PA-31P · S/N 31P-7300153Cancelled Apr 7, 2017 · Registration expired, pending cancellation · Built 1973 · Adventure Services LLC N8521UCessna 172F · S/N 17252421Cancelled Feb 4, 2017 · Revoked, canceled · Built 1964 · Dulberg Jack N N7096ZRobinson Helicopter R66 · S/N 0640Cancelled Sep 9, 2015 · Exported to Brazil · Built 2015 · Magtec Corp N155ARYakovlev YAK-55 · S/N 870403Cancelled May 20, 2015 · Registration expired, pending cancellation · Built 1987 · Warner Wesley D N5440GCessna 404 · S/N 404-0058Cancelled Jan 26, 2015 · Sale reported, canceled N350RSPiper PA-31-310 · S/N 31-372Cancelled Dec 22, 2014 · Registration expired, pending cancellation · Built 1969 · Starlite Corp N86KBBarnett Kenneth ROTORWAY RW-162F · S/N 6408Cancelled Dec 16, 2014 · Registration pending, canceled · Built 2007 N9455HCessna T182 · S/N 18267951Cancelled Nov 26, 2014 · Registration expired, pending cancellation · Built 1981 · Solid Gold Music Centers N25CBRepublic RC-3 · S/N 332Cancelled Nov 12, 2014 · Registration expired, pending cancellation · Nesic Eugene M N501AKLockheed 382G · S/N 4798Cancelled Oct 27, 2014 · Registration expired, pending cancellation · Built 1978 · Pan Aviation Inc N49FNDouglas DC3 · S/N 4179Cancelled Oct 14, 2014 · Registration expired, pending cancellation · Built 1942 · Batista Eleyio N172YBReims CESSNA FR172H · S/N 0294Cancelled Jun 26, 2014 · Exported to Czech Republic · Built 1972 · Bem Jan N8148ACessna 208 · S/N 20800548Cancelled Nov 22, 2013 · Exported to Brazil · Built 2013 · Magtec Corp N5859UPiper PA-28-140 · S/N 28-26690Cancelled Oct 29, 2013 · Registration expired, pending cancellation · Built 1970 · Wilson Timothy R N2969GPiper PA-23-250 · S/N 27-239Cancelled Oct 25, 2013 · Registration expired, pending cancellation · Built 1961 · Huntington Scott R DBA N901MEBem Jan MTE 1 · S/N 001Cancelled Sep 20, 2013 · Registration expired, pending cancellation · Built 1990 · Bem Jan N2032FPiper PA-22-108 · S/N 22-8233Cancelled Sep 16, 2013 · Registration expired, pending cancellation · Built 1961 · Browne Charles N62TGBeech 65-A80 · S/N LD-215Cancelled Sep 16, 2013 · Registration expired, pending cancellation · Built 1965 · Craig William N6595DCessna 172N · S/N 17272884Cancelled Sep 16, 2013 · Registration expired, pending cancellation · Built 1979 · Lee Gregory C N4305GMcculloch J-2 · S/N 015Cancelled Aug 19, 2013 · Sale reported, canceled · Built 1971 N5452GCessna 404 · S/N 404-0068Cancelled Aug 15, 2013 · Registration expired, pending cancellation · Built 1977 · Airworks Assoc Inc N255CBStol Amphibian RC-3 · S/N 2002Cancelled Aug 8, 2013 · Registration expired, pending cancellation · Built 1977 · Nesic Eugene M N6357KRepublic RC-3 · S/N 586Cancelled Aug 6, 2013 · Revoked, canceled · Built 1947 · Linday Bahamas Ltd N1886NCessna 120 · S/N 12130Cancelled Jul 30, 2013 · Registration expired, pending cancellation · Built 1947 · Alschuler Harry N N90810Beagle B.206 SERIES 1 · S/N 017Cancelled Jul 9, 2013 · Registration expired, pending cancellation · Built 1965 · Gavin Aviation N31AHPiper PA-31-310 · S/N 31-206Cancelled Jul 1, 2013 · Registration expired, pending cancellation · Built 1968 · Pastrana Andres

Back to Miami Beach, FL