Cancelled registrations · 16

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 = 'GA' AND d.registrant_city = 'VIDALIA' 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 = 'GA' AND d.registrant_city = 'VIDALIA'
  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 = 'GA' AND d.registrant_city = 'VIDALIA'
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.

N53GJWalter Luke STARDUSTER TOO SA300 · S/N 1697Cancelled Jul 8, 2021 · Exported to Canada · Built 1978 · Brantley Donald M N8582KStinson 108-1 · S/N 108-1582Cancelled Mar 7, 2018 · Registration expired, pending cancellation · Built 1947 · Smith Raymond R Jr N9015KStinson 108-1 · S/N 108-2015Cancelled May 15, 2015 · Registration expired, pending cancellation · Built 1947 · Smith Raymond R Jr N68063Smith SKYBOLT · S/N 79Cancelled Oct 23, 2013 · Revoked, canceled · Built 1978 · Stephens Gordon L N3287YCessna 182E · S/N 18254287Cancelled Oct 2, 2012 · Registration expired, pending cancellation · Built 1962 · Perkerson Ralph B Jr N4334MPiper PA-12 · S/N 12-3268Cancelled Jun 21, 2012 · Revoked, canceled · Built 1947 · O Conner James P N770DLBeech C24R · S/N MC-689Cancelled Apr 19, 2010 · Triennial form not returned · Built 1979 · Lovins Branch & Company Pc N2381ZBeech 23 · S/N M-92Cancelled Sep 13, 2002 · Triennial form not returned · Built 1962 · Tapley Jay A N5336ZZorn Tony P PANTHER II PLUS · S/N 25713Cancelled Nov 2, 2001 · Triennial form not returned · Zorn Tony P N217DBBrown Daniel EARLY BIRD JENNY · S/N DB-1Cancelled May 20, 1999 · Triennial form not returned · Brown Daniel H N8411VAero Commander CALLAIR A-9 · S/N 1611Cancelled Dec 6, 1997 · Triennial form not returned · Hamilton J N N6074GCessna 150K · S/N 15071574Cancelled Sep 1, 1994 · Nobles Aileen P N1383ECessna 172N · S/N 17270981Cancelled Nov 12, 1991 · Exported to Germany · Nobles Aileen P N75961Cessna 172N · S/N 17268071Cancelled Jan 31, 1991 · Triennial form not returned · Nobles Aileen P N8016VCessna 188 · S/N 188-0266Cancelled Dec 7, 1971 · Nobles B E N54338Fairchild M-62A · S/N T42-1531Cancelled Oct 20, 1955 · George D Wright

Back to Vidalia, GA