Cancelled registrations · 17

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 = 'MD' AND d.registrant_city = 'TOWSON' 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 = 'MD' AND d.registrant_city = 'TOWSON'
  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 = 'MD' AND d.registrant_city = 'TOWSON'
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.

N9436XCessna 210A · S/N 21057736Cancelled Dec 3, 2022 · Registration expired, pending cancellation · Built 1961 · J & B II LLC N423MAero Commander 560-F · S/N 1407-67Cancelled Jan 19, 2018 · Registration expired, pending cancellation · Built 1964 · Barnes William C C Trustee N805CPBell OH-58A · S/N 72-21185Cancelled May 11, 2015 · Registration expired, pending cancellation · Baltimore County Police Department N807CPBell OH-58A · S/N 71-15242Cancelled May 11, 2015 · Registration expired, pending cancellation · Baltimore County Police Department N121KBSwearingen SA26-T · S/N T26-33Cancelled Sep 3, 2014 · Registration expired, pending cancellation · Built 1968 · Eastern Avia & Marine Underwriters N776MAGulfstream Aerospace G-1159A · S/N 447Cancelled Jul 29, 2014 · Built 1984 · Auto Properties II LLC N445MTBell Helicopter Textron Canada 407 · S/N 53959Cancelled May 31, 2014 · Second renewal notice · Built 2009 · Suntrust Equipment Finance & Leasing Corp N9017EHughes 269A · S/N 260460Cancelled Mar 17, 1998 · Triennial form not returned · Baltimore County Police Dept N57NEFairchild SA227-AC · S/N AC757BCancelled Oct 20, 1995 · Exported to France · Sanwa Business Credit Corporation N58NEFairchild SA227-AC · S/N AC758BCancelled Sep 14, 1995 · Exported to France · Sanwa Business Credit Corporation N73QBeech TC-45G · S/N AF-128Cancelled Jun 17, 1992 · Clemson John N5760LAmerican AA-1 · S/N AA10160Cancelled May 1, 1991 · Triennial form not returned · Pippin Reginald F III N2689EFairchild SA227-AC · S/N AC653Cancelled Apr 23, 1991 · Triennial form not returned · M N C Leasing Corporation N969HBeech 35-B33 · S/N CD-485Cancelled Jun 25, 1983 · Administratively canceled · Knoedler Jerome J Jr N734WQCessna 172N · S/N 17269176Cancelled May 17, 1982 · Exported to Iceland · 734 Wq Associates N451Beech D18S · S/N A-540Cancelled May 18, 1965 · Clemson Co Inc N561KMoth 60-GM · S/N 55Cancelled Nov 16, 1929 · Built 1929 · Brogan G W

Back to Towson, MD