Cancelled registrations · 25

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 = 'OH' AND d.registrant_city = 'PAULDING' 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 = 'OH' AND d.registrant_city = 'PAULDING'
  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 = 'OH' AND d.registrant_city = 'PAULDING'
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.

N74706Robinson Helicopter R44 II · S/N 11065Cancelled Apr 29, 2023 · Sale reported, canceled N7511DRobinson Helicopter R44 · S/N 1252Cancelled Mar 1, 2023 · Sale reported, canceled · Built 2002 N7186KRobinson Helicopter R22 BETA · S/N 3031Cancelled Sep 19, 2022 · Sale reported, canceled · Built 2000 N134AGGordon Andrew J EXXON 99 · S/N 001Cancelled Mar 23, 2019 · Registration expired, pending cancellation · Gordon Andrew J N26350Aeronca 65-C · S/N C8240Cancelled Mar 1, 2018 · Registration expired, pending cancellation · Built 1940 · Free Alan R N2091Starduster SA-300 · S/N 19-1Cancelled Jan 16, 2018 · Registration expired, pending cancellation · Built 1967 · Kohart Ken M N2646EAeronca 7AC · S/N 7AC6228Cancelled Nov 22, 2017 · Revoked, canceled · Built 1946 · Potts Floyd R N424JWHarris Hal L LANCAIR 360 · S/N 373Cancelled Aug 24, 2017 · Built 1992 · Webb J H N4JWPipistrel Doo Ajdovscina VIRUS SW · S/N 672 SWN 100ISCancelled Apr 25, 2017 · Built 2014 · Webb J H N95GPiper PA-34-200T · S/N 34-7770298Cancelled Jan 4, 2013 · Exported to Germany · Built 1977 · Weck Air Inc N7772WPiper PA-28-180 · S/N 28-1774Cancelled Aug 30, 2007 · Triennial form not returned · Built 1964 · Glass Jerry L N2706QPiper PA-34-200T · S/N 34-7770195Cancelled Sep 22, 2006 · Triennial form not returned · Weck Air Inc N67SAPiper PA-34-200T · S/N 34-7970358Cancelled Dec 20, 2002 · Triennial form not returned · Built 1980 · Weck Air Inc N616WAPiper PA-34-220T · S/N 34-8133225Cancelled Jul 27, 2000 · Exported to Malaysia · Weck Air Inc N215RWPiper PA-34-200T · S/N 347870221Cancelled Dec 28, 1995 · Exported to Germany · Weck Air Inc N2247ZPiper PA-34-200T · S/N 34-7970218Cancelled Nov 3, 1992 · Exported to Germany · Built 1979 · Weck Air Inc N81404Piper PA-34-200T · S/N 348070110Cancelled Oct 29, 1992 · Exported to Canada · Weck Air Inc N31725Piper PA-34-200T · S/N 347870263Cancelled Jun 19, 1992 · Exported to Germany · Weck Air Inc N28262Piper PA-34-200T · S/N 347970221Cancelled Jan 27, 1992 · Exported to Guatemala · Weck Air Inc N9365CPiper PA-34-200T · S/N 347870184Cancelled May 24, 1991 · Exported to Spain · Weck Air Inc N15116Piper PA-28-180 · S/N 287305024Cancelled Apr 5, 1991 · Exported to South Africa · Weck Air Inc N36128Taylorcraft BC12-65 · S/N 3095Cancelled Dec 28, 1977 · Howell Edwin N9254HFairchild M-62A-3 · S/N T43-4411Cancelled Nov 22, 1955 · Burke Robert S N80536Globe GC-1A · S/N 39Cancelled Oct 12, 1955 · Built 1946 · Buehler Charles N47366Ryan Aeronautical ST3KR · S/N 1637Cancelled Apr 30, 1945 · Dangler Nolan G

Back to Paulding, OH