OpenAirDocs.org
Fort Dodge, IA

Cancelled registrations · 32

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 = 'FORT DODGE'
  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.

N680HEDJI PHANTOM 2 VISION + · S/N PH645466264Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Jenson Builders LtdN647DBDJI PHANTOM 3 PROFESSION · S/N P76DCG29016822Cancelled May 6, 2019 · Registration expired, pending cancellation · Panbecker Terry AN5592ZPiper PA-22-108 · S/N 22-9402Cancelled Sep 16, 2016 · Registration expired, pending cancellation · Built 1962 · Phillips LeeN199CHenry David MINI 500 · S/N 447Cancelled Aug 13, 2013 · Sale reported, canceled · Built 1999N17CHCessna 402B · S/N 402B0519Cancelled Jul 18, 2013 · Registration expired, pending cancellation · Built 1973 · Carney & Hancock IncN88952Piccard Don AX-6 · S/N 6Cancelled May 17, 2013 · Registration expired, pending cancellation · Built 1965 · Kersten Don NN76GRaven S-40A · S/N S40A-123Cancelled May 9, 2013 · Registration expired, pending cancellation · Built 1972 · Beukelman David PN6517QAerostar International RAVEN S-55A · S/N S55A-3028Cancelled Sep 28, 2012 · Registration pending, canceled · Built 1987N2655APiper PA-22-135 · S/N 22-925Cancelled Aug 23, 2012 · Sale reported, canceled · Built 1952N65EBBeech 200 · S/N BB325Cancelled Jul 21, 2011 · Built 1977 · Clement Aviation IncN4947ECessna 172N · S/N 17271682Cancelled Feb 23, 2010 · Exported to Colombia · Clement Aviation IncN122LBRasch Kim Joseph STRIPLIN LONE RANGER · S/N 810163LRCancelled Dec 11, 2003 · Second triennial mailing, no response · Rasch Kim JosephN1792Cassutt SPORT RACER · S/N 0003Cancelled Dec 23, 1999 · Triennial form not returned · Newsham Louis RN6596CCessna T210N · S/N 21063925Cancelled Oct 16, 1995 · Exported to Canada · Mcclure Engineering CompanyN637Taylor FTX 01 · S/N FTX01Cancelled Dec 15, 1993 · Triennial form not returned · Taylor Francis FN797MSSmith Merlyn D MS-2 · S/N MS-2Cancelled Dec 13, 1985 · Smith Merlyn DN38235Piper PA-32R-300 · S/N 32R7780406Cancelled Oct 25, 1983 · Exported to Canada · Built 1977 · Michaels Thomas JN4668KCessna 182P · S/N 182-63669Cancelled Dec 23, 1981 · Fort Dodge Aviation IncN214JCClarke BIPLANE (ORIGINAL) · S/N WC3Cancelled May 4, 1981 · Built 1976 · Clarke John EN36214Taylorcraft BL-65 · S/N 3177Cancelled Feb 17, 1981 · Taylor Francis FN733BFCessna 172N · S/N 17268162Cancelled Mar 18, 1977 · Exported to Canada · Fort Dodge Aviation IncN35272Cessna 177B · S/N 17702302Cancelled Jul 29, 1975 · Exported to Canada · Fort Dodge Aviation IncN76726Cessna 120 · S/N 11158Cancelled Apr 24, 1974 · Weiland Garrett GordonN31860Aeronca 65-TC · S/N CA11470Cancelled May 26, 1971 · Built 1940 · Knutson Robert HN8418ABeech A35 · S/N D-1853Cancelled Jul 13, 1956 · Swaney Buick CompanyN64526Timm N2T-1 · S/N 142Cancelled Feb 17, 1956 · Nesler E RN20555Taylorcraft A · S/N 565Cancelled Oct 19, 1955 · Langelle John PN3171EAeronca 11AC · S/N 11AC1511Cancelled Oct 4, 1951 · Beck Robert EN2490HEngineering & Research ERCOUPE 415-C · S/N 3115Cancelled May 21, 1951 · Built 1946 · Manchester Stanley AN54773Consolidated Vultee BT-13A · S/N 3380Cancelled Jun 8, 1948 · Eno Ellis EN589MMoth 60-GM · S/N 90Cancelled Feb 17, 1948 · Built 1929 · Iowa Airways CorporationN9602Stinson SM2K · S/N 1029Cancelled Mar 6, 1941 · Eno Ellis Eugene
Back to Fort Dodge, IA