Skip to content

Cancelled registrations · 32

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 = 'GA' AND d.registrant_city = 'WOODSTOCK' 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 = 'GA' AND d.registrant_city = 'WOODSTOCK'
  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 = 'GA' AND d.registrant_city = 'WOODSTOCK'
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.

N441LBArbc Inc DBA Lindstrand 105A · S/N 5815Cancelled Jan 3, 2026 · Sale reported, canceled · Built 2024 N5587QMooney M20C · S/N 2982Cancelled Jul 13, 2024 · Registration pending, canceled · Built 1965 N6530PPiper PA-24-250 · S/N 24-1652Cancelled Mar 4, 2023 · Registration expired, pending cancellation · Built 1959 · Warren William E N352SBeech C24R · S/N MC655Cancelled Jun 14, 2019 · Culpepper Kevin N493LWilliam R Snavely JR VOLKSPLANE VP1 · S/N VP 51Cancelled Feb 7, 2019 · Sale reported, canceled N157ARHogan Richard N INNOVATOR · S/N 001Cancelled Mar 22, 2018 · Registration expired, pending cancellation · Hogan Richard N N14UMUltramagic M-105 · S/N 105/64Cancelled Mar 9, 2018 · Registration expired, pending cancellation · Built 2000 · Admax Inc N5335KNavion NAVION B · S/N NAV-4-2235BCancelled Jan 17, 2018 · Registration expired, pending cancellation · Built 1950 · Porter Randall O N4902KRyan NAVION A · S/N NAV-4-1902Cancelled Jun 30, 2017 · Registration expired, pending cancellation · Built 1949 · Porter Randall O N801SPPiper PA-32R-301 · S/N 32R-8013070Cancelled Feb 28, 2017 · Registration expired, pending cancellation · Built 1980 · Letchworth Leasing Inc N2080FBalloon Works FIREFLY 7 · S/N 729Cancelled Apr 24, 2015 · Registration expired, pending cancellation · Built 1976 · Great American Balloon Corp N28WPHughes TH-55A · S/N 67-16974Cancelled Sep 19, 2013 · Registration expired, pending cancellation · City Of Woodstock N76390Cessna 140 · S/N 10811Cancelled Aug 22, 2013 · Sale reported, canceled · Built 1946 N635CStinson 108-3 · S/N 108-3635Cancelled Aug 20, 2013 · Sale reported, canceled · Built 1947 N4225KRyan NAVION · S/N NAV-4-1225Cancelled Jun 18, 2013 · Registration expired, pending cancellation · Built 1948 · Porter Randall O N71553Luscombe 8A · S/N 2980Cancelled May 3, 2013 · Registration expired, pending cancellation · Built 1946 · Anderson Dennis B N4621VBoeing E75 · S/N 75-5804Cancelled Apr 22, 2013 · Registration expired, pending cancellation · Built 1949 · Porter Randall O N5540YPiper PA-23-250 · S/N 27-2639Cancelled Apr 22, 2013 · Registration expired, pending cancellation · Built 1964 · Wright Frederick C N1935MCessna 195 · S/N 7188Cancelled Apr 11, 2013 · Registration expired, pending cancellation · Built 1948 · Dowling Foreman H N76888Cessna 120 · S/N 11322Cancelled Nov 8, 2012 · Sale reported, pending cancellation · Built 1946 N4262QCessna 172L · S/N 17260162Cancelled Sep 19, 2011 · Exported to Russia · Built 1971 · Thomson Jeffrey A N11374Cessna 150L · S/N 15075364Cancelled Mar 15, 2005 · Built 1973 · Detch Steve N567MACarlsen Kurt M VARIEZE · S/N 5056KBCancelled Feb 28, 2005 · Triennial form not returned · Built 1993 · Carlsen Kurt M N9561Beech UC-45J · S/N 67305Cancelled Apr 19, 2000 · Triennial form not returned · Steve Detch Vintage Aircraft Inc N218SDBeech C-45 · S/N 29590Cancelled Mar 30, 2000 · Detch Steven A N9735WPiper PA-28-140 · S/N 2823216Cancelled Dec 9, 1998 · Triennial form not returned · Blackwell Technical Services Inc N902CAPiper PA-23-160 · S/N 231408Cancelled Apr 11, 1997 · Blackwell Technical Services Inc N4575KRyan NAVION · S/N NAV41575Cancelled May 12, 1995 · Triennial form not returned · Porter Randall N8489BMichelson Robert C BENSEN B-8M · S/N 43137260RCMCancelled May 26, 1994 · Triennial form not returned · Michelson Robert C N5587JPiper PA-32-260 · S/N 321047Cancelled May 2, 1991 · Triennial form not returned · Chao Joe N34627Cessna 177B · S/N 17701908Cancelled Aug 6, 1984 · Administratively canceled · Storey Paul E N83054Champion AERONCA 7AC · S/N 7AC-1710Cancelled Jun 9, 1975 · Allen D King

Back to Woodstock, GA