Skip to content

Cancelled registrations · 38

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

N901CTDiamond Aircraft Ind DA20-C1 · S/N C0101Cancelled Jan 5, 2026 · Built 2000 · Roberts T Eric N853VMMichael W Shearer EINDECKER EIII · S/N 021413Cancelled Nov 8, 2025 · Sale reported, canceled · Built 2018 N14282Piper PA-23-250 · S/N 27-4845Cancelled Feb 24, 2022 · Registration expired, pending cancellation · Built 1972 · Flight Inc N5268DCessna 172N · S/N 17272485Cancelled Dec 8, 2020 · Registration expired, pending cancellation · Built 1979 · Flycarolina LLC N983JSPhantom Aeronautics PHANTOM X-1 · S/N 031805005Cancelled Oct 3, 2020 · Registration expired, pending cancellation · Sebastian Justin E N9430FHughes 269B · S/N 0180Cancelled Sep 27, 2017 · Registration expired, pending cancellation · North Carolina Helicopters Inc N3052LCessna 310J · S/N 310J0052Cancelled Sep 29, 2014 · Registration expired, pending cancellation · Built 1965 · Carolina Safety Associates Inc N619RWsk-Pzl-Mielec TS-11 ISKRA · S/N 1H0619Cancelled Sep 20, 2013 · Registration expired, pending cancellation · Ts-11 Corp N43157Piper PA-28-151 · S/N 28-7415434Cancelled Jul 8, 2013 · Exported to Colombia · Built 1974 · Flight Inc N8860FHughes 269A · S/N 63-0227Cancelled May 15, 2013 · Registration expired, pending cancellation · Built 1963 · Kelso Herbert R N3663RPiper PA-28-180 · S/N 28-5767Cancelled Apr 30, 2013 · Exported to Colombia · Built 1970 · Flight Inc N1337MWhite John R JR ACE MODEL E · S/N 325Cancelled Mar 26, 2013 · Sale reported, canceled · Built 1982 N25066Piper J3C-65 · S/N 3637Cancelled Sep 10, 2012 · Registration expired, pending cancellation · Built 1939 · Smith Clinton D N5911GCessna 150K · S/N 15071411Cancelled Jun 15, 2011 · Built 1969 · Stanley Aero Club N2424VCessna 140 · S/N 14671Cancelled Dec 11, 2000 · Triennial form not returned · Barrett Brian T N347GBeech H-18 · S/N BA654Cancelled Apr 10, 1995 · Triennial form not returned · Piedmont Air Cargo Inc N9378NPiper PA-28R-200 · S/N 28R35087Cancelled Mar 27, 1991 · Triennial form not returned · Sexton Janitorial Systems Inc N78TWBeech B-60 · S/N P445Cancelled Feb 6, 1991 · Triennial form not returned · Walsh Maurice J III N4846SUltra Flight TIERRA II · S/N 3449761Cancelled Jul 19, 1984 · Built 1983 · Ultra Flight Corp N92608Cessna 182N · S/N 18260282Cancelled Dec 17, 1981 · Moore Roy L N6970DPiper PA-18A 150 · S/N 18-5495Cancelled Apr 1, 1976 · Mccords Aerial Patrol Systems Inc N6545FCessna 150F · S/N 15063145Cancelled May 9, 1975 · Mccords Aero Service Inc N87963Piper J3C-65 · S/N 15581Cancelled Dec 15, 1971 · Built 1946 · Curry William F N38005Piper J3C-65 · S/N 6754Cancelled Sep 25, 1971 · Built 1941 · Phillips C M N65906Waco UPF-7 · S/N 5573Cancelled Feb 3, 1971 · Mccord Aero Svc N411ZBeech D18S · S/N A-832Cancelled Nov 14, 1967 · Built 1952 · Airlife Inc & Gastonia Aviation Service Inc N7721ECessna 150 · S/N 17521Cancelled May 24, 1965 · Mccords Aero Service N5616CCessna 140A · S/N 15549Cancelled May 22, 1965 · Mccord Aero Service N52796Convair BT-13A · S/N 5578Cancelled May 20, 1965 · Moss William C N15119Stinson SR-6A · S/N 9610Cancelled Feb 17, 1956 · Martin Flying Service Inc N46534Aeronca 0-58B · S/N 058B-3842Cancelled Nov 18, 1955 · Cathey Harry V N41102Piper J3L · S/N 7761Cancelled Jan 4, 1949 · Martin William L N24982Piper J3F-60 · S/N 3577Cancelled Sep 27, 1948 · Built 1939 · Martin W L DBA Martin Flying School N28434Luscombe 8C · S/N 1301Cancelled Jul 28, 1948 · Built 1940 · Quickel John Cephas N7787HPiper PA-12 · S/N 12-685Cancelled Jan 3, 1947 · Chambers Claude H N38906Monocoupe 90AF · S/N A-829Cancelled May 1, 1942 · Stewart W C N29220Aeronca 65-TL · S/N L2720TCancelled Sep 29, 1940 · Built 1940 · Patton Gilbert Smith N22170Aeronca 50-C · S/N C-2729Cancelled May 20, 1940 · Patton Gilbert S

Back to Gastonia, NC