Skip to content

Battle Ground, WA

Cancelled registrations · 44

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 = 'WA' AND d.registrant_city = 'BATTLE GROUND' 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 = 'WA' AND d.registrant_city = 'BATTLE GROUND'
  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 = 'WA' AND d.registrant_city = 'BATTLE GROUND'
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.

N730RXMichael Ray Holliday REV X · S/N X1026Cancelled Sep 27, 2022 · Sale reported, canceled · Built 2020 N8151MCessna 310I · S/N 310I0151Cancelled Aug 2, 2020 · Registration expired, pending cancellation · Built 1964 · Goheen Gordon C N34567Aeronca 65-CA · S/N CA15591Cancelled May 1, 2020 · Registration expired, pending cancellation · Built 1941 · Goheen Gordon C N3927EAeronca 11BC · S/N 11BC-8Cancelled Jan 6, 2020 · Registration expired, pending cancellation · Built 1947 · Goheen Gordon C N7789YPiper PA-30 · S/N 30-872Cancelled Nov 4, 2019 · Registration expired, pending cancellation · Built 1965 · Goheen Gordon C N1332JRockwell International 112A · S/N 332Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Built 1975 · Auger Air Inc N533RCChristopher Tom KITFOX -5 · S/N 0127Cancelled Mar 12, 2019 · Registration expired, pending cancellation · Built 2001 · Christopher Richard A N8110MCessna 310I · S/N 310I0110Cancelled Feb 25, 2019 · Registration expired, pending cancellation · Built 1964 · Goheen Gordon C N97125Stinson 108-1 · S/N 108-1125Cancelled Dec 20, 2018 · Registration expired, pending cancellation · Built 1946 · Goheen Gordon C N977DStinson 108-2 · S/N 108-2977Cancelled Apr 18, 2018 · Registration expired, pending cancellation · Built 1947 · Goheen Gordon C N3638SCessna 320 · S/N 320-0063Cancelled Mar 22, 2018 · Registration expired, pending cancellation · Built 1962 · Goheen Gordon C N7671JPiper PA-28R-180 · S/N 28R-31070Cancelled Feb 23, 2018 · Registration expired, pending cancellation · Built 1969 · Goheen Gordon C N9699LGrumman American Avn. AA-1B · S/N AA1B-0199Cancelled Jan 17, 2018 · Registration expired, pending cancellation · Built 1973 · Christian Willis R Jr N21111Bailey & Betts B3B PITTS SPECIAL · S/N BB-3Cancelled Jan 16, 2018 · Registration expired, pending cancellation · Built 1968 · Bouwens Jerry L N97858Stinson 108-1 · S/N 108-858Cancelled Oct 20, 2017 · Registration expired, pending cancellation · Built 1946 · Goheen Gordon C N5270ACessna 310 · S/N 35470Cancelled May 22, 2017 · Registration expired, pending cancellation · Built 1956 · Diamond John A N370DCGS HAWK ARROW · S/N H-512-R503Cancelled Aug 8, 2016 · Third renewal notice · Englett Frederick L N51855Texas Helicopter OH-13H/M74A · S/N 78-022Cancelled May 11, 2015 · Sale reported, canceled N439NTravel Air 4000 · S/N 1353Cancelled Apr 24, 2015 · Registration expired, pending cancellation · Built 1929 · Donovan James W N222BPPiper PA-30 · S/N 30-1510Cancelled Jan 26, 2015 · Second renewal notice · Built 1967 · Pearson Ward N N953REAero Sport RALLY 3 · S/N 25091Cancelled Dec 3, 2014 · Registration expired, pending cancellation · Aero Sport N9079QSix Chuter Legend XL LEGEND XL · S/N 3020Cancelled Oct 14, 2014 · Registration expired, pending cancellation · Built 2004 · Halberg Norbert S Jr N189EThorp T-18 · S/N 7322Cancelled Sep 10, 2014 · Registration expired, pending cancellation · Built 1971 · Condon John K N6322SCessna T337F · S/N 33701362Cancelled Aug 5, 2013 · Revoked, canceled · Built 1970 · Goheen Gordon C N85408Aeronca 7AC · S/N 7AC-4148Cancelled Jun 27, 2013 · Registration expired, pending cancellation · Built 1946 · Bouwens Jerry L N62972Bellanca 7GCBC · S/N 360-72Cancelled May 10, 2013 · Sale reported, canceled · Built 1972 N5989SBeech A23-19 · S/N MB-87Cancelled May 8, 2013 · Registration expired, pending cancellation · Built 1966 · Bouwens Jerry L N282DMBird Michael W 6SHUTR 2CTR · S/N 810702Cancelled Dec 27, 2012 · Third renewal notice · Bird Michael W N16333Piper PA-34-200 · S/N 34-7350128Cancelled Aug 9, 2012 · Registration expired, pending cancellation · Built 1973 · Aero Sport N1067UPiper PA-34-200 · S/N 34-7250054Cancelled May 18, 2012 · Registration expired, pending cancellation · Built 1971 · Aero Sport N1042FCessna A185F · S/N 18502699Cancelled Jun 7, 2011 · Sale reported, canceled · Built 1975 N6289HHill David SNOBIRD CHARGER · S/N 459Cancelled Mar 23, 2009 · Triennial form not returned · Built 2003 · Hill David E N1394CPiper PA-22 · S/N 22-1149Cancelled Jan 6, 2009 · Triennial form not returned · Built 1953 · Gullickson Ronald E N131HMCessna T210L · S/N 21059644Cancelled Jan 18, 2008 · Triennial form not returned · Built 1972 · Diamond Anthony J N4032TAdams Balloon A55S · S/N 163Cancelled Oct 22, 2007 · Triennial form not returned · Built 1985 · Wirch Ted A Jr N24164Dawson Alton KITFOX IV · S/N 1406Cancelled Feb 16, 2007 · Exported to Canada · Built 2003 · Dawson Myrtle D N2037UMaule M-4-180C · S/N 3001CCancelled Aug 2, 1993 N13227Cessna 177B · S/N 17702404Cancelled Aug 26, 1991 · Root Stephen N758KGCessna R172K · S/N R1723152Cancelled May 11, 1983 · Eggleston Darryl I N92PFCessna T210L · S/N 21061549Cancelled Jan 6, 1982 · Aero Sport N22906Cessna 150 · S/N 15068607Cancelled May 17, 1976 · Built 1968 · Wooldridge James S N2367ZBeech 23 · S/N M-88Cancelled Jun 9, 1973 · Goheen Gordon C N3869ZPiper PA-18A · S/N 18-7654Cancelled Jul 30, 1962 · Exported to Canada · Walker Dale N6110KRepublic RC-3 · S/N 293Cancelled Oct 4, 1955 · Skinner Henry L M D

Back to Battle Ground, WA