Skip to content

Pompano Beach, FL

Cancelled registrations · 323

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 = 'POMPANO 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 = 'POMPANO 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 = 'POMPANO 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.

N980MSDaher TBM 700 · S/N 1662Cancelled Sep 15, 2026 · Exported to Brazil N980JRDaher TBM 700 · S/N 1660Cancelled Sep 3, 2026 · Exported to Brazil N52759Mooney M20J · S/N 24-3086Cancelled Apr 3, 2026 · Exported to Brazil · Alvor Aviation Inc N6757PPiper PA-24-250 · S/N 24-1886Cancelled Sep 7, 2024 · Sale reported, canceled · Built 1960 N9257SBeech C23 · S/N M-1753Cancelled Nov 23, 2023 · Registration expired, pending cancellation · Built 1975 · Aviation Holdings Group International LLC N15555Embraer EMB-145LR · S/N 145594Cancelled Oct 5, 2023 · Exported to Bahamas N204TCRaytheon HAWKER 800XP · S/N 258630Cancelled Sep 19, 2023 · Exported to Canada · Built 2003 · Sky Aviation Holdings LLC N225NVAirbus Industrie A320-214 · S/N 706Cancelled Mar 29, 2023 · Sale reported · Built 1997 N106TGPiper PA-31-350 · S/N 31-8052002Cancelled Mar 4, 2023 · Registration expired, pending cancellation · Tgaap LLC N41RKKesel Gregory H GK-3 · S/N 108Cancelled Jan 3, 2023 · Sale reported, canceled · Built 1991 N314ZXDJI INSPIRE 1 · S/N W130CD08030356Cancelled Dec 31, 2022 · Registration expired, pending cancellation · 3.14 Uav Systems LLC N4863VBellanca 17-30 · S/N 30113Cancelled Oct 1, 2022 · Registration expired, pending cancellation · Built 1968 · True Business Concepts LLC N522CWPiper PA-34-200 · S/N 34-7350127Cancelled Oct 1, 2022 · Registration expired, pending cancellation · True Business Concepts LLC N6432FCessna 150F · S/N 15063032Cancelled Oct 1, 2022 · Registration expired, pending cancellation · Built 1966 · True Business Concepts LLC N3896YBell 206B · S/N 3199Cancelled Sep 14, 2022 · Exported to Israel · Gaito David N461EABeech 400 · S/N RJ-61Cancelled Jun 4, 2022 · Registration expired, pending cancellation · Built 1989 · Atlantic Jet Partners LLC N300JZGulfstream American G-1159A · S/N 875Cancelled Apr 2, 2022 · Registration expired, pending cancellation · Built 1981 · Ujz LLC N550TMCessna 550 · S/N 550-0936Cancelled Jan 28, 2022 · Exported to Brazil · Built 2000 · A L G Trading Inc N9638RBeech B95 · S/N TD-319Cancelled Jan 24, 2022 · Second renewal notice · Built 1959 · Barton Steven W N644SCPiper PA-31P · S/N 31P-13Cancelled Jan 20, 2022 · Registration expired, pending cancellation · Built 1970 · Tornado Aircraft LLC N51EBBeech 400 · S/N RJ-28Cancelled Jan 8, 2022 · Registration expired, pending cancellation · Built 1987 · Sky Aviation Holdings LLC N3800BBeech F35 · S/N D-4069Cancelled Oct 23, 2021 · Registration expired, pending cancellation · Built 1955 · Tornado Aircraft LLC N5118KNavion NAVION A · S/N NAV-4-2018Cancelled Jul 3, 2021 · Registration expired, pending cancellation · Built 1950 · Tornado Aircraft LLC N327RMPiper PA-31-325 · S/N 31-7912019Cancelled Mar 30, 2021 · Exported to Bahamas · Built 1978 · Western Air International Co N405MCPiper PA-23-250 · S/N 27-7405314Cancelled Mar 30, 2021 · Exported to Bahamas · Western Air International Co N482TCPiper PA-31-350 · S/N 31-8252047Cancelled Mar 30, 2021 · Exported to Bahamas · Western Air International Co N809CEPiper PA-31-350 · S/N 31-8152053Cancelled Mar 30, 2021 · Exported to Bahamas · Built 1981 · Western Air International Co N491BTMitsubishi MU-300 · S/N A054 S ACancelled Mar 6, 2021 · Registration expired, pending cancellation · Built 1983 · Sky Aviation Holdings LLC N6376VCessna 172RG · S/N 172RG0642Cancelled Jan 23, 2021 · Built 1980 · Air Con LLC N918SSIsrael Aircraft Industries 1124 · S/N 263Cancelled Oct 31, 2020 · Registration expired, pending cancellation · Latin Flyer Inc N680JWAero Commander 680FL P · S/N 1497-15Cancelled Oct 3, 2020 · Registration expired, pending cancellation · Rpmcommander.Com LLC N9410DPiper PA-22-160 · S/N 22-6384Cancelled Sep 16, 2020 · Built 1958 · Duffy John E N38064Beech 76 · S/N ME-385Cancelled Aug 6, 2020 · Registration expired, pending cancellation · Built 1981 · Air Con LLC N552ESCessna 162 · S/N 16200234Cancelled May 29, 2020 · Registration expired, pending cancellation · Built 2013 · Nimno 552es LLC N6986FCessna 150F · S/N 15063586Cancelled Apr 3, 2020 · Registration expired, pending cancellation · Built 1966 · Leitch Mark William N3631KPiper PA-28-140 · S/N 28-23661Cancelled Feb 21, 2020 · Sale reported, pending cancellation · Built 1967 N301BKPiper PA 46-350P · S/N 4636407Cancelled Jan 3, 2020 · Sale reported, canceled · Built 2007 N2353ACessna T206H · S/N T20608746Cancelled Nov 29, 2019 · Registration expired, pending cancellation · Built 2007 · Barcoll Group Inc N236WHPiper PA-28-236 · S/N 28-8511012Cancelled Nov 29, 2019 · Registration expired, pending cancellation · Built 1985 · Morehead James B N726KBGabriel Ben-Or BABY LAKES · S/N 3636Cancelled Nov 29, 2019 · Registration expired, pending cancellation · Ben-Or Gabriel N6091ECessna 172N · S/N 17271989Cancelled Nov 4, 2019 · Registration expired, pending cancellation · Built 1978 · Volux Aviation LLC N2080PPiper PA-23 · S/N 23-667Cancelled Sep 6, 2019 · Registration expired, pending cancellation · True Business Concepts LLC N5668SBeech A23-19 · S/N MB-107Cancelled Apr 17, 2019 · Registration expired, pending cancellation · Built 1966 · Tornado Aircraft LLC N7589EChampion 7GC · S/N 7GC-23Cancelled Apr 16, 2019 · Sale reported, canceled · Built 1958 N7137RPiper PA-28-140 · S/N 28-21840Cancelled Jan 29, 2019 · Sale reported, canceled · Built 1966 N163MJDassault-Breguet FALCON 10 · S/N 163Cancelled Jan 28, 2019 · Registration expired, pending cancellation · Falcon Shares 113 LLC N7050ECessna 175A · S/N 56550Cancelled Jan 28, 2019 · Sale reported, canceled · Built 1960 N2QAFisher Flying Product/Crosbybc DAKOTA HAWK · S/N BCC-08Cancelled Jan 14, 2019 · Registration expired, pending cancellation · Built 2008 · Air Parts Sales Unlimited LLC N796SRProgressive Aerodyne SEAREY LSA · S/N 1060Cancelled Dec 28, 2018 · Sale reported, canceled N9214Thomas J Hankamp VANS RV4 · S/N 538Cancelled Dec 17, 2018 · Exported to Brazil · Built 2016 · Montezuma Marcelo

Back to Pompano Beach, FL