OpenAirDocs.org
Mason City, IA

Cancelled registrations · 33

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 = 'IA' AND d.registrant_city = 'MASON CITY'
  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.

N2246NCessna 140 · S/N 12482Cancelled Jan 2, 2018 · Registration expired, pending cancellation · Built 1947 · Harley-Davidson Inc Of Mason CityN108RSCessna 402B · S/N 402B-0440Cancelled Sep 1, 2016 · Third renewal notice · Built 1973 · Dwyer Aircraft Sales IncN48177Boeing A75N1(PT17) · S/N 75-1035Cancelled Oct 14, 2014 · Registration expired, pending cancellation · Built 1941 · Vinces Aerial Sparying IncN2891SCessna 150G · S/N 15066791Cancelled Sep 29, 2014 · Registration expired, pending cancellation · Built 1967 · Dwyer Aircraft Sales IncN2105ECessna 172N · S/N 17271158Cancelled Jun 7, 2013 · Sale reported, canceled · Built 1978N55425Piper PA-34-200 · S/N 34-7350213Cancelled Apr 22, 2013 · Registration expired, pending cancellation · Built 1973 · Dwyer Aircraft Sales IncN55643Piper PA-34-200 · S/N 34-7350234Cancelled Apr 22, 2013 · Registration expired, pending cancellation · Built 1973 · Dwyer Aircraft Sales IncN2982Smith INOVATION · S/N 5721129Cancelled Feb 25, 2013 · Registration expired, pending cancellation · Built 1971 · Rozendaal Douglas NN3801FGreat Lakes 2T-1A-2 · S/N 0769Cancelled Jan 27, 2010 · Registration revoked · Built 1977 · D And D Aviation IncN6992LCessna 310K · S/N 310K0092Cancelled Aug 8, 2000 · Triennial form not returned · Northern Aviation IncN8029VSchabacker Konrad J KR-2 · S/N KJS1941Cancelled Dec 24, 1998 · Schabacker Konrad JN38925Sappenfield RIAN ST 2 POLM · S/N 1228231BCancelled Jul 21, 1995 · Triennial form not returned · Sappenfield David RN27064Balloon Works FIREFLY 7 · S/N 777Cancelled Feb 10, 1992 · Triennial form not returned · Johnson John JN64RCPruzek CASSUTT 3-M · S/N FP-1Cancelled Dec 18, 1985 · Ouverson Thomas EN6643UMooney M20D · S/N 138Cancelled May 26, 1976 · Mayfield Duane EN18658Cessna 150L · S/N 150 74020Cancelled Jun 26, 1975 · Exported to Canada · Built 1972 · Dwyer Aircraft Sales IncN3645PPiper PA-22-150 · S/N 22-3396Cancelled May 23, 1975 · Built 1956 · Johnson Dwayne GN3714PPiper PA-22-150 · S/N 22-3432Cancelled Jan 25, 1972 · Klunder Roger DaleN4782TPietenpol AIR CAMPER · S/N 1658Cancelled Jul 27, 1965 · Built 1965 · Jensen W ON2233CCessna 180 · S/N 30533Cancelled Jun 3, 1965 · Dwyer Flying ServiceN4872HPiper PA-17 · S/N 17-171Cancelled Jul 13, 1961 · Exported to Canada · Dwyer H JN3794NBeech 35 · S/N D-1019Cancelled Mar 25, 1959 · Built 1947 · Dwyer Flying ServiceN29266Culver LCA · S/N 135Cancelled Feb 23, 1956 · Built 1940 · Dyre ElmerN57596Cessna T-50 · S/N 4674Cancelled Feb 14, 1956 · Dyre ElmerN19597Taylor J-2 · S/N 1797Cancelled Apr 11, 1951 · Built 1937 · Storey Joseph AN7565HPiper PA-12 · S/N 12-434Cancelled Jun 7, 1949 · Air ActivitiesN16452Cessna C-34 · S/N 329Cancelled Jan 22, 1947 · Kirk Charles MN10887Stinson JR. S · S/N 8064Cancelled Jul 1, 1943 · Built 1931 · Hugelen S ON8325Curtiss Wright ROBIN · S/N 202Cancelled Apr 5, 1940 · Lessor Archie Theron I LessorN3821Travel Air Mfg 2000 · S/N 304Cancelled Nov 15, 1938 · Randall Seth WN19761Aeronca K · S/N K-277Cancelled Oct 15, 1938 · North Iowa Flying ServiceN2765Waco 9 · S/N 322Cancelled Feb 23, 1934 · Mckee Charles JN113Curtiss Wright JN4C · S/N 117Cancelled Apr 4, 1930 · Built 1927 · Barrett George C
Back to Mason City, IA