Cancelled registrations · 19

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 = 'PA' AND d.registrant_city = 'GREENSBURG' 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 = 'PA' AND d.registrant_city = 'GREENSBURG'
  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 = 'PA' AND d.registrant_city = 'GREENSBURG'
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.

N724PRyan John Steffey WAIEX-B · S/N WXB0035Cancelled May 9, 2022 · Registration expired, pending cancellation · Steffey Ryan J N641UMSensefly EBEE RTK · S/N ER-02-25577Cancelled Nov 1, 2021 · First renewal notice · Cme Management LLC N7249ZDJI PHANTOM 3 PROFESSION · S/N P77DCG23010876Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Greensburg Volunteer Fire Dept N6810CBeech C18S · S/N 44-47628Cancelled Aug 28, 2018 · Revoked, canceled · Built 1956 · Tait Ralph D N53JRKrofick Randolph S GOLDWING ST · S/N S31001Cancelled Mar 15, 2018 · Registration expired, pending cancellation · Built 1984 · Krofick Randy N24999Errett Paul W GOLDWING · S/N 421Cancelled Dec 2, 2014 · Registration expired, pending cancellation · Built 1982 · Errett Paul W N5563SRaven S55A · S/N S55A-548Cancelled Sep 13, 2013 · Registration expired, pending cancellation · Built 1979 · Pit Stop Inc N60164Cessna T-50 · S/N 5271Cancelled Aug 30, 2012 · Revoked, canceled · Built 1943 · Daugherty H B N124ACessna 210-5(205) · S/N 205-0429Cancelled Nov 21, 2005 · Triennial form not returned · Built 1963 · Bryant Charles E N2DFPoskus David D REVELATION · S/N 98008Cancelled Dec 4, 2002 · Triennial form not returned · Poskus David D N43926Raven S-60A · S/N S60A306Cancelled Aug 12, 1996 · Triennial form not returned · Kuhns William J N5984ECessna 150 · S/N 17484Cancelled Jan 28, 1994 · Administratively canceled · Asa Atwater N99162Ercoupe 415-C · S/N 1785Cancelled Jan 19, 1972 · Carr Leo M N4301NCessna 195 · S/N 7125Cancelled Nov 30, 1971 · Baldwin Earl C N51954Fairchild M-62A · S/N T41-1320Cancelled Oct 21, 1955 · Lowman Roy N2325EAeronca 7AC · S/N 7AC-5902Cancelled May 4, 1953 · Greensburg Aviation Co N1029EAeronca 7AC · S/N 4580Cancelled Jan 2, 1952 · Greensburg Aviation Co N12845Great Lakes 2T-1A · S/N 255Cancelled Apr 24, 1951 · Reedy J F N36034Taylorcraft BC12-65 · S/N 2999Cancelled Jan 11, 1944 · Built 1941 · Deckerrickcliffe

Back to Greensburg, PA