Skip to content

Cancelled registrations · 151

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

N627ENTextron 208 · S/N 20800583Cancelled Feb 23, 2026 · Exported to Canada · Built 2016 · Minton Air LLC N66220Cessna 150M · S/N 15075928Cancelled Feb 23, 2024 · Exported to Greece · Shaaban Mohamed Elgeneidi Elsayed Aly N9471UCessna 150M · S/N 15078419Cancelled Feb 23, 2024 · Exported to Greece · Mg Aviation Support LLC N4770BCessna 152 · S/N 15283626Cancelled Oct 14, 2022 · Exported to Greece · Built 1979 · Mg Aviation Support LLC N6141CCessna T310R · S/N 310R1299Cancelled Jan 8, 2022 · Registration expired, pending cancellation · Built 1978 · Breneman William D N616HSRobinson Helicopter R44 II · S/N 10449Cancelled Dec 4, 2021 · Registration expired, pending cancellation · Built 2004 · Schwarz Henry E N102UTC-Astral BRAMOR RTK · S/N 074Cancelled Oct 30, 2021 · Registration expired, pending cancellation · Modern Technology Solutions Inc N47KZCharles E Lebeau COZY III · S/N 601Cancelled Aug 20, 2021 · Registration expired, pending cancellation · Lebeau Charles N5765HMooney M20J · S/N 24-1480Cancelled Mar 6, 2021 · Registration expired, pending cancellation · Built 1984 · Capital Sightseeing LLC N30984Piper J4A · S/N 41257Cancelled Jun 26, 2020 · Revoked, canceled · Built 1940 · Poe Richard S N46651Taylorcraft DC-65 · S/N 4980Cancelled Feb 28, 2020 · Revoked, canceled · Built 1943 · Lester Herbert S N22372Aeronca 50-C · S/N C3729Cancelled Jan 22, 2020 · Revoked, pending cancellation · Built 1939 · Ashburn Flying Service Inc N9818CNorth American SNJ-5 · S/N 90974Cancelled Nov 26, 2019 · Revoked, canceled · Coastal Aviation Corp N9808CNorth American SNJ-5 · S/N 43859Cancelled Sep 6, 2019 · Revoked, canceled · Coastal Aviation Corp N9815CNorth American SNJ-5 · S/N 43767Cancelled Sep 6, 2019 · Revoked, canceled · Coastal Aviation Corp N5194VNorth American SNJ-5 · S/N 84893Cancelled Aug 2, 2019 · Revoked, canceled · Coastal Aviation Corp N5196VNorth American SNJ-5 · S/N 91036Cancelled Aug 2, 2019 · Revoked, canceled · Coastal Aviation Corp N5197VNorth American SNJ-5 · S/N 84991Cancelled May 4, 2019 · Revoked, pending cancellation · Coastal Aviation Corp N69599Stinson AT-19 · S/N 294Cancelled May 4, 2019 · Revoked, canceled · Benedict Walter R N81266Fairchild 24R-9 · S/N W46166Cancelled Apr 17, 2019 · Revoked, canceled · Built 1946 · Muxo Edward N2090Bowles B-8M · S/N 1Cancelled Feb 8, 2019 · Revoked, pending cancellation · Built 1968 · Bowles Edgar L N202GGlaser-Dirks Flugzeugbau DG-200 · S/N 2-155/1739Cancelled Feb 6, 2019 · Registration expired, pending cancellation · Built 1985 · Edgell Jeffrey L N5119DWalker Richard R GULL 2000 · S/N 2003Cancelled Jan 18, 2019 · Registration expired, pending cancellation · Built 2003 · Foster Tommy L N2679KLuscombe 8A · S/N 5406Cancelled Aug 2, 2018 · Revoked, canceled · Built 1947 · Ashburn Flying Svc N1364BLuscombe 8E · S/N 5991Cancelled Jul 19, 2018 · Revoked, canceled · Built 1948 · Dossman Paul T N8344DSchwab Jack C RV-6A · S/N 60518Cancelled Jun 4, 2018 · Sale reported, canceled N531KGNorth American T-28C · S/N 140531Cancelled Mar 30, 2018 · Registration expired, pending cancellation · Built 1954 · Couch Jon N456LTTurner Lisa P PULSAR XP · S/N 463Cancelled Mar 2, 2018 · Registration expired, pending cancellation · Built 1997 · Discover Aviation Now N5261GCessna 305A · S/N 22691Cancelled Feb 8, 2018 · Registration expired, pending cancellation · Built 1951 · Butler Marine Aviation Inc N49921Cessna 152 · S/N 15281394Cancelled Jan 19, 2018 · Registration expired, pending cancellation · Built 1978 · Davidson James N7990CNorth American SNJ-5 · S/N 43966Cancelled Nov 21, 2017 · Revoked, canceled · Coastal Aviation Corp N919HADehavilland DHC-7-102 · S/N 40Cancelled Jun 15, 2017 · Registration expired, pending cancellation · Built 1981 · Aviation Enterprises 1990 Inc N12302Boeing 727-231 · S/N 19559Cancelled Jun 7, 2017 · Registration expired, pending cancellation · Built 1968 · National Aircraft Resale Association N765MBSix Chuter SR7 XL · S/N 99-2237-SR7XLCancelled Apr 18, 2017 · Registration expired, pending cancellation · Built 1999 · Blackwell Michael G N71180Luscombe 8A · S/N 2607Cancelled Feb 4, 2017 · Revoked, canceled · Built 1946 · Larsen Norman G N8159HNorth American SNJ-5 · S/N 52026Cancelled Feb 4, 2017 · Revoked, canceled · Coastal Aviation Corp N126CSCessna 172 · S/N 28387Cancelled Sep 12, 2016 · Revoked, canceled · Crawford William Douglas N702RSSaab-Scania SAAB 340B · S/N 340B-233Cancelled Jan 13, 2016 · Exported to Ukraine · Built 1991 · S3b Leasing LLC N5577ASchleicher KA 6 B · S/N 317Cancelled May 13, 2015 · Registration expired, pending cancellation · Built 1957 · Ten Bonden Wietse N400GZViking Air DHC-6-400 · S/N 904Cancelled Dec 8, 2014 · Exported to United Arab Emirates · Built 2014 · Ground Zero Solutions LLC N7759GCessna 172L · S/N 17259459Cancelled Nov 18, 2014 · Registration expired, pending cancellation · Built 1970 · Cage Charles N N117CZGiesler Bryan COZY · S/N 117Cancelled Nov 4, 2014 · Exported to Canada · Built 1989 · Renter Jason P N2346LBeech 23 · S/N M-178Cancelled Sep 19, 2014 · Registration expired, pending cancellation · Built 1963 · Bregstone Edward N7364GCessna 172K · S/N 17259064Cancelled Sep 3, 2014 · Sale reported, canceled · Built 1970 N400GZViking Air DHC-6-400 · S/N 890Cancelled May 27, 2014 · Exported to United Arab Emirates · Built 2014 · Ground Zero Solutions LLC N400GZViking Air DHC-6-400 · S/N 876Cancelled Dec 11, 2013 · Exported to United Arab Emirates · Built 2013 · Ground Zero Solutions LLC N4287RHankins Gary W CHALLENGER SPEC · S/N CH20190CW0611Cancelled Oct 29, 2013 · Registration expired, pending cancellation · Built 1991 · Hankins Gary W N99CSShedd Charles W PITTS S1D · S/N 198990S1C-S-TCancelled Sep 24, 2013 · Registration expired, pending cancellation · Shedd Charles W N5KNCessna P337H · S/N P3370333Cancelled Aug 15, 2013 · Registration expired, pending cancellation · Built 1979 · Gordon Bryan Jr N4412NBoeing B75N1 · S/N 75-3469Cancelled Aug 14, 2013 · Registration expired, pending cancellation · Built 1949 · Jeti Inc

Back to Alexandria, VA