Skip to content

Mechanicsburg, PA

Cancelled registrations · 24

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

N525FZBeech F33A · S/N CE-1751Cancelled Dec 28, 2022 · Built 1993 · Zazworsky John D Jr N3886VCessna 120 · S/N 12549Cancelled Mar 27, 2021 · Sale reported, canceled · Built 1947 N34RWDJI PHANTOM 3 PROFESSION · S/N P76DCG25016412Cancelled Nov 4, 2019 · Registration expired, pending cancellation · Rettew N1160DCessna 140A · S/N 15723Cancelled Sep 27, 2019 · Sale reported, canceled · Built 1951 N7410GDJI PHANTOM 3 PROFESSION · S/N P76DCF2-7016718Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Bennett Gordon R N743TAHobby King HAWK · S/N 008520002Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Bennett Gordon R N823ZAPrecisionhawk HAWKEYE MKIII LANCAS · S/N PCN-048-201539-004-MSICancelled May 4, 2019 · Registration expired, pending cancellation · Uav Aviation Services Inc N175CWChristopher Wilkening AFFORDAPLANE · S/N 8035429Cancelled May 24, 2018 · Wilkening Christopher D N43485Powrachute SKY RASCAL · S/N P-3664-SRCancelled Apr 19, 2018 · Registration expired, pending cancellation · Built 2006 · Diebold James A N56CWChristopher Wilkening LM-5X-W · S/N 2014-CWCancelled Apr 10, 2018 · Wilkening Christopher D N823ZAPrecisionhawk HAWKEYE MKIII LANCAS · S/N LK3144477Cancelled Jan 28, 2016 · Uav Aviation Services Inc N73796Boeing A75N1(PT17) · S/N 75-1642Cancelled Nov 17, 2014 · Registration expired, pending cancellation · Kampel Lawrence J Jr N66457Boeing A75N1(PT17) · S/N 75-3272Cancelled Nov 12, 2014 · Registration expired, pending cancellation · Built 1942 · Kampel Larry J N194SCSix Chuter LEGEND XT SSDC · S/N 3063Cancelled Oct 30, 2014 · Registration pending, pending cancellation · Built 2007 N31327Carswell Joseph Clyde CHALLENGER II STD · S/N CH2 1190 R0587Cancelled Jul 29, 2013 · Sale reported, canceled N45438Luscombe 8A · S/N 1965Cancelled Jul 19, 2012 · Revoked, canceled · Built 1945 · Ralph Allen L N3221AWhitzel Landis 1500R · S/N MM69123Cancelled Oct 6, 2005 · Henry Richard C N24CDCessna P210N · S/N P21000798Cancelled Oct 10, 2000 · Second triennial mailing, no response · Lima Aviation Inc N72890Cessna 140 · S/N 10084Cancelled Aug 8, 1995 · Champe C Pool N9176PPiper PA-28-181 · S/N 2890118Cancelled Dec 27, 1990 · Exported to Germany · Mcclure Aviation Inc N5962LAmerican AA-1 · S/N AA1-0262Cancelled Nov 10, 1983 · Richards Van S N2855RCessna 182K · S/N 18258455Cancelled Oct 2, 1980 · Exported to Canada · Built 1967 · Finkler Paul R N3348ZPiper PA-22-150 · S/N 22-7288Cancelled Aug 14, 1972 · Ream David T & James Sunday N93954Engineering & Research 415-C · S/N 1277Cancelled Mar 22, 1971 · Weibley Richard W

Back to Mechanicsburg, PA