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

N28295Grumman American Avn. AA-5B · S/N AA5B0533Cancelled May 6, 2019 · Registration expired, pending cancellation · Built 1977 · Strasser Christopher P N196ASEnos Robert E SPRINT 1000 · S/N 001Cancelled May 20, 2015 · Sale reported, canceled · Built 1999 N230ACWright Thomas J SEA HAWKER · S/N 230Cancelled Sep 20, 2013 · Registration expired, pending cancellation · Built 1989 · Aero Composite Technology Inc N1201MCessna 337E · S/N 33701301Cancelled Aug 5, 2013 · Sale reported, canceled · Built 1970 N94820Cessna 152 · S/N 15285794Cancelled Jun 27, 2013 · Registration expired, pending cancellation · Built 1983 · Hoffman William C N24PKSchmidt G/Wyne R FISHER CLASSIC · S/N CO123Cancelled May 9, 2013 · Sale reported, canceled · Built 1997 N3557RBeech A23 · S/N M-731Cancelled Sep 18, 2012 · Sale reported, canceled · Built 1965 N4615CCessna 170B · S/N 25559Cancelled Jul 31, 2012 · Revoked, canceled · Built 1953 · Specht Edward A N5107Trent Blaine E FEW MUSTANG · S/N 002Cancelled Jun 20, 2005 · Triennial form undeliverable · Trent Blaine E N758TTrent Blaine CLASSIC · S/N 001Cancelled Jul 13, 1998 · Trent Blaine E N4190WPiper PA-32-300 · S/N 32-40496Cancelled Jan 15, 1975 · Built 1968 · Shaffer John E Et Al N78281Globe GC-1B · S/N 2281Cancelled Aug 24, 1970 · R W Bittner N6883WPiper PA-28-140 · S/N 28-21039Cancelled Oct 16, 1968 · Exported to Canada · Mankamyer David L N7151KPiper PA-18 · S/N 18-371Cancelled Jan 7, 1960 · Martin J W N5102MTaylorcraft BC12-D · S/N 10402Cancelled Sep 16, 1947 · Built 1946 · Somerset Aviation School N10783Mead GLIDER · S/N G-498Cancelled Mar 1, 1939 · Built 1931 · Woodrow Russell James

Back to Somerset, PA