Cancelled registrations · 24

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 = 'ME' AND d.registrant_city = 'HOULTON' 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 = 'ME' AND d.registrant_city = 'HOULTON'
  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 = 'ME' AND d.registrant_city = 'HOULTON'
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.

N1910WFlight Star SL II · S/N 245Cancelled Jun 5, 2021 · Registration expired, pending cancellation · Built 1999 · Ross Eugene A N42108Raven Industries S-66A · S/N S66A-144Cancelled Jul 10, 2020 · Registration expired, pending cancellation · Built 1984 · Lovell Gary K N7682PPiper PA-24-250 · S/N 24-2891Cancelled May 2, 2020 · Registration expired, pending cancellation · Built 1961 · Tidd Wesley P N8076EBayliss Milton A III XAIR · S/N 759Cancelled Feb 8, 2018 · Registration expired, pending cancellation · Built 2003 · Bayliss Milton A III N569WTTidd Wesley MINI-MAX · S/N 1098Cancelled Mar 24, 2017 · Registration expired, pending cancellation · Built 2003 · Tidd Wesley P N32278Piper PA-28-151 · S/N 28-7515111Cancelled Sep 9, 2013 · Exported to Brazil · Built 1974 · Fuller Michael N4459MPiper PA-12 · S/N 12-3411Cancelled Feb 9, 2009 · Triennial form not returned · Built 1947 · Ellis Robert D N8543ZAerofab LAKE LA-4-200 · S/N 1111Cancelled Aug 20, 2008 · Exported to Canada · Built 1985 · Degenhardt Edwin R N292QEnstrom F-28A · S/N 312Cancelled Sep 10, 1996 · Triennial form not returned · Houlton Helicopter Inc N474VAero Commander 500 S · S/N 3164Cancelled Oct 28, 1994 · Exported to Australia · Bee Line Express Inc N8383RPiper PA-28-140 · S/N 28-22260Cancelled Jan 21, 1977 · Exported to Canada · Built 1966 · Mcguffin Milton C Jr Et Al N4313ZPiper PA-18-150 · S/N 18-8623Cancelled Jul 2, 1973 · Exported to Canada · Ludwig Leland O III N1697APiper PA-22 · S/N 22-453Cancelled Apr 29, 1968 · Exported to Canada · Built 1952 · Larson Kenneth C N5646ZPiper PA-22-108 · S/N 22-9469Cancelled Oct 28, 1964 · International Flying Club Inc N89432Cessna 140 · S/N 8464Cancelled May 16, 1961 · Exported to Canada · International Flying Club N97902Stinson 108-1 · S/N 108-902Cancelled Aug 3, 1960 · Exported to Canada · Linwood Lawrence N4624HPiper PA-15 · S/N 15-360Cancelled Sep 26, 1958 · Exported to Canada · Houlton Flying Club N72710Cessna 140 · S/N 9889Cancelled May 17, 1956 · Exported to Canada · Grant Edward A N51667Fairchild M-62A · S/N T42-1657Cancelled Nov 29, 1955 · Houlton Flying Service N38053Piper J5B · S/N 862Cancelled Dec 9, 1954 · Built 1941 · Way John & Way Roland N928CStinson 108-3 · S/N 108-3928Cancelled May 20, 1953 · Exported to Canada · Linwood Lawerence DBA Aroostook Air Academy N6614KRepublic RC-3 · S/N 887Cancelled May 6, 1952 · Exported to Canada · Dickinson M Jerome N93408Engineering & Research 415-C · S/N 731Cancelled Dec 29, 1949 · Houlton Flying Service N8815Stearman C3-B · S/N 229Cancelled Sep 2, 1934 · Dunn Frederick G

Back to Houlton, ME