Skip to content

Cancelled registrations · 51

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

N684EXTextron 208B · S/N 208B5684Cancelled Aug 20, 2024 · Built 2022 · Ati Engineering Services LLC N270FJTextron 208B · S/N 208B5720Cancelled Aug 19, 2024 · Built 2023 · Ati Engineering Services LLC N271FJTextron 208B · S/N 208B5721Cancelled Aug 19, 2024 · Built 2023 · Ati Engineering Services LLC N827SBBeech 400A · S/N RK-2Cancelled Sep 19, 2022 · Registration expired, pending cancellation · Built 1990 · Tri State Charter Leasing LLC N818YPDJI PHANTOM 3 PROFESSION · S/N CE281603313247Cancelled Sep 4, 2020 · Registration expired, pending cancellation · University Of Pittsburgh At Johnstown N9367NPiper PA-28R-200 · S/N 28R-35075Cancelled Nov 6, 2018 · Revoked, canceled · Built 1969 · Morrow Ben DBA N30700Piper J3L-65 · S/N 5029Cancelled Oct 28, 2017 · Revoked, canceled · Built 1940 · Ace Flying Club N7064XCessna 150A · S/N 15059164Cancelled Jul 18, 2017 · Registration expired, pending cancellation · Built 1961 · Benko Michael C N446STPiper PA46-500TP · S/N 4697414Cancelled Feb 3, 2016 · Exported to South Africa · Built 2009 · Pipac Inc N5094KCessna 172N · S/N 17273965Cancelled Nov 12, 2013 · Registration expired, pending cancellation · Built 1980 · Creger Lloyd D N8531ZFabina-Carney KR-2 · S/N 231-309Cancelled May 22, 2013 · Sale reported, canceled · Built 1981 N5407GCessna 404 · S/N 404-0026Cancelled Apr 9, 2013 · Registration expired, pending cancellation · Built 1977 · Stiles Walter A N2809ACessna 180 · S/N 30009Cancelled Jul 20, 2009 · Registration revoked · Built 1953 · Cambria Leasing Corp N95LNCessna T206H · S/N T20608549Cancelled Apr 21, 2009 · Exported to Venezuela · Built 2005 · Nulton Diagnostic & Treatment Center Pc N9082XMisler Howard Michael MERLIN · S/N 94012Cancelled Feb 29, 2000 · Triennial form not returned · Misler Howard M N910MVWilliams Mark P SONERAI II L · S/N 01615LTCancelled Jun 20, 1995 · Triennial form not returned · Williams Mark P N5945TCessna 150D · S/N 15060645Cancelled Apr 11, 1991 · Triennial form not returned · Gilman Charles O N999AKDehavilland DHC-6-300 · S/N 424Cancelled Jan 2, 1991 · Exported to Kenya · Aircraft Marketing Leasing Corp N80190Chamberlain Harry L KR-1 · S/N 192-01-7391Cancelled Jan 13, 1984 · Administratively canceled · Chamberlain Harry L N9029DPiper PA-22-160 · S/N 22-6166Cancelled Nov 18, 1981 · Mcmarlin Richard N988APiper PA-22 · S/N 22-300Cancelled Oct 15, 1981 · Biehl Bruce A N98773Piper J3C-65 · S/N 19010Cancelled Aug 23, 1978 · Exported to Philippines · Russo James F N3838WPiper PA-32-260 · S/N 32-1155Cancelled Aug 31, 1977 · Reese Electric Supply Inc N153MCPiper PA-31-350 · S/N 31-7305084Cancelled May 6, 1975 · Built 1973 · W C Mcquaide Inc N125AEBeech 99 · S/N U-125Cancelled May 21, 1974 · Air East Inc N153MCPiper PA-30 · S/N 301998Cancelled Mar 1, 1973 · Built 1969 · W C Mcquaide Inc N33799Aeronca 65-TL · S/N 9521Cancelled Dec 2, 1970 · Built 1941 · Chisholm Marquis N2103UBrantly B-2 · S/N 149Cancelled Oct 29, 1963 · Built 1961 · Berkebile Oil Co N3060HForney 415-C · S/N 3685Cancelled Jul 19, 1961 · Exported to Canada · Raymond E Johnson Jr N85289Aeronca 7AC · S/N 7AC-4027Cancelled Dec 4, 1956 · Luther Flying Service Co N51005Fairchild M-62A · S/N T42-3085Cancelled Jan 24, 1956 · Omer Jack L N2121MPiper J3C-65 · S/N 20907Cancelled Oct 17, 1955 · Johnstown Airways Inc N75558Consolidated Vultee BT-15 · S/N 8983Cancelled Jun 7, 1950 · Built 1943 · Botter William J N8224KStinson 108-1 · S/N 108-1-1224Cancelled May 31, 1950 · Built 1946 · Birk Anthony J N76363Cessna 140 · S/N 10780Cancelled Feb 13, 1950 · Johnstown Airways Inc N4287MPiper PA-12 · S/N 12-3219Cancelled Feb 9, 1950 · Built 1947 · Oppy Harry R N4446MPiper PA-12 · S/N 12-3398Cancelled Feb 9, 1950 · Johnstown Airways Inc N4536HPiper PA-15 · S/N 15-310Cancelled Feb 9, 1950 · Faust Lynn & Gindlesperger Paul N4573HPiper PA-15 · S/N 15-347Cancelled Feb 9, 1950 · Cahill W F N6101MStinson 108-3 · S/N 108-4101Cancelled Feb 9, 1950 · Built 1947 · Thackray Richard M N14119Aeronca C-3 · S/N A-419Cancelled Apr 9, 1948 · Robson Edward & Palenik Stephen N582MMoth 60-GM · S/N 83Cancelled Feb 17, 1948 · Built 1929 · Phillips William Ashley N11615Piper E-2 · S/N 15Cancelled Mar 12, 1943 · Hunt Raymond W Charles M Rogers Walter M Kocher N36092Taylorcraft BL-65 · S/N 3059Cancelled Dec 31, 1941 · Morrison Myron S N15684Koss George K1 · S/N 1Cancelled Feb 13, 1940 · George Koss N15260Aeronca C-3 · S/N A-581Cancelled Apr 8, 1937 · Hart Robert S N760KWaco GXE · S/N 2086Cancelled Jul 3, 1935 · Young Alfred K N765WButters William A BUTTERS · S/N A-1Cancelled Aug 29, 1931 · Built 1930 · Butters William A N6790Curtiss JN4C · S/N C-5Cancelled Jul 15, 1930 · Joseph Shelton Kyler N700Standard J-1 · S/N N-122Cancelled May 2, 1930 · Belanger George H

Back to Johnstown, PA