Skip to content

Harrisonburg, VA

Cancelled registrations · 33

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 = 'VA' AND d.registrant_city = 'HARRISONBURG' 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 = 'VA' AND d.registrant_city = 'HARRISONBURG'
  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 = 'VA' AND d.registrant_city = 'HARRISONBURG'
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.

N1689VDJI AGRAS T40 · S/N 64TBL1X002002WCancelled Feb 23, 2026 · Sale reported, canceled N2399MPiper J3C-65 · S/N 17966Cancelled Jan 30, 2021 · Registration expired, pending cancellation · Earlys Cycle Center Inc N758EBDJI PHANTOM 3 PROFESSION · S/N P76DCH26A21490Cancelled Nov 4, 2019 · Registration expired, pending cancellation · Bachand Austin J N769GNDJI PHANTOM 2 VISION + · S/N PH645511764Cancelled Nov 4, 2019 · Registration expired, pending cancellation · Nielsen Builders Inc N644JRDJI PHANTOM 2 VISION + · S/N PH645239577Cancelled May 6, 2019 · Registration expired, pending cancellation · Rockingham County N3426QCessna 320E · S/N 320E0026Cancelled Apr 30, 2018 · Registration expired, pending cancellation · Built 1966 · Roussel George A N232AWBuckeye DREAM MACHINE · S/N 3496Cancelled Feb 12, 2018 · Registration expired, pending cancellation · Kvitko Daniel N5695DSix Chuter SKYE RYDER · S/N 98-1957-SR2C1Cancelled Jan 25, 2018 · Registration expired, pending cancellation · Built 1998 · Helmuth James E N27809Piper J4A · S/N 41025Cancelled Nov 22, 2017 · Revoked, canceled · Built 1940 · Myers Nelson L N52085Boeing A75N1(PT17) · S/N 75-7217Cancelled Oct 29, 2014 · Registration expired, pending cancellation · Neff Alex M N1814HCessna 310C · S/N 35914Cancelled Sep 10, 2014 · Registration expired, pending cancellation · Built 1959 · Miller Glenn E N94GMKellems Mike A KELLEMS KR-1 · S/N 001Cancelled Nov 7, 2013 · Registration expired, pending cancellation · Built 1994 · Charity Foundation Inc N155BBBeech B-55 · S/N TC-841Cancelled Jul 11, 2013 · Sale reported, canceled · Built 1965 N8211NPiper PA-28-140 · S/N 28-25414Cancelled May 14, 2013 · Registration expired, pending cancellation · Built 1969 · Wheelbarger Claude E N111QABeech 95-A55 · S/N TC-293Cancelled Apr 9, 2013 · Sale reported, canceled · Built 1962 N2314YCessna 177 · S/N 17700114Cancelled Sep 4, 2012 · Registration expired, pending cancellation · Built 1967 · Augsburger Michael D N7502LCameron Balloons US V-77 · S/N 5760Cancelled Jun 2, 2004 · Triennial form not returned · Built 1992 · Detrich Robert E N1EJCessna 310Q · S/N 310Q0750Cancelled Jan 6, 2003 · Second triennial mailing, no response · Built 1973 · Miller Glenn E DBA N60648Cessna 150J · S/N 15070476Cancelled Apr 2, 1996 · Triennial form not returned · Dofflemyer Donald L N15063Balloon Works FIREFLY 7-B · S/N 11178Cancelled Apr 15, 1992 · Heatwole Linda C N4291DBeech G35 · S/N D-4535Cancelled Oct 30, 1980 · Built 1956 · Einarsen Robert Howard Sr N58186Hughes Helicopters HUGHES 369D · S/N 280259DCancelled Mar 12, 1980 · Exported to Canada · Neff Bill V N6705UMooney M20C · S/N 2437Cancelled May 25, 1976 · Schlabach Ernest Dr N44568Beech C18S · S/N 7041Cancelled Feb 12, 1971 · K & K Aircraft Inc N2890MPiper PA-12 · S/N 12-1416Cancelled Mar 7, 1968 · Exported to Canada · Shenk Robert D N99500Ercoupe 415-C · S/N 2123Cancelled Feb 15, 1957 · Built 1946 · Early O K N46310Piper J3L-65 · S/N G-203Cancelled Nov 18, 1955 · Dan Hartman Airways Inc N836CStinson 108-3 · S/N 108-3836Cancelled Nov 17, 1955 · Dan Hartman Airways Inc N98003Piper J3C-65 · S/N 18133Cancelled May 12, 1949 · Hartman Dan N92619Piper J3C-65 · S/N 16984Cancelled Apr 29, 1949 · Rhodes Lloyd B N36180Taylorcraft DC-65 · S/N 4116Cancelled Jan 5, 1949 · Myers Nelson N3603HEngineering & Research 415-C · S/N 4228Cancelled Dec 23, 1947 · Built 1946 · Harrisonburg Aero Inc N99883Erco 415-C · S/N 2506Cancelled Sep 24, 1947 · Showker J Richard

Back to Harrisonburg, VA