Skip to content

Cancelled registrations · 20

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 = 'BIDDEFORD' 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 = 'BIDDEFORD'
  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 = 'BIDDEFORD'
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.

N2816DSocata TAMPICO TB 9C · S/N 1061Cancelled Dec 21, 2024 · Registration pending, canceled N151HDDJI PHANTOM 3 PROFESSION · S/N P76DCJ30A20720Cancelled Jun 4, 2022 · Registration expired, pending cancellation · Maine Hdtv N161HDDJI PHANTOM 3 PROFESSION · S/N P76DCJ13A26875Cancelled Nov 29, 2019 · Registration expired, pending cancellation · Maine Hdtv N141HDDJI PHANTOM 3 PROFESSION · S/N P76DCE14011367Cancelled Feb 6, 2019 · Registration expired, pending cancellation · Maine Hdtv N135HDDJI PHANTOM 2 VISION + · S/N BK070617343545Cancelled Jan 22, 2019 · Registration expired, pending cancellation · Maine Hdtv N1490LBeech A23 · S/N M-890Cancelled Jan 14, 2019 · Registration expired, pending cancellation · Built 1965 · Long Ricki D N857BWPhantom X-1 · S/N 081691001Cancelled Mar 13, 2018 · Registration expired, pending cancellation · Built 1991 · Lovejoy Keith W N43078Piper PA-28-140 · S/N 28-7425332Cancelled Aug 29, 2017 · Second renewal notice · Built 1974 · Gagnon Ronald L N26LKLake LA-4-200 · S/N 547Cancelled Dec 18, 2014 · Sale reported, canceled · Built 1973 N5267MTaylorcraft BC12-D · S/N 10567Cancelled Sep 26, 2013 · Registration expired, pending cancellation · Built 1948 · Poirier Theodore N N4566TPiper-Crockett J-4A · S/N 4-466Cancelled Jun 11, 2013 · Registration expired, pending cancellation · Lemelin Philip G N50828Cessna 150J · S/N 15069580Cancelled Apr 18, 2013 · Registration expired, pending cancellation · Built 1968 · Giguere Norman M N394DRSarzanini Giorgio CX4 · S/N 385Cancelled Jun 7, 2012 · Registration expired, pending cancellation · Sarzanini Giorgio N2607JCessna 150G · S/N 15065607Cancelled Mar 10, 1997 · Coastal Aviation Services Inc N76DEPiper PA-31-350 · S/N 317652101Cancelled Dec 13, 1994 · Exported to Canada · Victor Aviation Corporation N20704Warner Leo Z MITCHELL P-38 · S/N L350Cancelled Oct 20, 1994 · Second triennial mailing, no response · Warner Leo Z N5704DPiper PA-22-150 · S/N 224400Cancelled May 31, 1991 · Triennial form not returned · Stearns Stanley E N6349JPiper PA-28-180 · S/N 28-4759Cancelled Dec 5, 1973 · York Aviation Inc N52253Fairchild M-62A · S/N 8753AECancelled Apr 28, 1954 · C & P Airways N70901Piper J3C-65 · S/N 18141Cancelled Feb 8, 1949 · Robert L Roy & Carl E Erickson DBA Royal Air Lines

Back to Biddeford, ME