Skip to content

Cancelled registrations · 29

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 = 'NC' AND d.registrant_city = 'MORGANTON' 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 = 'NC' AND d.registrant_city = 'MORGANTON'
  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 = 'NC' AND d.registrant_city = 'MORGANTON'
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.

N27USPiccard AX-6 · S/N 627Cancelled Oct 21, 2023 · Revoked, canceled · Built 1972 · Aerostat Odysseys Inc N361VXVX Aerospace Holdings DASH X · S/N VX-DASHX-003Cancelled Apr 26, 2023 · Vx Aerospace Holdings Inc N389TFVX Aerospace Holdings DASH X · S/N VX-DASHX-002Cancelled Apr 26, 2023 · Vx Aerospace Holdings Inc N563VXVX Aerospace Holdings DASH X · S/N VX-DASHX-005Cancelled Apr 26, 2023 · Vx Aerospace Holdings Inc N4805PPiper PA-23-250 · S/N 27-369Cancelled Sep 9, 2022 · Sale reported, canceled · Built 1961 N99XDAir Borne Australia EDGE X · S/N 582-382Cancelled Mar 5, 2022 · Registration expired, pending cancellation · Morgan Ernest W N2948LMooney M20C · S/N 670082Cancelled Oct 6, 2021 · Built 1967 · Clark Stewart B N341THHiatt Philip D PMVP-2 · S/N 001Cancelled Jan 9, 2021 · Registration expired, pending cancellation · Hiatt Philip N6568VBellanca 17-30 · S/N 30249Cancelled Dec 8, 2020 · Registration expired, pending cancellation · Built 1969 · Ranmac Inc N389WTVX Aerospace Holdings DASH X · S/N VX-DASHX-001Cancelled May 5, 2020 · Vx Aerospace Holdings Inc N820ZXVX Aerospace Holdings DASH X · S/N VX-DASHX-004Cancelled May 5, 2020 · Vx Aerospace Holdings Inc N750CStinson 108-3 · S/N 108-3750Cancelled Jan 9, 2019 · Registration pending, canceled · Built 1947 N426KSShell John SUPER SIX · S/N JS-001Cancelled Mar 14, 2018 · Registration expired, pending cancellation · Built 2010 · Shell John H Sr N65464Cessna 152 · S/N 15281567Cancelled Jan 8, 2018 · Registration expired, pending cancellation · Built 1978 · Foothills Regional Flying Club Inc N3440APiper PA-22-135 · S/N 22-1708Cancelled Jan 4, 2018 · Registration expired, pending cancellation · Built 1953 · Skillen Robert S N1767TPiper PA-28-140 · S/N 28-7125086Cancelled Jan 2, 2018 · Registration expired, pending cancellation · Built 1970 · Aloft LLC N2553APiper PA-38-112 · S/N 38-78A0754Cancelled Mar 19, 2015 · Registration expired, pending cancellation · Built 1978 · Western Carolina Aviation Inc N2057BWatrous Mitchell L JR CHALLENGER 2 PLACE · S/N 0867Cancelled Aug 22, 2013 · Sale reported, canceled · Built 1994 N91065Shell J H/Simone E DR-1 (TRI-WING) · S/N 1823Cancelled Mar 27, 2002 · Exported to New Zealand · Built 2001 · Shell John H N2160FWooldridge Harry SIEMENS SCHUKERT D4 · S/N HW-003Cancelled Apr 24, 2001 · Exported to New Zealand N3187GNorth American SNJ-5 · S/N 52022Cancelled Sep 21, 2000 · Triennial form not returned · Shell Keith E N115DBBrown David S SR VANS-BROWN RV-3 · S/N 11049Cancelled Mar 29, 1995 · Triennial form not returned · Brown David S Sr N9362TPiper PA-38-112 · S/N 38-78A0070Cancelled Nov 9, 1982 · Registration revoked · Built 1978 · Western Carolina Aviation Inc N8638WPiper PA-28-235 · S/N 28-10154Cancelled Feb 29, 1972 · Johnson Thomas G Jr N1622GChampion 7KCAB · S/N 125Cancelled Oct 7, 1971 · Built 1968 · Sprinkle Benjamin Franklin III N4960KRyan NAVION A · S/N NAV-4-1960Cancelled Feb 18, 1957 · Armentrout Russell E/ Power Equipment Co N93849Ercoupe 415-C · S/N 1172Cancelled Feb 27, 1956 · Built 1946 · Morganton Flying Club Inc N85746Aeronca 7AC · S/N 7AC-4495Cancelled Mar 28, 1949 · Community Aviation Corporation N5198American Eagle 101 · S/N 155Cancelled Feb 16, 1933 · Morgantown Aviation Club

Back to Morganton, NC