Skip to content

Cape Elizabeth, ME

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 = 'CAPE ELIZABETH' 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 = 'CAPE ELIZABETH'
  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 = 'CAPE ELIZABETH'
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.

N369BCBeech N35 · S/N D-6773Cancelled Sep 3, 2024 · Sale reported, canceled · Built 1961 N5558KDJI PHANTOM 2 VISION · S/N PH645167838Cancelled Jun 26, 2021 · Registration expired · Kaplan Ann C N2877TPiper PA-28-140 · S/N 28-7225262Cancelled Jan 20, 2021 · Exported to Canada · Built 1972 · Seaside Aviation LLC N2993VBeech 35 · S/N D-391Cancelled Jan 31, 2020 · Sale reported, canceled N823NJPiper PA-28-151 · S/N 28-7415374Cancelled Jun 10, 2019 · Exported to Canada · Seaside Aviation LLC N32730Balloon Works FIREFLY 8B-15 · S/N F8B-519Cancelled Aug 10, 2018 · Registration expired, pending cancellation · Built 1996 · Hot Fun Inc N729BBeech A35 · S/N D-1736Cancelled May 31, 2018 · Sale reported, canceled · Built 1948 N10697Cessna 150L · S/N 15074982Cancelled May 30, 2018 · Sale reported, canceled · Built 1973 N6546RBeech C23 · S/N M-1585Cancelled Mar 28, 2018 · Registration expired, pending cancellation · Built 1974 · Seaside Aviation LLC N9740MMooney M20C · S/N 670034Cancelled Mar 15, 2018 · Registration expired, pending cancellation · Built 1967 · Seaside Aviation LLC N444CFPiper PA-28-161 · S/N 28-7816035Cancelled Mar 13, 2018 · Registration expired, pending cancellation · Built 1977 · Seaside Aviation Llcl N2033WBeech 35-C33 · S/N CD-979Cancelled Jun 17, 2016 · Exported to El Salvador · Built 1965 · Seaside Aviation LLC N5115WPiper PA-28-160 · S/N 28-113Cancelled Dec 18, 2014 · Sale reported, canceled · Built 1961 N900GGLearjet 24B · S/N 216Cancelled Nov 3, 2014 · Exported to Mexico · Built 1970 · Seaside Aviation LLC N1633JRockwell International 112TC · S/N 13019Cancelled Aug 8, 2013 · Sale reported, canceled · Built 1976 N2248ZPiper PA-34-200T · S/N 34-7970219Cancelled Jul 23, 2013 · Exported to Brazil · Built 1979 · Seaside Aviation LLC N2GUPiper PA-34-200T · S/N 34-7870055Cancelled Mar 17, 2011 · Exported to Brazil · Seaside Aviation LLC N2189APiper PA-22 · S/N 22-606Cancelled Jul 22, 2010 · Built 1952 · Huntoon Jeffrey S N23545Brown William WL JR CHALLENGER II · S/N CH2-0599-1876Cancelled Sep 10, 2008 · Exported to Canada · Built 1999 · Tinsman Douglas A N14596Piper PA-34-200 · S/N 34-7250160Cancelled Jul 29, 1999 · Exported to Canada · Bonanza Aviation N6189QCessna 320F · S/N 320F0039Cancelled Aug 10, 1998 · Triennial form not returned · B And N Wholesale Truck Parts N56UZappia Gabriel J QUICKIE-2 · S/N 8888-8888Cancelled May 8, 1985 · Zappia Gabriel J N15743Aeronca LB · S/N 2009Cancelled Aug 4, 1948 · Paul Kenneth Dewitt N8810Stearman C3-B · S/N 226Cancelled Jul 5, 1929 · Henry St John Smith

Back to Cape Elizabeth, ME