Skip to content

Cancelled registrations · 38

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 = 'SD' AND d.registrant_city = 'WATERTOWN' 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 = 'SD' AND d.registrant_city = 'WATERTOWN'
  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 = 'SD' AND d.registrant_city = 'WATERTOWN'
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.

N402KNAir Tractor AT-402B · S/N 402B-1159Cancelled Nov 10, 2021 · Exported to Canada · Built 2005 · Yost John B N2631MSix Chuter SR7 · S/N SR7X1-2577Cancelled Dec 15, 2018 · Registration expired, pending cancellation · Built 2000 · Endres Nicholas P N24515Cessna 152 · S/N 15280303Cancelled Nov 30, 2018 · Built 1977 · Arbach Enterprises Inc N32DDGates Lear Jet 24E · S/N 331Cancelled Jun 26, 2018 · Registration pending, canceled · Built 1976 N9303CCessna 180 · S/N 31701Cancelled Feb 7, 2018 · Registration expired, pending cancellation · Built 1954 · Haan James N N7217ZPiper PA-25-235 · S/N 25-3131Cancelled Jan 8, 2018 · Registration expired, pending cancellation · Built 1965 · Haan James N N5476Grumman Acft ENG Cor-Schweizer G-164A · S/N 1173Cancelled Jan 5, 2018 · Registration expired, pending cancellation · Built 1973 · Haan James N6705DBell 47G-2 · S/N 2193Cancelled Oct 31, 2017 · Registration expired, pending cancellation · Built 1957 · Haan James N N88399Bellanca 7GCBC · S/N 777-75Cancelled Jun 30, 2017 · Registration expired, pending cancellation · Built 1974 · Lamb Chad A N5081KCondor SPORT · S/N 5544374Cancelled Apr 18, 2017 · Registration expired, pending cancellation · Built 2003 · Stadheim Jeff J N2148Huges Pitts Special S-1C · S/N 1Cancelled Aug 19, 2013 · Sale reported, canceled · Built 1968 N1204EAeronca 7AC · S/N 7AC-4760Cancelled Jul 11, 2013 · Sale reported, canceled · Built 1946 N86686Weatherly 201 · S/N 101Cancelled May 15, 2013 · Registration expired, pending cancellation · Built 1966 · Riggin Wayne W N8162KStinson 108-1 · S/N 108-1-1162Cancelled May 13, 2013 · Registration expired, pending cancellation · Built 1946 · Nehl Patrick A N165SDBeech 58P · S/N TJ-314Cancelled Jun 20, 2012 · Triennial form not returned · Built 1980 · Lake Area Technical Institute N33LWWohlers Laurence WOHLERS FALCO F.8L · S/N 1Cancelled Jun 20, 2012 · Third renewal notice · Built 1982 · Lake Area Technical Institute N3653XAero Commander 100 · S/N 307Cancelled Jun 20, 2012 · Third renewal notice · Built 1968 · Lake Area Technical Institute N421UCessna 421A · S/N 421A0012Cancelled Jun 20, 2012 · Second renewal notice · Built 1968 · Watertown School District No 14-4 N518NABeech U-21 · S/N 66-18080Cancelled Jun 20, 2012 · Second renewal notice · Lake Area Technical Institute N16235Cessna 150L · S/N 15073562Cancelled Oct 1, 2008 · Built 1972 · Katy Flying Club Inc N1978QCessna 177RG · S/N 177RG0378Cancelled Sep 9, 2002 · Triennial form not returned · Built 1973 · Priority Air Inc N109KGGueffroy Kenneth W CHALLENGER II · S/N CH20993CW1015Cancelled Sep 15, 2000 · Triennial form not returned · Gueffroy Kenneth W N3133LFischer QUICKSILVER MXII · S/N MXII001Cancelled Jul 13, 1994 · Triennial form not returned · Fischer Aviation Inc N12770Lockheed T-33A · S/N 53-4890Cancelled Jul 10, 1980 · Watertown Indepdendent School District 1 N17395Dehavilland DHC-2-L-20 · S/N 51-16521Cancelled Feb 13, 1980 · Exported to Canada · Built 1952 · Lake Area Vocational Technical School N80416Cessna 172M · S/N 17266577Cancelled Jul 21, 1977 · Lake City Aviation Inc N45147Cessna 150M · S/N 15076754Cancelled Jul 7, 1977 · Built 1975 · Lake City Aviation Inc N5716MCessna T-310P · S/N 310P0016Cancelled Oct 14, 1976 · Lake City Aviation Inc N50543Cessna 150J · S/N 15069385Cancelled Sep 21, 1976 · Shelsta Ronald R N6767ACessna 172 · S/N 28867Cancelled Mar 24, 1976 · Exported to Canada · Haan Melvin Robert N1820KLuscombe 8E · S/N 4547Cancelled Sep 16, 1975 · Lake City Aviation Inc N11665Bellanca 7ECA · S/N 844-72Cancelled Apr 23, 1975 · Exported to Canada · Lake City Aviation Inc N8258NPiper PA-28-140 · S/N 28-25469Cancelled Sep 19, 1972 · Aurie Lowinske N4029RPiper PA-32-300 · S/N 32-40324Cancelled Oct 14, 1971 · Lowinske Aurie DBA N3936SCessna 172E · S/N 17251136Cancelled Aug 26, 1971 · Lowinske Aurie N957TBeech N35 · S/N D-6651Cancelled Aug 4, 1970 · Spies Realty Co N1987BLuscombe 8A · S/N 6414Cancelled May 18, 1965 · Built 1948 · Watertown Flying Club N214NAmerican Eagle 101 · S/N 715Cancelled Oct 15, 1941 · Meyers Harold Myron

Back to Watertown, SD