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.

N22BVEnstrom 280 · S/N 1012Cancelled Nov 12, 1998 · Exported to Canada · Haral Leasing Co IncN18WBeech D35 · S/N D3409Cancelled Mar 7, 1997 · Triennial form not returned · S & K Aircraft IncN2937LCameron Balloons US A-140 · S/N 5053Cancelled Aug 5, 1994 · Triennial form not returned · Around The World Balloons IncN28196Piper PA-32-300 · S/N 327940116Cancelled May 18, 1993 · Triennial form not returned · Maerz MartinN3466ZPiper PA-22-160 · S/N 227388Cancelled Feb 13, 1991 · Exported to Australia · Strutzenberg Marvin AN8061JPiper AEROSTAR 601P · S/N 61P-0544-232Cancelled Feb 26, 1983 · Administratively canceled · Commonwealth National BankN7424SSmith AEROSTAR 601 · S/N 61-0011Cancelled Feb 15, 1983 · Commonwealth National BankN2454FPiper PA-38-112 · S/N 38-79A0455Cancelled Nov 16, 1982 · Built 1979 · Hill Dudley JN9063TCessna 182C · S/N 52963Cancelled Nov 20, 1975 · Exported to Canada · East Coast Aircraft Sales IncN3359RCessna 182S · S/N 18258659Cancelled Sep 18, 1974 · Exported to Canada · East Coast Aircraft Sales IncN9565MMooney M20F · S/N 670142Cancelled May 22, 1974 · Exported to Germany · Hill & Hills Investment BrokersN7809PPiper PA-24-180 · S/N 24-3029Cancelled Jun 25, 1973 · Mumma Robert EN9948CLuscombe 8F · S/N S-52Cancelled Sep 5, 1972 · Exported to Canada · Gochnauer Paul HN8832UCessna 172F · S/N 17252742Cancelled Jan 14, 1972 · Bindery Associates IncN123KMonocoupe MONOPREP · S/N 6080Cancelled Jan 19, 1971 · Built 1929 · Boggs Bruce A SrN8526EAeronca 7FC · S/N 7FC-335Cancelled Nov 24, 1970 · Built 1959 · Garden Spot AirportN3240VBeech 35 · S/N D-684Cancelled Sep 16, 1952 · John W Eshelman & Sons IncN23478Piper J3F-50 · S/N 3214Cancelled Sep 24, 1948 · George Grant McginnessN99623Ercoupe 415-C · S/N 2246Cancelled Jul 30, 1948 · Enders J HarryN14559Aeronca C-3 · S/N A-510Cancelled Jul 27, 1948 · Easton Orville RushN138MMoth 60-GM · S/N 98Cancelled Feb 17, 1948 · Built 1929 · Hess John HentyN484Aeromarine Klemm L 25 A · S/N 2Cancelled May 13, 1937 · Dagen M C & Kauffman C PN199KMonocoupe 90 · S/N 533Cancelled Jul 25, 1935 · Marchetti VirginioN790WGeltz Roy K GELTZ DE LUX · S/N 5Cancelled Mar 15, 1935 · Geltz Roy KN7284PPiper PA-24 · S/N 24-2461Cancellation date not recorded · Duckworth Gene W
Back to Lancaster, PA