Cancelled registrations · 28

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

N1926NCessna 120 · S/N 12170Cancelled Jul 21, 2022 · Sale reported, canceled · Built 1947 N89248Cessna 140 · S/N 8268Cancelled Feb 5, 2022 · Registration expired, pending cancellation · Larson Dwight C N36732Stinson 10A · S/N 8132Cancelled Jan 6, 2020 · Registration expired, pending cancellation · Built 1941 · Hsht N44853Piper PA-32-300 · S/N 32-7740108Cancelled Mar 23, 2018 · Registration expired, pending cancellation · Built 1977 · Nordstrom Duane V N454RVWhite David C VANS ACFT RV-4 · S/N 3075Cancelled Oct 6, 2017 · Registration expired, pending cancellation · Built 1993 · White David C N18766Beech C23 · S/N M-1940Cancelled Apr 23, 2013 · Registration expired, pending cancellation · Built 1977 · Great Lakes Aircraft Inc N8697TCessna 182C · S/N 52597Cancelled Jul 14, 2010 · Triennial form not returned · Built 1960 · Jondahl Robert S N82DRRybolt Donald F DR EXEC · S/N 1Cancelled Apr 25, 2008 · Triennial form not returned · Built 1987 · Buss Richard S N383VUCessna 150 · S/N 15063968Cancelled Jul 22, 2004 · Built 1966 · Williamson Ronald C N210FWCessna P210N · S/N P21000037Cancelled Sep 5, 2003 · Second triennial mailing, no response · Built 1978 · Stoneking Gary E N325HPSchuchart Jerome R STODDARD HAMILTONSH3 · S/N 3093Cancelled Jan 25, 2002 · Triennial form not returned · Built 1989 · Moyle Bennett I N2016FBeech 95-C55 · S/N TE-11Cancelled Jul 23, 2001 · Schneider Terry N816PCRockwell International 690B · S/N 11395Cancelled Jun 29, 1994 · Exported to Bolivia · Johnson William Z N2919RCessna 310G · S/N 310G0119Cancelled Dec 29, 1992 · Triennial form not returned · Dougherty John N1607WBeech A36 · S/N E341Cancelled Apr 23, 1992 · Triennial form not returned · Horecki Henry N7401DPiper PA-22-150 · S/N 225161Cancelled Mar 27, 1991 · Triennial form not returned · Dale Walter R N3977ZRice Robert B PIETENPOL AIR CAMPER · S/N RBR1Cancelled Mar 11, 1991 · Triennial form not returned · Rice Robert B N6769DBell 47J · S/N 1793Cancelled Nov 1, 1983 · Rogers Harry M N20MQHiller UH-12E · S/N 1702Cancelled Sep 16, 1982 · Built 1965 · Progressive Helicopter Services Inc N6863XCessna 172B · S/N 17247763Cancelled Sep 10, 1981 · Exported to Canada · Moser Sales Inc N18FKKaeppel THORP T-18 · S/N 704Cancelled Jul 1, 1980 · Built 1977 · Kaeppel Fred W Jr N66532Cessna 150M · S/N 15076103Cancelled Nov 19, 1979 · Exported to Canada · Moser Carl R N5663SBeech A23-19 · S/N MB-92Cancelled Jul 13, 1979 · Exported to Canada · Moser Carl R N5907DPiper PA-22-150 · S/N 22-4569Cancelled Sep 20, 1977 · Exported to Canada · Moser Carl R N8286RBellanca 17-30A · S/N 30458Cancelled Jun 10, 1975 · S R Rex Leasing Corp N1549JPiper PA-28 · S/N 28-23953Cancelled Mar 1, 1974 · Built 1968 · Equity Leasing Corp N4796SPiper PA-32-260 · S/N 32-1181Cancelled Jan 17, 1972 · Equity Leasing Corporation N8325DBeech J35 · S/N D-5419Cancelled Jun 24, 1970 · Executive Associates Inc

Back to Edina, MN