OpenAirDocs.org
Marshalltown, IA

Cancelled registrations · 24

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

N95642Taylorcraft BF · S/N 7942Cancelled Jun 26, 2023 · Revoked, canceled · Built 1946 · Rcr Flyers TheN14PAAdams Paul QUICKIE 2 · S/N 2462Cancelled Jan 16, 2019 · Registration expired, pending cancellation · Adams PaulN486SFPiper PA-32R-300 · S/N 32R7780313Cancelled Apr 24, 2018 · Exported to Canada · Built 1977 · Marshalltown Wings IncN4482CCampbell Duane F QUICKSILVER MX II · S/N 1629Cancelled Sep 12, 2013 · Registration expired, pending cancellation · Built 1983 · Campbell Duane FN3032ZPiper PA-22-160 · S/N 22-6986Cancelled Jul 18, 2013 · Registration expired, pending cancellation · Built 1959 · Campbell Duane FN40962Raven Industries RALLY RX7 · S/N RX7-320Cancelled Jun 25, 2007 · Triennial form not returned · Built 1983 · Strickler Gayle VN8453LPiper PA-28RT-201T · S/N 28R-8231006Cancelled Jun 10, 2005 · Exported to Canada · Built 1981 · Midland Aircraft Sales & Service IncN5987XBrantly B-2 · S/N 125Cancelled Dec 5, 1977 · Burggraaf KevinN4291TPiper PA-32-300 · S/N 32-7240059Cancelled Jan 20, 1976 · Built 1972 · Boston Edward FN8328DBeech J35 · S/N D-5406Cancelled May 17, 1974 · Jet-Cit-Thru IncN5095PPiper PA-24-180 · S/N 24-104Cancelled Jun 25, 1973 · Nine Five Delta CorporationN2627PPiper PA-22-150 · S/N 22-2964Cancelled Apr 29, 1971 · Niederhauser Aviation CorpN98120Piper PA-28-140 · S/N 28-26054Cancelled Jul 10, 1970 · Bens Aircraft Service Inc Of WaterlooN7421DPiper PA-22-150 · S/N 22-5182Cancelled May 31, 1965 · Niederhauser AirwaysN7319DPiper PA-22-150 · S/N 22-5107Cancelled May 21, 1965 · Niederhauser Airways IncN3361NPiper J3C-65 · S/N 22561Cancelled May 20, 1965 · Niederhauser Airways IncN2931MPiper PA-12 · S/N 12-1333Cancelled Dec 12, 1960 · Exported to Canada · Built 1946 · Niederhauser Airways IncN2239Waco EGC-7 · S/N 4562Cancelled Feb 17, 1956 · Built 1937 · Jones Lawrence FN1567NPiper J3C-65 · S/N 23100Cancelled Oct 5, 1955 · Built 1947 · Niederhauser AirwaysN54779Fairchild M-62A · S/N T42-3379Cancelled Nov 6, 1951 · Mears Oswald JN564CStinson 108-3 · S/N 108-3564Cancelled Oct 4, 1951 · Sigmond Aerial Photo CoN39757Waco UPF-7 · S/N 5890Cancelled Sep 7, 1948 · Built 1942 · Niederhauser Airways/Niederhauser Glen T/Harry DN26508Taylorcraft BC-65 · S/N 1849Cancelled Sep 16, 1940 · Niederhauser AirwaysN1610Standard J-1 · S/N 136Cancelled Nov 6, 1928 · Lorenzen Karl
Back to Marshalltown, IA