Skip to content

Piper Aircraft Corp

Earlier aircraft under this name · 1,681

Cancelled registrations that named this owner when they ended, newest first.

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_name = 'PIPER AIRCRAFT CORP' OR list_contains(d.other_registrant_names, 'PIPER AIRCRAFT CORP') 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_name = 'PIPER AIRCRAFT CORP' OR list_contains(d.other_registrant_names, 'PIPER AIRCRAFT CORP')
  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_name = 'PIPER AIRCRAFT CORP' OR list_contains(d.other_registrant_names, 'PIPER AIRCRAFT CORP')
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.

N9514PPiper PA-25-260 · S/N 25-7405601Cancelled Jul 29, 2015 · Exported to Pakistan · Lock Haven, PA N482PEPiper PA-48 · S/N 48-8301002Cancelled Jun 18, 2013 · Registration expired, pending cancellation · Lakeland, FL N481PEPiper PA-48 · S/N 48-8301001Cancelled Jun 7, 2013 · Registration expired, pending cancellation · Built 1983 · Lakeland, FL N57770Piper PA-36-285 · S/N 36-7660078Cancelled Apr 23, 2013 · Registration expired, pending cancellation · Built 1977 · Lock Haven, PA N9290PPiper PA-24-260 · S/N 24-4743Cancelled Sep 26, 2008 · Exported to Madagascar · Built 1968 · Lock Haven, PA N9357WPiper PA-28-235 · S/N 2811046Cancelled Oct 29, 1997 · Exported to United Kingdom · Vero Beach, FL N9249JPiper PA-28-161 · S/N 2816110Cancelled Jul 19, 1995 · Exported to Australia · Vero Beach, FL N35646Piper PA-46-310P · S/N 468408001Cancelled Aug 13, 1993 · Triennial form not returned · Vero Beach, FL N76TSSmith AEROSTAR 601P · S/N 61P0266054Cancelled Feb 13, 1991 · Triennial form not returned · Vero Beach, FL N62957Piper PA-31-350 · S/N 31-7752005Cancelled Nov 16, 1984 · Lock Haven, PA N44256Piper PA-32R-300 · S/N 32R-7680001Cancelled Sep 15, 1983 · Built 1974 · Lakeland, FL N32834Piper PA-32-300L · S/N 327845001Cancelled Aug 31, 1983 · Built 1975 · Lakeland, FL N4099YPiper PA-42 · S/N 42-8001068Cancelled May 26, 1983 · Exported to Colombia · Built 1981 · Lakeland, FL N2366YPiper PA-36-375 · S/N 36-8102002Cancelled May 2, 1983 · Exported to Mexico · Built 1981 · Lock Haven, PA N60770Piper AEROSTAR 601P · S/N 61P-0726-8063352Cancelled Apr 15, 1983 · Exported to Mexico · Lock Haven, PA N7322LPiper PA-31P · S/N 31P-75Cancelled Apr 6, 1983 · Lock Haven, PA N4300BPiper PA-32-301 · S/N 32-8306010Cancelled Mar 28, 1983 · Exported to Bolivia · Vero Beach, FL N2605VPiper PA-38-112 · S/N 38-82A0078Cancelled Mar 10, 1983 · Exported to Australia · Lock Haven, PA N9421PPiper PA-18-150 · S/N 189004Cancelled Jan 26, 1983 · Administratively canceled · Lockhaven, PA N2872YPiper PA-32-300 · S/N 32-7940169Cancelled Nov 5, 1982 · Exported to Cameroon · Lock Have, PA N47638New Piper PA-28-181 · S/N 28-7890107Cancelled Aug 31, 1982 · Lock Haven, PA N8379PPiper PA-28-161 · S/N 28-8116214Cancelled Aug 7, 1982 · Exported to Trinidad and Tobago · Vero Beach, FL N35646Piper PA-46-300 · S/N 46-E1Cancelled Jul 22, 1982 · Built 1979 · Vero Beach, FL N4168EPiper PA-36-300 · S/N 368060008Cancelled Feb 5, 1982 · Exported to Swaziland · Built 1980 · Lock Haven, PA N25424Piper PA-38-112 · S/N 38-80A0098Cancelled Nov 30, 1981 · Exported to Brazil · Built 1980 · Lock Haven, PA N642TWPiper PA-42 · S/N 42-8001062Cancelled Nov 14, 1981 · Lakeland, FL N4167EPiper PA-36-300 · S/N 368060005Cancelled Nov 13, 1981 · Exported to South Africa · Built 1980 · Lock Haven, PA N4081APiper PA-31-350 · S/N 31-8152056Cancelled Nov 5, 1981 · Exported to Chile · Built 1980 · Lock Haven, PA N56346Piper PA-38-100 · S/N 38-7320001Cancelled Oct 15, 1981 · Vero Beach, FL N34PAPiper PA-34-180 · S/N 34-E4Cancelled Oct 13, 1981 · Built 1969 · Vero Beach, FL N36PAPiper PA-36-260 · S/N 36-E1Cancelled Sep 30, 1981 · Built 1969 · Vero Beach, FL N3535CPiper PA-35 · S/N 35-E1Cancelled May 18, 1981 · Built 1968 · Lakeland, FL N56165Piper PA-34-200 · S/N 34-7350295Cancelled May 8, 1981 · Exported to Panama · Vero Beach, FL N4273TPiper PA-28-180 · S/N 28-E-10Cancelled May 6, 1981 · Built 1971 · Vero Beach, FL N83071Piper PA-32R-301 · S/N 32R-8013067Cancelled Mar 25, 1981 · Exported to Chile · Lock Haven, PA N83072Piper PA-28-161 · S/N 28-8116098Cancelled Mar 25, 1981 · Exported to Chile · Lock Haven, PA N2444FPiper PA-38-112 · S/N 38-79A0448Cancelled Feb 9, 1981 · Exported to Spain · Built 1979 · Lock Haven, PA N8239DPiper PA-34-200T · S/N 34-8070285Cancelled Feb 4, 1981 · Exported to Chile · Lock Haven, PA N7660CPiper PA-32RT-300T · S/N 32RT-7787001Cancelled Jan 29, 1981 · Lakeland, FL N2418VPiper PA-36-375 · S/N 36-8002024Cancelled Jan 9, 1981 · Exported to South Africa · Lock Haven, PA N24968Piper PA-38-112 · S/N 38-79A0919Cancelled Dec 31, 1980 · Exported to Italy · Built 1979 · Lock Haven, PA N57813Piper PA-36-300 · S/N 36-7760001Cancelled Dec 31, 1980 · Exported to Honduras · Lock Haven, PA N2505DPiper PA-38-112 · S/N 38-79A0343Cancelled Dec 22, 1980 · Exported to Israel · Built 1978 · Lock Haven, PA N24688Piper PA-38-112 · S/N 38-79A1161Cancelled Dec 16, 1980 · Exported to Spain · Built 1979 · Lock Haven, PA N25235Piper PA-38-112 · S/N 38-79A0930Cancelled Dec 5, 1980 · Exported to Panama · Built 1979 · Lock Haven, PA N3921EPiper PA-36-375 · S/N 36-7802058Cancelled Nov 26, 1980 · Exported to Spain · Built 1978 · Lock Haven, PA N2969VPiper PA-28RT-201 · S/N 28R-7918242Cancelled Oct 31, 1980 · Exported to France · Built 1979 · Lock Haven, PA N24684Piper PA-38-112 · S/N 38-79A1160Cancelled Oct 23, 1980 · Exported to Italy · Built 1979 · Lock Haven, PA N9317TPiper PA-38-112 · S/N 38-78A0027Cancelled Oct 23, 1980 · Exported to Italy · Lock Haven, PA N59900Piper PA-31P · S/N 31P-73Cancelled Oct 7, 1980 · Lock Haven, PA

Back to Piper Aircraft Corp