Skip to content

Cancelled registrations · 68

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

N4211Harry J Menear BP-1 · S/N 1Cancelled Aug 27, 2025 · Built 2022 · Menear Harry J N99912Ercoupe 415-C · S/N 2535Cancelled Apr 27, 2024 · Sale reported, canceled · Built 1946 N3519XMooney M20F · S/N 670057Cancelled Mar 15, 2023 · Third renewal notice · Built 1966 · Spagnolo Joseph P N6246LLoehrke Timothy Don KOLB FIRESTAR 2 · S/N FS592Cancelled Feb 4, 2023 · Registration expired, pending cancellation · Built 1997 · Rowe Lloyd C N577NPDraganfly Innovations DRAGANFLYER X4-P · S/N 08F372Cancelled Jul 26, 2022 · Registration expired, pending cancellation · Pennsylvania Department Of Transportation N577DDRobinson Helicopter R66 · S/N 0675Cancelled Apr 2, 2022 · Registration expired, pending cancellation · Built 2015 · Donagair N607MBPrecision Hawk LANCASTER MK IV · S/N PCN-048-201548-025-MSICancelled Feb 3, 2020 · Registration expired, pending cancellation · Michael Baker International Inc N7845YYuneec International TYPHOON Q500 4K · S/N YU15370519B04C01Cancelled Feb 3, 2020 · Registration expired, pending cancellation · Joy Daniels Real Estate Group N603MBDJI PHANTOM 3 PROFESSION · S/N P76DCD13012554Cancelled Feb 1, 2019 · Registration expired, pending cancellation · Michael Baker International Inc N605MBDJI PHANTOM 2 VISION + · S/N PH645512458Cancelled Feb 1, 2019 · Registration expired, pending cancellation · Michael Baker International Inc N606MBDJI INSPIRE 1 · S/N W13DCC07020449Cancelled Feb 1, 2019 · Registration expired, pending cancellation · Michael Baker International Inc N2222JCessna 140 · S/N 11312Cancelled Jan 12, 2018 · Registration expired, pending cancellation · Brp Aviation Inc N177DDRobinson Helicopter R44 II · S/N 13752Cancelled Jul 21, 2017 · Exported to Canada · Built 2014 · Donagair Inc N4790HHarfmann Joseph TRADEWIND · S/N 0425Cancelled May 23, 2017 · Registration expired, pending cancellation · Harfmann Joseph N24545Thunder Balloons AX7-77Z · S/N 438Cancelled Apr 24, 2017 · Registration expired, pending cancellation · Built 1983 · Harfmann Joseph N1399PPiper PA-23-150 · S/N 23-455Cancelled Sep 14, 2016 · Revoked, canceled · Built 1956 · Horner Robert E N1048BMooney M20A · S/N 1275Cancelled Aug 11, 2016 · Third renewal notice · Built 1958 · Berwager Thomas A N275MBPrecisionhawk HAWKEYE LANCASTER MK · S/N 14HE03080Cancelled May 4, 2016 · Michael Baker International Inc N58190Cameron Balloons US O-84 · S/N 5032Cancelled Dec 3, 2014 · Registration expired, pending cancellation · Built 1983 · Harfmann Joseph N341MCMcdemus Robert MITCHEL WING B-10 · S/N P1203Cancelled Jun 4, 2013 · Registration expired, pending cancellation · Mcdemus Robert A N3776NBurkhart Glenn D B-8M · S/N 1Cancelled Jun 4, 2013 · Registration expired, pending cancellation · Built 1980 · Burkhart Glenn D N4082ABoeing B75N1 · S/N 40-1965Cancelled Dec 13, 2012 · Revoked, canceled · Built 1940 · Lowe Owen R N4308VCessna 195 · S/N 7215Cancelled Nov 21, 2012 · Registration expired, pending cancellation · Built 1948 · Dauphin Flying Club Inc N3521RBeech A23 · S/N M-683Cancelled Oct 4, 2012 · Registration expired, pending cancellation · Built 1965 · First Edition Book Store Inc N54722Cessna T-50 · S/N 5372Cancelled Aug 22, 2012 · Revoked, canceled · Built 1943 · Schenholm Albert C Jr N5424KRyan NAVION · S/N 2324BCancelled Aug 21, 2012 · Revoked, canceled · Built 1951 · Roeting W H N181CCessna 421B · S/N 421B0347Cancelled Aug 13, 2012 · Registration expired, pending cancellation · Built 1972 · Uba Fire & Explosion Invest Inc N19856Taylorcraft A · S/N 361Cancelled Jun 3, 2011 · Sale reported, pending cancellation · Built 1937 N1050EMarkowski Michael A HUMMER · S/N 2Cancelled Nov 12, 2010 · Markowski Michael A N12CGLet BLANIK L-13 · S/N 174525Cancelled Nov 16, 2009 · Triennial form not returned · Built 1970 · Harry Samuel C N15290Aeronca C-3 · S/N A620Cancelled Sep 17, 2009 · Registration revoked · Built 1935 · Doncevic Joseph S N18726Arrow F · S/N 89Cancelled Jul 9, 2009 · Registration revoked · Built 1937 · Doncevic Joseph N16259Aeronca C-3 · S/N A647Cancelled Jun 30, 2009 · Registration revoked · Built 1936 · Doncevic Joseph S N11631Pitcairn PA24 · S/N F38Cancelled Jun 25, 2009 · Registration revoked · Built 1931 · Doncevic Joseph S N6617PPiper PA-24-180 · S/N 24-1738Cancelled Feb 6, 2009 · Triennial form not returned · Built 1960 · Corman Ned E N55JGBucker JUNGMAN BU-131 · S/N 56Cancelled Dec 16, 2008 · Exported to France · Built 1939 · Cjr Wings LLC N617TTDiamond Aircraft Industries HK 36 TTC · S/N 36617Cancelled Jan 27, 2005 · Exported to Germany · Crispen James F N6085UAviat PITTS S-2B · S/N 5303Cancelled Nov 15, 2004 · Triennial form not returned · Built 1994 · Wilson William E N92SXSchaefer Jim RANS S-12 · S/N 0192169Cancelled Jan 11, 2002 · Triennial form not returned · Built 1992 · Schaefer Jim N9070ZBalloon Works FIREFLY 7 · S/N F7644Cancelled Jan 26, 1998 · Triennial form not returned · Carl Theodore R N2205ZPiper PA-28-181 · S/N 287990401Cancelled Oct 28, 1997 · Triennial form not returned · Enterprise Seven Leasing Inc N32307Piper PA-28-151 · S/N 287515122Cancelled Mar 21, 1994 · Triennial form not returned · Trout Richard S N111ALBell 206L · S/N 45024Cancelled May 1, 1991 · Exported to Canada · Sebastiani Albert S N62766Cessna 172P · S/N 17275333Cancelled Dec 13, 1990 · Exported to Netherlands · Hock Wayne N677FBeech 95-B55 (T42A) · S/N TC-1027Cancelled Sep 13, 1982 · Amp Incorporated N12882Heath CNA-40 · S/N C-52Cancelled Mar 18, 1976 · Built 1932 · Doncevic Joseph S N4338NCessna 195 · S/N 7071Cancelled Nov 12, 1971 · Dauphin Flying Club N41529Piper J3C-65 · S/N 8187Cancelled Aug 18, 1971 N99545Engineering & Research 415-C · S/N 2168Cancelled May 27, 1965 · Exported to United Kingdom · Weibley Richard W N6591DSikorsky H-5H · S/N 49-2007ACancelled May 26, 1965 · Commonwealth Of Pennsylvania

Back to Harrisburg, PA