Skip to content

Cancelled registrations · 24

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

N691DADiamond Aircraft Industries GM DA 62 · S/N 62.093Cancelled Mar 6, 2023 · Exported to Canada · Built 2018 · Sunmed Air LLC N859UCMark R Contarino PH D NAVIATORHL · S/N 20180615Cancelled Apr 2, 2022 · Registration expired, pending cancellation · Contarino Mark R N52583Boeing A75N1(PT17) · S/N 75-1370Cancelled May 5, 2020 · Revoked, pending cancellation · Built 1941 · Greer J D N66562Boeing E75 · S/N 758150Cancelled Mar 20, 2020 · Revoked, canceled · Built 1943 · Greer J D N144ZXQuicksilver SPORT 2S · S/N 0162Cancelled Jan 31, 2020 · Registration expired, pending cancellation · Built 2007 · Cadmus David L N4104RPiper PA-32-300 · S/N 32-40423Cancelled Dec 4, 2019 · First renewal notice · Built 1968 · Desselle Dale B N1159CQuicksilver MXLSPRINT II · S/N 000815Cancelled Nov 1, 2019 · Registration expired, pending cancellation · Cadmus David L N437AFQuicksilver MXLII SPRINT · S/N 000759Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Cadmus David L N61593Boeing PT-17 · S/N 754554Cancelled Nov 21, 2017 · Revoked, canceled · Built 1943 · Greer J D N483BBiggins James E MINI 500 HELI KIT · S/N 83Cancelled Sep 18, 2017 · Registration expired, pending cancellation · Built 1996 · Biggins James E N9233JPiper PA-28-180 · S/N 28-3306Cancelled Jun 1, 2017 · Registration expired, pending cancellation · Built 1966 · Kiessel William D N9100JPiper PA-28-180 · S/N 28-3142Cancelled Oct 29, 2013 · Exported to Brazil · Built 1966 · Granville Group LLC N197MBFredrick Brian PHANTOM · S/N 001Cancelled May 3, 2013 · Registration expired, pending cancellation · Fredrick Brian L N24586Beech A24R · S/N MC-131Cancelled Apr 15, 2013 · Registration expired, pending cancellation · Built 1972 · Croley James H N2767JCessna A150M · S/N A1500592Cancelled Sep 25, 2012 · Exported to Venezuela · Built 1975 · Brady Scott T N1236KLuscombe 8E · S/N 3963Cancelled Jun 12, 2012 · Registration expired, pending cancellation · Built 1946 · Mcclanathan Donald E N8620TCessna 182C · S/N 52520Cancelled May 3, 2010 · Exported to Ecuador · Built 1960 · Guthrie Gary S N9UTPiper PA-31-325 · S/N 31-7912043Cancelled Jan 21, 2003 · Exported to Mexico · Built 1979 · Brown James C Jr N4205Mooney M20 · S/N 1007Cancelled Jul 29, 1993 · Triennial form not returned · Roman Samuel L N3814UCessna 336 · S/N 336-0114Cancelled May 13, 1983 · Built 1975 · Manatee County Mosquito Control N338PBeech D18S · S/N A-290Cancelled Jul 28, 1973 · Exported to France · Southern Aircraft & Flight Equipt Co N66441Boeing B75N1 · S/N 757174Cancelled Sep 24, 1970 · Built 1943 · Greer J D N1035EAeronca 7AC · S/N 7AC-4586Cancelled Jan 24, 1951 · Thompson Theodore N788KWaco BSO · S/N A-155Cancelled Apr 29, 1948 · Built 1929 · Greer James D

Back to Palmetto, FL