Lancaster, PA
Cancelled registrations · 75
Query with SQL
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 = 'LANCASTER' 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 = 'LANCASTER' 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.
N22BVEnstrom 280 · S/N 1012N18WBeech D35 · S/N D3409N2937LCameron Balloons US A-140 · S/N 5053N28196Piper PA-32-300 · S/N 327940116N3466ZPiper PA-22-160 · S/N 227388N8061JPiper AEROSTAR 601P · S/N 61P-0544-232N7424SSmith AEROSTAR 601 · S/N 61-0011N2454FPiper PA-38-112 · S/N 38-79A0455N9063TCessna 182C · S/N 52963N3359RCessna 182S · S/N 18258659N9565MMooney M20F · S/N 670142N7809PPiper PA-24-180 · S/N 24-3029N9948CLuscombe 8F · S/N S-52N8832UCessna 172F · S/N 17252742N123KMonocoupe MONOPREP · S/N 6080N8526EAeronca 7FC · S/N 7FC-335N3240VBeech 35 · S/N D-684N23478Piper J3F-50 · S/N 3214N99623Ercoupe 415-C · S/N 2246N14559Aeronca C-3 · S/N A-510N138MMoth 60-GM · S/N 98N484Aeromarine Klemm L 25 A · S/N 2N199KMonocoupe 90 · S/N 533N790WGeltz Roy K GELTZ DE LUX · S/N 5N7284PPiper PA-24 · S/N 24-2461
Back to Lancaster, PA