OpenAirDocs.org
Mt Pleasant, PA

Cancelled registrations · 46

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 = 'MT PLEASANT'
  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.

N80266Superior CULVER V · S/N V185Cancelled May 31, 2017 · Registration expired, pending cancellation · Built 1946 · Fatla Edward FN6948BPiper PA-22-150 · S/N 22-4228Cancelled Nov 13, 2014 · Registration expired, pending cancellation · Built 1956 · Barclay Milton RN8925SCessna 150F · S/N 15062225Cancelled May 17, 2013 · Registration expired, pending cancellation · Built 1965 · Pawlikowski WilliamN5990WPiper PA-28-140 · S/N 28-24794Cancelled Feb 8, 2013 · Sale reported, canceled · Built 1968N9803EAeronca 11AC · S/N 11AC-1454Cancelled Nov 26, 2012 · Sale reported, pending cancellation · Built 1946N41778Jamieson J-1 · S/N 359ARCancelled Nov 20, 2012 · Registration expired, pending cancellation · Built 1943 · Fatla Edward FN4572ZPiper PA-22-108 · S/N 22-8081Cancelled Nov 14, 2012 · Sale reported, canceled · Built 1961N3702APiper PA-22-135 · S/N 22-1944Cancelled Sep 20, 2012 · Sale reported, canceled · Built 1954N19652Cessna 172L · S/N 17260639Cancelled Aug 20, 2012 · Registration expired, pending cancellation · Built 1972 · Barclay Milton R DBAN1704APiper PA-22 · S/N 22-464Cancelled Jul 24, 2012 · Sale reported, canceled · Built 1952N1512PPiper PA-22-135 · S/N 22-2377Cancelled Jun 27, 2012 · Sale reported, canceled · Built 1954N158PBell 206B · S/N 1472Cancelled Oct 14, 1999 · Exported to Australia · Helicopter Aviaiton Services CorpN72383Bell 212 · S/N 30591Cancelled Dec 2, 1997 · Exported to Portugal · Helicopter Aviation Services CorpN4354ZBell 212 · S/N 35056Cancelled Feb 24, 1997 · Exported to Indonesia · Helicopter Aviation Services CorpN2753EBell 206B · S/N 2684Cancelled Aug 29, 1995 · Exported to El Salvador · Helicopter Avn Services CorpN82689Bell 206L-3 · S/N 51012Cancelled Jun 19, 1995 · Exported to Sweden · Helicopter Aviation Services CorpN76439Bell 206-L4 · S/N 52113Cancelled Feb 21, 1995 · Exported to Mexico · Helicopter Aviation Services CorpN215BGBell 206B · S/N 3481Cancelled May 23, 1994 · Exported to Brazil · Helicopter Aviation Services CorpN141MCBell 206B · S/N 3523Cancelled Mar 10, 1994 · Exported to Argentina · Helicopter Aviation Services CorpN130TMBell 206B · S/N 4167Cancelled Jul 23, 1993 · Exported to Mexico · Helicopter Aviation Services CorpN581HBell Helicopter Textron Canada 206B · S/N 4265Cancelled Jul 23, 1993 · Exported to Mexico · Bell Aviation Services CorpN3815HBell 206B · S/N 3815Cancelled Jul 13, 1993 · Exported to Mexico · Helicopter Aviation Services CorpN16783Bell 206L · S/N 45097Cancelled Mar 11, 1993 · Exported to Canada · Helicopter Aviation Services CorpN4289EBell 206L-3 · S/N 51523Cancelled May 8, 1992 · Exported to Malaysia · Built 1991 · Helicopter Aviation Services CorpN2674QBell 212 · S/N 30667Cancelled Apr 2, 1992 · Exported to Mexico · Helicopter Aviation Services CorpN176EHSikorsky S-76A · S/N 760065Cancelled May 23, 1991 · Exported to Canada · Helicopter Aviation Services CorpN48UBell 206B-III · S/N 3182Cancelled Apr 24, 1991 · Exported to Australia · Built 1980 · Helicopter Aviation Services CorporationN21824Bell 206B-III · S/N 3817Cancelled Apr 10, 1991 · Exported to Japan · Helicopter Aviation Services CorpN711FCBell 206B · S/N 2479Cancelled Apr 10, 1991 · Exported to Japan · Helicopter Avn Services CorpN9243ABell Helicopter Textron 206L-1 · S/N 45159Cancelled Mar 19, 1991 · Exported to Canada · Helicopter Aviation Svcs CorpN3172WBell 206B · S/N 3676Cancelled Dec 4, 1990 · Exported to South Africa · Helicopter Aviation Svcs CorpN71758Bell 206L-3 · S/N 51346Cancelled May 16, 1990 · Exported to South Africa · Helicopter Aviation Services CorpN2114CBell 206L-3 · S/N 51308Cancelled Oct 5, 1989 · Exported to Philippines · Built 1989 · Helicopter Aviation Services CorpN900JBBell 206B · S/N 3825Cancelled Jun 12, 1989 · Exported to South Africa · Helicopter Aviation Services CorpN92ZTBell Helicopter Textron 206L-1 · S/N 45439Cancelled Feb 14, 1989 · Exported to Canada · Helicopter Aviation Services CorpN91ZTBell Helicopter Textron 206L-1 · S/N 45213Cancelled Nov 21, 1988 · Exported to Australia · Helicopter Avaition Services CorpN1221YCessna 150B · S/N 15059621Cancelled Jul 14, 1980 · Built 1962 · Chestnut Ridge Flying Club IncN30406Piper J4 · S/N 4-1187Cancelled Jul 19, 1974 · Raygor Kurtiss EN84807Aeronca 7AC · S/N 7AC-3522Cancelled Feb 17, 1971 · Mt Pleasant-Scottsdale AirportN3614EAeronca 11BC-CONV · S/N 11AC-1825Cancelled Jan 15, 1971 · Mt Pleasant Scottdale AirportN1290YCessna 150B · S/N 15059690Cancelled Jun 30, 1970 · Milton BarclayN5487MTaylorcraft BC12-D1 · S/N 10787Cancelled Jun 30, 1970 · Mt Pleasant-Scottdale AirportN25213Luscombe 8A · S/N 1155Cancelled Jun 2, 1965 · Albert BeranekN9049HBeech AT-10 · S/N 338Cancelled May 22, 1965 · Built 1948 · Mt Pleasant-Scottdale AirportN69471Cessna T-50 · S/N 1170Cancelled Apr 22, 1954 · Tepper Tomas BN6039HPiper J3C-65 · S/N 19182Cancelled Nov 27, 1953 · Mt Pleasant Scottdale Airport
Back to Mt Pleasant, PA