OpenAirDocs.org
Hampton, VA

Cancelled registrations · 104

Query with SQL
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 = 'HAMPTON'
  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.

N525NUUas USA TEMPEST · S/N 101017Cancelled Sep 25, 2025 · Nasa Langley Research CenterN527NUNasa Langley Research Center GLARF · S/N GLARF-5Cancelled Sep 24, 2025 · Nasa Langley Research CenterN528NUNasa Langley Research Center NASAGL 10 · S/N NASAGL10-1Cancelled Sep 24, 2025 · Nasa Langley Research CenterN529NUNasa Langley Research Center MARS ELECTRIC FLYER · S/N MEF-1Cancelled Sep 24, 2025 · Nasa Langley Research CenterN533NUUas USA TEMPEST · S/N 080715-1Cancelled Sep 24, 2025 · Nasa Langley Research CenterN547NUNasa Langley Research Center MERF-2 · S/N MERF-2Cancelled Sep 24, 2025 · Nasa Langley Research CenterN548NUNasa Langley Research Center TEMPEST · S/N 080715-3Cancelled Sep 24, 2025 · Nasa Langley Research CenterN554NUNasa Langley Research Center LA-8-1 · S/N 2685702Cancelled Sep 24, 2025 · Nasa Langley Research CenterN537NUAeryon Labs SKY RANGER · S/N SKR-000001-00 US7008060Cancelled Jun 18, 2025 · Nasa Langley Research CenterN524NADassault Falcon HU-25A20 · S/N 411-2110Cancelled May 23, 2025 · Exported to Canada · Nasa Langley Research CenterN555NUBlackswift Technologies S2 · S/N S20011Cancelled Mar 1, 2024 · Nasa Langley Research CenterN17140Cessna 150L · S/N 15073637Cancelled Dec 31, 2022 · Registration expired, pending cancellation · Built 1972 · Hassell James MN535NUDJI PHANTOM 3 ADVANCED · S/N P76DCG24A10440Cancelled Oct 1, 2022 · Registration expired, pending cancellation · Nasa Langley Research CenterN520NUPilot RC EXTRA 330 SC (40%) · S/N E1Cancelled Oct 31, 2020 · Registration expired, pending cancellation · Nasa Langley Research CenterN381NANasa Langley Research Center PIPER PAWNEE 33% · S/N P1Cancelled May 29, 2020 · Registration expired, pending cancellation · Nasa Langley Research CenterN383NANasa Langley Research Center CARBON CUB 40% · S/N C2Cancelled Dec 5, 2019 · First renewal notice · Nasa Langley Research CenterN384NANasa Langley Research Center CARBON CUB 40% · S/N C3Cancelled Dec 5, 2019 · First renewal notice · Nasa Langley Research CenterN512NUNasa Langley Research Center BLADE 350 QX · S/N NASA350 QX #1Cancelled Dec 5, 2019 · Nasa Langley Research CenterN8331WPiper PA-28-180 · S/N 28-2511Cancelled Nov 4, 2019 · Revoked, canceled · Built 1965 · Raines James GN105BTNasa Langley Research Center BAT-4 · S/N B4B010Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Nasa Langley Research CenterN741ZVDJI PHANTOM 2 · S/N PH645136111Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Virginia Space Grant ConsortiumN87880Douglas DC3 · S/N 43-48941Cancelled Sep 6, 2019 · Revoked, canceled · Flying Dragon Air IncN536NUDJI PHANTOM 3 PROFESSION · S/N G23A17409Cancelled Jul 26, 2019 · Registration expired, pending cancellation · Nasa Langley Reserach CenterN803RENasa Langley Research Center EDGE 540T 33% · S/N R3Cancelled May 6, 2019 · Registration expired, pending cancellation · Nasa Langley Research CenterN543NUDrone America DA-X8 · S/N DAX8-1Cancelled Mar 28, 2019 · Nasa Langley Research CenterN27050Piper J3L-65 · S/N 4324Cancelled Jan 28, 2019 · Revoked, canceled · Built 1940 · Peninsula AirportN524NUCarl Goldberg AN-FQM-117B · S/N MIGLTF-1Cancelled Dec 6, 2018 · Registration expired, pending cancellation · Nasa Langley Research CenterN525NADassault/Sud FAN JET FALCON SER F · S/N 447Cancelled Dec 6, 2018 · Registration expired, pending cancellation · National Aeronautics And Space AdministrationN526NUNasa Langley Research Center GLARF · S/N GLARF-3Cancelled Dec 6, 2018 · Registration expired, pending cancellation · Nasa Langley Research CenterN51003Fairchild M-62A · S/N 6253AECancelled Aug 23, 2018 · Revoked, canceled · Built 1943 · Tennis Bernard WN95221Piper PA-28-140 · S/N 28-25846Cancelled Jun 8, 2018 · Registration expired, pending cancellation · Built 1969 · Passarelli Joseph RN7137PPiper PA-24-250 · S/N 24-2302Cancelled Jan 23, 2018 · Registration expired, pending cancellation · Built 1960 · Peninsula Aeronautical Services IncN515NABoeing 737-130 · S/N 19437Cancelled Jan 17, 2018 · Registration expired, pending cancellation · National Aeronautics & Space AdminN690HXPena Anthony HX2 WASP · S/N 002Cancelled Jan 8, 2018 · Registration expired, pending cancellation · Built 2009 · Pena Anthony DN8372TCessna 175C · S/N 17557072Cancelled Sep 8, 2017 · Registration expired, pending cancellation · Built 1961 · Evans Robert BN2109WBeech C23 · S/N M-1432Cancelled Jun 14, 2017 · Registration expired, pending cancellation · Built 1973 · Snyder Jason EN1996RMasters Robin W KOLB MARK 3 · S/N M-1045Cancelled May 23, 2017 · Registration expired, pending cancellation · Masters RobinN2070QAutry William T PIETENPOL 001 · S/N 006Cancelled May 22, 2017 · Registration expired, pending cancellation · Built 1989 · Clark Richard BN517NUNasa Langley Research Center BEBOP DRONE #1 · S/N NASABD01Cancelled May 12, 2017 · Nasa Langley Research CenterN518NUNasa Langley Research Center BEBOP DRONE #2 · S/N NASABD02Cancelled May 12, 2017 · Nasa Langley Research CenterN519NUNasa Langley Research Center RTF X8 #1 · S/N NASAX801Cancelled May 12, 2017 · Nasa Langley Research CenterN525NUNasa Langley Research Center PROTEUS · S/N MARTI-1Cancelled Apr 13, 2017 · Nasa Langley Research CenterN8834BCessna 172 · S/N 36534Cancelled Dec 5, 2015 · Built 1958 · Nasa Langley Research CenterN9400BCessna 175 · S/N 55200Cancelled Dec 5, 2015 · Nasa Langley Research CenterN9804VCessna 172M · S/N 17264510Cancelled Oct 20, 2015 · Built 1974 · Nasa Langley Research CenterN339RJHalstead Richard J KR II · S/N RJH003Cancelled May 19, 2015 · Registration expired, pending cancellation · Evans Robert BN70811Eagles Perch NOLAN 51 HJ · S/N EP00025Cancelled May 19, 2015 · Registration expired, pending cancellation · Eagles Perch IncN6626RMalone Henry O HOWLAND H-2A · S/N 1Cancelled May 6, 2015 · Registration expired, pending cancellation · Built 1992 · Malone Henry ON723PParker Ralph S BABY GREAT LAKES · S/N 6601B-27-BCancelled Nov 17, 2014 · Registration expired, pending cancellation · Parker Ralph SN241JWWhite James D VELOCITY · S/N DM0178Cancelled Nov 4, 2013 · Registration expired, pending cancellation · Built 1995 · Ytico-Lev LLC
Back to Hampton, VA