Skip to content

Cancelled registrations · 35

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 = 'MD' AND d.registrant_city = 'SALISBURY' 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 = 'MD' AND d.registrant_city = 'SALISBURY'
  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 = 'MD' AND d.registrant_city = 'SALISBURY'
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.

N290MCBeech E-90 · S/N LW-206Cancelled Aug 23, 2024 · Salisbury-Wicomico Economic Development Inc N734UGCessna 172N · S/N 17269120Cancelled May 24, 2023 · Built 1977 · Bay Land Aviation Inc N6574QAlon A2 · S/N A-74Cancelled Feb 3, 2020 · Registration expired, pending cancellation · Built 1965 · Collier Charles Edward Sr N98235Piper J3C-65 · S/N 18405Cancelled Sep 6, 2019 · Revoked, canceled · Built 1946 · Rodman William C N8685GCessna 150F · S/N 15062785Cancelled Jul 10, 2019 · Registration expired, pending cancellation · Built 1966 · Skarbek Roman Alexander N7970DBeech H35 · S/N D-5240Cancelled May 4, 2019 · Revoked, canceled · Built 1957 · Rodman William C Ta N707TRRatliff Thomas H HUMMEL BIRD · S/N 1Cancelled Jan 23, 2018 · Registration expired, pending cancellation · Built 2005 · Ratliff Thomas H N16ZEGrumman HU 16E · S/N 2124Cancelled Jan 11, 2018 · Registration expired, pending cancellation · Conroy Albatross Inc N2653EAir Trikes EAGLE · S/N 102805Cancelled Jul 6, 2017 · Registration expired, pending cancellation · Built 2005 · Green Edward H II N7DXJohnson HP-11A · S/N 56Cancelled Jun 11, 2013 · Registration expired, pending cancellation · Built 195 · Crossett Richard M N80EFFarris Elmer JR ACRO SPORT-II · S/N 152Cancelled May 30, 2013 · Registration expired, pending cancellation · Built 1980 · Payne Charles J N20SGPiper PA-23-250 · S/N 27-2240Cancelled Apr 11, 2013 · Registration expired, pending cancellation · Built 1962 · Wood Aviation Inc N2651PPiper PA-22-150 · S/N 22-2991Cancelled Mar 7, 2013 · Sale reported, pending cancellation · Built 1955 N16CAGrumman HU 16A · S/N A4-77Cancelled Jan 31, 2013 · Registration expired, pending cancellation · Built 1951 · Conroy Albatross Inc N69945Cessna 310Q · S/N 310Q1036Cancelled Mar 1, 2002 · Triennial form not returned · Built 1974 · Bay Land Aviation Inc N36444Piper AEROSTAR 601P · S/N 61P08438163444Cancelled Feb 16, 1996 · Triennial form not returned · K & L Microwave Inc N796HAShort Bros SD3-30 200 · S/N SH3014Cancelled Nov 9, 1991 · Triennial form not returned · Henson Aviation Inc N234JPiper PA-31-350 · S/N 317952021Cancelled Oct 9, 1991 · Bay Land Aviation Inc N8473ZCessna 210-5(205) · S/N 2050473Cancelled Feb 20, 1991 · Exported to South Africa · Nolan Michael W N6207LAmerican AA-1B · S/N AA1B-0007Cancelled Jun 20, 1984 · Downing Gil R N2055LBeech B24R · S/N MC438Cancelled Oct 1, 1982 · Built 1976 · Robinson Hugh H N8970LGrumman American Avn. AA-1B · S/N AA1B-0420Cancelled Oct 15, 1981 · Bay Land Aviation Inc N6583WPiper PA-28-140 · S/N 28-20664Cancelled May 7, 1981 · Bennett Howard W Jr N7173VMooney M20C · S/N 20-0045Cancelled Sep 8, 1980 · Pezzetti Henry D N9803WPiper PA-28-140 · S/N 28-23300Cancelled Jul 29, 1977 · Rosen Concrete Works N23XYBeech E18S · S/N BA118Cancelled Sep 10, 1975 · Stoltzfus Omar N7448Vickers VISCOUNT 745 · S/N 204Cancelled May 19, 1975 · Exported to Ecuador · Viscount Intl Corp N7440Vickers VISCOUNT 797 · S/N 138Cancelled Dec 23, 1974 · Exported to Colombia · Viscount International Corp N51800Beech C18S · S/N 4189Cancelled Mar 16, 1971 · Goldman Samuel M N4438MPiper PA-12 · S/N 12-3391Cancelled Sep 20, 1957 · Ennis Fred E N61551Cessna T-50 · S/N 5811Cancelled Jan 20, 1956 · Vickers John A N54374Douglas DC3C-S1C3G · S/N 6177Cancelled Oct 25, 1954 · Adkins Fred P N2515HEngineering & Research ERCOUPE 415-C · S/N 3140Cancelled Apr 24, 1950 · Built 1946 · Airfields Operating Corp N79020Douglas C-47B · S/N 26823Cancelled Jul 9, 1948 · Exported to Brazil · Adkins Fred P N2482HEngineering & Research ERCOUPE 415-C · S/N 3107Cancelled Oct 31, 1947 · Airfields Operating Corp

Back to Salisbury, MD