Skip to content

Delray Beach, FL

Cancelled registrations · 92

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

N57EJBritish Aerospace HS 125-700A · S/N 257056Cancelled Jan 16, 2024 · Exported to Mexico · Liberty Air Inc N13TSSouthard ALBEE SPORT · S/N 5Cancelled Feb 4, 2023 · Registration expired, pending cancellation · Built 1980 · Thomas Philip A N9833TPiper PA-38-112 · S/N 38-78A0219Cancelled Dec 31, 2022 · Registration expired, pending cancellation · Built 1978 · Thomas Philip A N76RLPiper PA-32-300 · S/N 32-7540024Cancelled Nov 5, 2022 · Registration expired, pending cancellation · Built 1974 · Tween Waters Tilloo Inc N2386BTemco GC-1B · S/N 3686Cancelled Sep 3, 2022 · Registration expired, pending cancellation · Built 1948 · South Florida Sport Aviation Inc N932DTTextron 208B · S/N 208B5691Cancelled Aug 10, 2022 · Exported to New Zealand · Delray Air LLC N5983YPiper PA-23-250 · S/N 27-3156Cancelled Feb 22, 2022 · Exported to Bahamas · Built 1966 · Lumley John J N913CWIsrael Aircraft Industries 1124 · S/N 332Cancelled Nov 30, 2021 · Exported to Mexico · Built 1981 · Liberty Air Inc N221TACirrus Design SR20 · S/N 1794Cancelled Oct 30, 2021 · Registration expired, pending cancellation · Built 2007 · Offshore Holdings LLC N3051PPiper PA-23 · S/N 23-963Cancelled Apr 3, 2021 · Registration expired, pending cancellation · Built 1957 · Lumley John N123LAGulfstream American G-1159A · S/N 336Cancelled Dec 21, 2020 · Exported to Mexico · Liberty Air Inc N6775VMooney M20C · S/N 700080Cancelled Dec 6, 2019 · Sale reported, canceled · Built 1970 N578HLDJI PHANTOM 3 PROFESSION · S/N P76DCD27013167Cancelled Dec 11, 2018 · Registration expired, pending cancellation · Lievonen Tarmo J N103MCTextron 172S · S/N 172S12004Cancelled Oct 30, 2018 · Exported to Czech Republic · Built 2017 · Air Dragonette LLC N99RWRobinson Helicopter R44 · S/N 0793Cancelled Apr 23, 2018 · Built 2000 · Atlas Aviation Lp N59KNorth American NA-265-60 · S/N 306-82Cancelled Mar 28, 2018 · Registration expired, pending cancellation · Built 1974 · Sabre 60 Jet Inc N8474XCessna 172C · S/N 17248974Cancelled Mar 7, 2018 · Registration expired, pending cancellation · Built 1961 · Severson Lucille N1910Boeing 727-23 · S/N 19385Cancelled Jan 11, 2018 · Registration expired, pending cancellation · Built 1966 · Sierra Aircraft Leasing LLC N71CCNorth American NA-265-60 · S/N 306-71Cancelled Jan 8, 2018 · Registration expired, pending cancellation · Built 1973 · Sabre 60 Jet Inc N7683ZPiper PA-25-235 · S/N 25-3835Cancelled Nov 21, 2017 · Revoked, canceled · Built 1966 · Two States Crop Dusters Inc N359WJNorth American NA-265-60 · S/N 306-1Cancelled Jun 15, 2017 · Registration expired, pending cancellation · Commercial Aviation Enterprises Inc N9088HCessna 172M · S/N 17265935Cancelled Jun 15, 2017 · Registration expired, pending cancellation · Built 1975 · Walker Craig T N338ASBeech B90 · S/N LJ493Cancelled May 23, 2017 · Registration expired, pending cancellation · Built 1970 · Cp Horizons Corp N13PAPiper PA-34-200T · S/N 34-7570070Cancelled Aug 10, 2016 · Exported to Bahamas · Built 1975 · Air Note LLC N9325UCessna 150M · S/N 15078274Cancelled Aug 18, 2015 · Exported to Brazil · Built 1976 · Alexandrov Martin K N416SBDehavilland DH 114 HERON 2X · S/N 14060Cancelled May 13, 2015 · Registration expired, pending cancellation · Built 1954 · Young Brett J N8269APiper PA-34-200T · S/N 34-8070362Cancelled Nov 26, 2014 · Registration expired, pending cancellation · Built 1980 · N8269a Inc.N1706Beech D50B · S/N DH-230Cancelled Sep 10, 2014 · Registration expired, pending cancellation · Built 1959 · Houston Jack W N34DCBeech 95-A55 · S/N TC-282Cancelled Oct 29, 2013 · Built 1962 · Array Paul S N21WMMenear PITTS S-1S · S/N 01Cancelled Oct 23, 2013 · Registration expired, pending cancellation · Built 1978 · Bernet Price M N13RDDebowes Ray R MOSQUITO · S/N 001Cancelled Sep 26, 2013 · Registration expired, pending cancellation · De Bowes Ray R N722APPiper PA-22-150 · S/N 22-6892Cancelled Aug 20, 2013 · Sale reported, canceled · Built 1959 N49600Boeing A75N1(PT17) · S/N 75-1962Cancelled Aug 5, 2013 · Sale reported, canceled · Built 1941 N516PBRobinson Helicopter R22 MARINER · S/N 2315MCancelled Jul 18, 2013 · Registration expired, pending cancellation · Built 1993 · Sky Aviation LLC N272DMMarkarian David G DRIFTER MU532 · S/N DR-0354Cancelled Jul 8, 2013 · Registration expired, pending cancellation · Built 1987 · Emmens Nelson N600GLNorth American NA-265-60 · S/N 306-24Cancelled Jul 8, 2013 · Registration expired, pending cancellation · Built 1968 · Commercial Aviation Enterprises Inc N5728YPiper PA-23-250 · S/N 27-2852Cancelled Jul 2, 2013 · Registration expired, pending cancellation · Built 1965 · Fernandez & Oliva N550RRBeech A36 · S/N E-822Cancelled Jun 4, 2013 · Registration expired, pending cancellation · Built 1976 · A L Aviation Inc N781ESPiper PA-23-250 · S/N 27-4673Cancelled May 9, 2013 · Registration expired, pending cancellation · Built 1971 · Andros Air Cargo N9174DCarris Edgar C C AVID FLYER · S/N 946Cancelled May 8, 2013 · Registration expired, pending cancellation · Built 2001 · Scherer Charles N5611YPiper PA-23-250 · S/N 27-2720Cancelled Apr 22, 2013 · Registration expired, pending cancellation · Built 1967 · Colly Interprizes Inc N5221CCessna T310R · S/N 310R1516Cancelled Mar 26, 2013 · Sale reported, canceled · Built 1978 N90640Piper PA-31-310 · S/N 31-237Cancelled Mar 18, 2013 · Sale reported, canceled · Built 1968 N8198EMooney M20A · S/N 1469Cancelled Feb 27, 2013 · Sale reported, canceled · Built 1959 N50ABDuplain Carol RV-6 · S/N 24184Cancelled Jan 23, 2013 · Exported to Canada · Built 1998 · Rv Flying Club Inc N4830JBeech V35 · S/N D-8333Cancelled Dec 4, 2012 · Second renewal notice · Built 1966 · Lotter Irving N321HKPiper PA-31-310 · S/N 31-7300920Cancelled Nov 6, 2012 · Registration expired, pending cancellation · Built 1972 · Andros Aircargo Inc N1213XMooney M20C · S/N 2616Cancelled Jun 12, 2012 · Registration expired, pending cancellation · Built 1963 · Jimenez Olga K N63HCCessna 340A · S/N 340A0719Cancelled Nov 24, 2009 · Exported to Bolivia · Commercial Aviation Enterprises Inc N29PBNorth American NA-265-60 · S/N 306-18Cancelled Nov 6, 2009 · Exported to Mexico · Built 1968 · Commercial Aviation Enterprises Inc

Back to Delray Beach, FL