Cancelled registrations · 19

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 = 'MN' AND d.registrant_city = 'OWATONNA' 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 = 'MN' AND d.registrant_city = 'OWATONNA'
  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 = 'MN' AND d.registrant_city = 'OWATONNA'
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.

N61346Winkelman Tj/Winkelman Aa EXPERIMENTAL · S/N 1Cancelled Jul 14, 2017 · Registration expired, pending cancellation · Winkelman Thomas J N990JKJohn Klatt Airshow WACO REPLICA · S/N 001Cancelled Jan 30, 2014 · John Klatt Airshows Inc N923RCCrawford Richard A KITFOX IV · S/N 1604Cancelled Mar 11, 2013 · Sale reported, canceled · Built 1992 N4330YYates ED S-6 E S II · S/N 0192253Cancelled Dec 13, 2012 · Registration expired, pending cancellation · Yates Ed R N67640Cessna 152 · S/N 15281956Cancelled Aug 16, 2012 · Exported to Brazil · Built 1978 · Kubicek Daryl D N11424Waco QCF · S/N 3493Cancelled Dec 30, 2009 · Exported to Brazil · Built 1931 · Rare Aircraft Ltd N195RAAmerican Champion 7GCBC · S/N 1364-2004Cancelled Dec 18, 2006 · Exported to Canada · Built 2004 · Rare Aircraft Ltd N865SWWilker Sedney J DRAGONFLY · S/N 658Cancelled Feb 7, 1995 · Triennial form not returned · Wilker Sidney J N8024WRobinson Helicopter R22 BETA · S/N 1047Cancelled Nov 5, 1991 · Km Helicopter Service N5424DBeech H35 · S/N D4928Cancelled May 24, 1976 · Walsh Thomas J N97550Stinson 108 · S/N 108-550Cancelled Jan 29, 1975 · Exported to Canada · Built 1943 · Bireland Russell O N8620CPiper PA-22-135 · S/N 22-1296Cancelled Jan 23, 1975 · Exported to Canada · Built 1953 · Piguet Terrell W N6048YPiper PA-23-250 · S/N 27-3236Cancelled Jan 20, 1972 · Exported to Canada · Cashman Nurseries Inc N6171DPiper PA-22-150 · S/N 22-4818Cancelled Jul 7, 1971 · Exported to Canada · Built 1957 · Elsner Vincent H N17982Piper J-2 · S/N 1582Cancelled Feb 20, 1956 · Built 1937 · Wilson Lloyd R And Melvin R And Earl D N244NAmerican Eagle 201 · S/N 824Cancelled Nov 15, 1955 · Built 1930 · Schneider Eldon N15001Piper E-2 · S/N 180Cancelled Oct 6, 1955 · Built 1935 · Springer Joseph J N13621Meschke Erwin C PIETENPOL · S/N 1933Cancelled Mar 15, 1939 · Built 1933 · Wolesky Louis E N13618Orlowske Guy ALCO SPORT · S/N 2Cancelled Jul 15, 1935 · Built 1933 · Orlowske Guy

Back to Owatonna, MN