Cancelled registrations · 176

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

N1720HCessna 310C · S/N 35820Cancelled Nov 8, 1963 · Oscar Mayer & Co Inc N3246Beech 35 · S/N D691Cancelled Apr 16, 1963 · Art Way Construction Co Inc N11QTodd Edward TAILWIND · S/N WL 10Cancelled May 15, 1962 · Todd Edward T N99255Ercoupe 415-C · S/N 1878Cancelled Jul 18, 1961 · Built 1946 · Taplin Clarence N3442HErco 415-CD · S/N 4067Cancelled Jul 17, 1961 · Winans John Gibson N87092Ercoupe 415-C · S/N 265Cancelled Feb 24, 1956 · Donovan John N70807Piper J3C-65 · S/N 17825Cancelled Sep 13, 1954 · Tingler Dale E N24816Piper J3F-50 · S/N 3460Cancelled Apr 28, 1954 · Four Lakes Aviation Corp N3031VBeech 35 · S/N D-435Cancelled Jul 22, 1953 · Howard Machine Copany Inc N8235ACessna 170B · S/N 25087Cancelled Apr 15, 1953 · Johnson Al N5578Lockheed ELECTRA 10-A · S/N 1144Cancelled Jan 9, 1950 · Wisconsin Central Airlines Inc Transair Inc N402MStinson SM-2AC · S/N M-1127Cancelled May 12, 1948 · Four Lakes Aviation Corp N3069Arrow Aircraft & Motors ARROW SPORT · S/N 330Cancelled Apr 2, 1947 · Four Lakes Aviation Corporation N34543Aeronca 65-LB · S/N LB15321Cancelled Aug 6, 1943 · Built 1941 · Morey Howard A N19709Aeronautical Corp Of America AERONCA K · S/N K-225Cancelled Jul 17, 1942 · Built 1937 · Gahagan Donn N12301Curtiss Wright CW-1 · S/N 1271Cancelled Jun 15, 1941 · Spitfire Aviation Club N747YNew Standard D-32 · S/N 3000Cancelled Feb 19, 1940 · Built 1930 · Morey Howard A N7637National Airways System AIR KING · S/N 171Cancelled Mar 10, 1939 · Oscar Lloyd & Art N5951Waco 10 · S/N 1195Cancelled Sep 1, 1935 · Bessie Silbeck N13649Corben Sport Plane CORBEN JR ACE 6-S · S/N 3304Cancelled Dec 18, 1934 · Built 1933 · Corben Sport Plane Co Inc N186VCessna CG-2 · S/N 58Cancelled Sep 10, 1934 · Built 1930 · Zerwick Kenneth N819VWaco NAZ · S/N 4023Cancelled Mar 13, 1933 · Royal Airways Corporation N710MSaint Louis C-2-110 · S/N 118Cancelled Sep 11, 1930 · Midwest Air Transport Co N4499Avro DRAGON FLY · S/N 0413Cancelled Mar 14, 1930 · Built 1928 · Gibson C F N2317Standard J-1 · S/N 1411Cancelled Sep 17, 1929 · Ellis Louis N4970National Airways System AIR KING · S/N 129Cancelled Jun 6, 1928 · Hansley W A

Back to Madison, WI