Skip to content

Cancelled registrations · 79

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

N1172YCessna 150B · S/N 15059572Cancelled Jan 17, 2026 · Sale reported, canceled N1QUCessna 414A · S/N 414A0640Cancelled Mar 2, 2024 · Registration pending, canceled · Built 1981 N821VBVan Batavia Steven R RV8 · S/N 83028Cancelled Jan 12, 2023 · Exported to Canada · Built 2011 · Dutkus Ian S N63673Cessna 150M · S/N 15077474Cancelled Jul 2, 2022 · Registration expired, pending cancellation · Built 1975 · Liberty University School Of Aeronautics N16JKDJI MAVIC PRO · S/N 08QDE2801206E8Cancelled Dec 4, 2021 · Registration expired, pending cancellation · Abandon Films N108ASDevin Anthony Freitas AS1 · S/N ADW001Cancelled Jan 9, 2021 · Registration expired, pending cancellation · Freitas Devin A N628JBBigler James E VANS RV6-A · S/N 23492Cancelled Dec 9, 2020 · Built 2004 · Mclanahan John P N153KMJetstream JETSTREAM 4101 · S/N 41053Cancelled Apr 3, 2020 · Registration expired, pending cancellation · Kmr Aviation Services Inc N301UEJetstream JETSTREAM 4101 · S/N 41012Cancelled Apr 3, 2020 · Registration expired, pending cancellation · Kmr Aviation Services Inc N328UEJetstream JETSTREAM 4101 · S/N 41083Cancelled Apr 3, 2020 · Registration expired, pending cancellation · Built 1996 · Kmr Aviation Services Inc N728HDDJI INSPIRE 1 · S/N W13DCJ28050067Cancelled Feb 3, 2020 · Registration expired, pending cancellation · Central Virginia Aerial Solutions LLC N915CVDJI INSPIRE 1 · S/N W13DCA18020091Cancelled Feb 3, 2020 · Registration expired, pending cancellation · Central Virginia Aerial Solutions LLC N454XJSaab-Scania SAAB 340B · S/N 340B-454Cancelled Jan 21, 2020 · Exported to Guatemala · K M R Aviation Services Inc N36710Stinson 10A · S/N 8110Cancelled Dec 20, 2019 · Revoked, canceled · Built 1941 · Faucette H W N49CVDJI INSPIRE 1 · S/N W13DDA12060299Cancelled Nov 29, 2019 · Registration expired, pending cancellation · Central Virginia Aerial Solutions LLC N724QCDJI INSPIRE 1 · S/N W13DCB16020084Cancelled Nov 4, 2019 · Registration expired, pending cancellation · Central Virginia Aerial Solutions LLC N723RZDJI PHANTOM 3 ADVANCED · S/N P77DCH17010801Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Central Virginia Aerial Solutions LLC N449XJSaab-Scania SAAB 340B · S/N 340B-449Cancelled Aug 27, 2019 · Exported to Guatemala · K M R Aviation Services Inc N9830KStinson 108-2 · S/N 108-2830Cancelled Apr 24, 2018 · Registration expired, pending cancellation · Layne Terri A N766KMEmbraer EMB-110P1 · S/N 110212Cancelled Mar 30, 2018 · Registration expired, pending cancellation · Kmr Aviation Services Inc N13DHCessna 150F · S/N 15064030Cancelled Mar 20, 2018 · Registration expired, pending cancellation · Built 1966 · Liberty University N497CXAirborne Windsports PTY EDGE XT-582-L · S/N XT-582-0096Cancelled Mar 16, 2018 · Registration expired, pending cancellation · Built 2013 · Harrington Jeffrey M N8830WPiper PA-28-235 · S/N 28-10377Cancelled Mar 7, 2018 · Registration expired, pending cancellation · Built 1964 · Canody Robert H N292HTThaxton Henry F RAF 2000 SE · S/N H2-99-10-424Cancelled Feb 12, 2018 · Registration expired, pending cancellation · Collins Jacqueline M N40087Frego Mike CH 601 HD · S/N 63738Cancelled Jan 18, 2018 · Registration expired, pending cancellation · Built 2000 · Tweedy Thomas W N37137Engineering & Research ERCOUPE 415-C · S/N 104Cancelled Nov 18, 2017 · Revoked, canceled · Built 1941 · Lynchburg Air Trnspt & Sale Corp N27847Piper J4A · S/N 41067Cancelled Oct 28, 2017 · Revoked, canceled · Built 1940 · Hall James A N35087Collier Michael W DREAM MACHINE · S/N 6106Cancelled Jul 18, 2017 · Registration expired, pending cancellation · Built 2001 · Collier Michael W N72EZPiper PA-60-602P · S/N 60-8265002Cancelled Jun 1, 2017 · Registration expired, pending cancellation · Fly LLC N289APDJI INSPIRE 1 · S/N W13B14020080Cancelled Jan 31, 2017 · Birds Eye Aerial Photography Inc N360APDJI S900 · S/N 0370062218Cancelled Jan 31, 2017 · Birds Eye Aerial Photography Inc N60YJBell 206L-3 · S/N 51181Cancelled Aug 29, 2016 · Exported to Costa Rica · Built 1986 · Adams James N3963YCessna 210D · S/N 21058463Cancelled May 15, 2015 · Registration expired, pending cancellation · Built 1964 · Di Giulio Robert H N94UBeech F90 · S/N LA-124Cancelled Nov 26, 2014 · Registration expired, pending cancellation · Built 1981 · Jim Mitchell Aviation LLC N1271FBalloon Works FIREFLY 6 · S/N 612Cancelled Sep 3, 2014 · Registration expired, pending cancellation · Built 1974 · Sky Is The Limit Inc N617MGPiper PA-28-140 · S/N 28-26496Cancelled Nov 7, 2013 · Registration expired, pending cancellation · Built 1970 · Chenoweth Janet L N113STHall Steve A EXEC 162F · S/N 6141Cancelled Aug 7, 2013 · Sale reported, canceled N9509WPiper PA-28-140 · S/N 28-22820Cancelled May 23, 2013 · Registration expired, pending cancellation · Built 1967 · Olson Chester N101XNKennedy Francis M WITTMAN/KENNEDY MW10 · S/N 953Cancelled May 13, 2013 · Registration expired, pending cancellation · Kennedy Francis M N6003DPiper PA-22-150 · S/N 22-4654Cancelled Apr 29, 2013 · Registration expired, pending cancellation · Built 1956 · Royal Mobile Homes Inc N6367WPiper PA-28-140 · S/N 28-20427Cancelled Apr 29, 2013 · Registration expired, pending cancellation · Built 1964 · Trent Harry D N2416HBalloon Works FIREFLY 7 · S/N 7717Cancelled Apr 15, 2013 · Registration expired, pending cancellation · Built 1978 · Pane Henry A N8126CPiper PA-22-135 · S/N 22-2272Cancelled Feb 27, 2013 · Sale reported, canceled · Built 1954 N27507Taylorcraft BL-65 · S/N 2149Cancelled Nov 23, 2011 · Sale reported, pending cancellation · Built 1948 N11914Cessna 150L · S/N 15075707Cancelled May 26, 2011 · Registration pending, canceled · Built 1974 N340WTCessna 340A · S/N 340A0332Cancelled Mar 8, 2011 · Exported to Canada · Built 1977 · Efb LLC N16AVPiper PA-44-180 · S/N 44-7995185Cancelled Nov 18, 2008 · Exported to Canada · Built 1978 · Bonair Brokerage Company LLC N142XJSaab-Scania SF340A · S/N 340A-142Cancelled May 9, 2005 · Exported to Guatemala · Built 1989 · Kmr Aviation Services Inc N65187Aerostar International RAVEN S-55A · S/N S55A-3029Cancelled Jan 27, 2005 · Built 1987 · Turlington Jerry K N50RPBeech 65-A90 · S/N LJ-200Cancelled Jan 7, 2005 · Exported to Mexico · Built 1966

Back to Lynchburg, VA