Cancelled registrations · 18

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 = 'WI' AND d.registrant_city = 'SHAWANO' 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 = 'WI' AND d.registrant_city = 'SHAWANO'
  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 = 'WI' AND d.registrant_city = 'SHAWANO'
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.

N10UUHickham John LANCAIR IV-P · S/N LIV-417Cancelled May 4, 2019 · Registration expired, pending cancellation · Built 2002 · Fast Flying LLC N8048YBuckeye BREEZE · S/N 16293Cancelled Jun 19, 2017 · Registration expired, pending cancellation · Klement Cory G N774EDornier DO28 A-1 · S/N 3022Cancelled Sep 29, 2014 · Exported to United Kingdom · Built 1961 · Grognet Eunice N5627PPiper PA-24 · S/N 24697Cancelled Sep 2, 1991 · Fenix Floyd L N9961QPiper PA-18-135 · S/N 18-3947Cancelled Jul 19, 1978 · Exported to Canada · Built 1955 · Shawano Flying Service Inc N9956QPiper PA-18-135 (L-21B) · S/N 18-3927Cancelled Jul 19, 1977 · Exported to Canada · Built 1955 · Shawano Flying Service Inc N775EDehavilland BEAVER DHC-2 MK.1 · S/N 1134Cancelled Apr 15, 1977 · Exported to Canada · Grognet Cj N9830QPiper PA-18-135 · S/N 18-3330Cancelled Nov 10, 1976 · Exported to Canada · Built 1976 · Shawano Flying Service N62354Dehavilland DHC-2 MK 1 · S/N 1392Cancelled Aug 18, 1975 · Exported to Canada · Shawano Flying Service N41687Bellanca 7GCBC · S/N 590-73Cancelled Nov 15, 1973 · Exported to Canada · Shawand Flying Service N5152XChampion 7GCBC · S/N 146-69Cancelled Apr 25, 1973 · Exported to Canada · Shawano Flying Service N7109FCessna 150F · S/N 15063709Cancelled Dec 22, 1972 · Built 1966 · Grognet Clarence J N7730XCessna 172B · S/N 17248230Cancelled Sep 24, 1970 · Martin Patrick N82583Aeronca 7AC · S/N 7AC-1220Cancelled Sep 13, 1968 · Dimeo Albert N4863DCessna 182A · S/N 34963Cancelled May 20, 1965 · Albert Dimeo DBA Shawano Air Service N97012Stinson 108-1 · S/N 108-1012Cancelled Nov 24, 1959 · Northern Lakes Airservice Inc N444KFleet 2 · S/N 167Cancelled May 14, 1949 · Built 1929 · Tinsman Jack Francis N270Canadian CANADIAN CURTISS · S/N UNKNOWNCancellation date not recorded · Lang Freddie H

Back to Shawano, WI