OpenAirDocs.org
Waterloo, IA

Cancelled registrations · 280

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

N6311NChampion 7ECA · S/N 226Cancelled Jun 24, 1975 · Exported to Canada · Schleusner Frank WN70275Piper J3C-65 · S/N 17256Cancelled Apr 10, 1974 · Stricker ClausN8823BCessna 172 · S/N 36523Cancelled Feb 23, 1972 · Clipper ClubN339FKTaylorcraft BL-65 · S/N 2847Cancelled Jan 5, 1972 · Exported to Canada · Built 1941 · Niederhauser Airways IncN48222Fairchild M-62A · S/N 306SLCancelled Dec 1, 1971 · Built 1944 · Smith John FranklinN8853North American F-86H · S/N 53-1300Cancelled Sep 18, 1970 · Hawkeye Institute Of TechnologyN6456PPiper PA-24-250 · S/N 24-1571Cancelled Aug 10, 1962 · Exported to Canada · Niederhauser Airways IncN5308HPiper PA-16 · S/N 16-113Cancelled Jun 13, 1962 · Exported to Canada · Niederhauser Airways IncN73616Fairchild M-62A-3 · S/N FX-194Cancelled Feb 20, 1956 · Canfield AirwaysN64533Cessna T-50 · S/N 2675Cancelled Feb 17, 1956 · Built 1943 · Canfield AirwaysN48135Fairchild M-62A · S/N 5943AECancelled Nov 25, 1955 · Built 1943 · Nightingale Ralph A And Mcdaniel RichardN54775Fairchild M-62A · S/N T-42-3625Cancelled Oct 11, 1955 · Triangle Flying ClubN83165Aeronca 7AC · S/N 7AC-1826Cancelled Aug 11, 1955 · Canfield AirwaysN69638Consolidated Vultee BT-13A · S/N 2545Cancelled Apr 8, 1955 · Marquis M D Fred MN2297VCessna 140 · S/N 14533Cancelled Sep 16, 1952 · Sternat Alex FN381AMooney M-18L · S/N 42Cancelled Aug 14, 1951 · Canfield AirwaysN54797Convair BT-13B · S/N 79-1158Cancelled Jan 31, 1951 · Canfield AirwaysN86240Aeronca 11AC · S/N 11AC-44Cancelled Dec 13, 1950 · Canfield AirwaysN50173Fairchild PT-19 · S/N T42-3704Cancelled Jul 25, 1950 · Richared J Stanhop / Robert A AldrichN54789Consolidated Vultee BT-13A · S/N 3420Cancelled May 11, 1950 · Canfield AirwaysN54700Fairchild M-62A · S/N T42-3945Cancelled Jul 5, 1949 · Hollett Harry AN96617Taylorcraft BC12-D · S/N 8917Cancelled May 10, 1949 · Canfield AirwaysN20769Beech F17D · S/N 307Cancelled May 28, 1948 · Built 1939 · Henry Marshall PN871American Eagle A-27 · S/N 25Cancelled Apr 1, 1940 · Lufkin RichardN22351Aeronca 50-L · S/N L-3519Cancelled Jul 4, 1939 · Berry Ray ON11433Waco RNF · S/N 3463Cancelled Jul 10, 1938 · Built 1931 · Livingston Airways CorpN15748Aeronca C-3 · S/N A-640Cancelled Aug 31, 1936 · Neal Jerry LN57YCessna CR-3 · S/N 3Cancelled Aug 14, 1933 · Livingston Airways CorpN2326Curtiss JN-4 · S/N 151Cancelled Dec 31, 1928 · Livingston John HN63Standard J-1 · S/N J-1Cancelled Dec 28, 1928 · Cable John W
Back to Waterloo, IA