Cancelled registrations · 17

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

N11195Cessna 150L · S/N 15075249Cancelled May 7, 2022 · Registration expired, pending cancellation · Built 1973 · Guldan John H N615XPDJI INSPIRE 1 · S/N W13DCG08040278Cancelled Jul 26, 2018 · First renewal notice · Picture Factory Inc N545SPCraig Peterschmidt FOXTECH KRAKEN K130 · S/N PF02Cancelled Apr 9, 2018 · Registration expired · Picture Factory Inc N594VFDJI S1000+ · S/N PF06Cancelled Apr 9, 2018 · First renewal notice · Picture Factory Inc N547TPCraig Peterschmidt TAROT X8 · S/N PF04Cancelled Jan 30, 2018 · First renewal notice · Picture Factory Inc N4377ZBrawn Malcolm W HUMMELBIRD · S/N 3321PCancelled Jan 19, 2018 · Registration expired, pending cancellation · Built 2001 · Proflight LLC N63161King ROYAL I · S/N 1Cancelled Sep 7, 2017 · Registration expired, pending cancellation · King Robert R N6979Deneen JEANIES TEENIE II · S/N MAD69Cancelled Sep 3, 2014 · Revoked, canceled · Built 1969 · Deneen Michael A Jr N2462WSchweizer SGS 2-33 · S/N 25Cancelled May 30, 2013 · Registration expired, pending cancellation · Built 1967 · Anderson Brian A N29GRRiedel Gary L COZY · S/N 316Cancelled Mar 5, 2013 · Riedel G L N44199Pegasus QUANTUM 15 · S/N 7733Cancelled Nov 14, 2012 · Sale reported, pending cancellation · Built 2002 N21888Piper J3C-65 · S/N 2667Cancelled Jul 14, 2009 · Registration revoked · Built 1938 · Martinek Richard W N4375DAdams Scott David CLOUDHOPPER · S/N 1Cancelled Oct 20, 2003 · Triennial form not returned · Adams Scott David N2831EAeronca 7AC · S/N 7AC-6414Cancelled Feb 8, 2002 · Triennial form not returned · Cahoon John A N4388QMarson Thomas F VANS RV 6A · S/N 60073Cancelled Jun 11, 1999 · Marson Thomas F N312RJJohnson Ronald K AVID FLYER MKIV · S/N 1131DCancelled Mar 29, 1995 · Johnson Ronald K N38853Piper J3L-65 · S/N 7339Cancelled Oct 30, 1968 · Built 1941

Back to Hudson, WI