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 = 'KS' AND d.registrant_city = 'JOHNSON' 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 = 'KS' AND d.registrant_city = 'JOHNSON'
  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 = 'KS' AND d.registrant_city = 'JOHNSON'
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.

N93859Ercoupe 415-C · S/N 1182Cancelled Jun 9, 2026 · Sale reported, canceled · Built 1946 N21630Cessna A188B · S/N 18800920Cancelled Jun 6, 2026 · Registration pending, canceled · Built 1972 N4222SAir Tractor AT-402B · S/N 402B-1198Cancelled May 9, 2026 · Registration pending, canceled · Built 2008 N82FHHauser FR Hauser TR SONERAI IIL · S/N 1087Cancelled Apr 2, 2022 · Registration expired, pending cancellation · Built 1982 · Hauser Thomas R N4467BLet BLANIK L-13 · S/N 175128Cancelled Mar 21, 2013 · Registration expired, pending cancellation · Smith Mike N25088Biggs-Del Rosso F4U CORSAIR · S/N WAR-060-F4UCancelled Oct 18, 2012 · Registration expired, pending cancellation · Built 1983 · Troutman Shaun L N64285Beech A36 · S/N 69-7703Cancelled Sep 10, 2012 · Registration pending, canceled N5720VBeech V35 · S/N D-8098Cancelled Apr 16, 2011 · Registration pending, pending cancellation · Built 1966 N93857Cessna T210L · S/N 21060437Cancelled Jun 28, 2010 · Exported to Bolivia · Built 1974 · Gerard Luke T N6194APiper PA-36-375 · S/N 36-8102025Cancelled Dec 9, 2004 · Exported to Brazil · Built 1981 · Hambrick Aviation Inc N4533HAir Tractor AT-502 · S/N 502-0105Cancelled Mar 18, 2003 · Exported to Spain · North Star Aviation Inc N3930EPiper PA-36-375 · S/N 36-8302023Cancelled Oct 31, 2000 · Triennial form not returned · Jet X Leasing Inc N3968EPiper PA-36-375 · S/N 36-8302024Cancelled Oct 31, 2000 · Triennial form not returned · Jet X Leasing Inc N10347Mid-America Sprayers 850 · S/N MS1Cancelled May 21, 1991 · Triennial form not returned · Mid America Sprayers Inc N1321UCessna 172M · S/N 17267009Cancelled Dec 29, 1976 · Exported to Canada · Hambrick Windell N6049KCessna 150M · S/N 150-77495Cancelled Jul 8, 1976 · Exported to Canada · Windell Hambrick DBA Hambrick Flying Service N11785Cessna 150L · S/N 15075630Cancelled Jul 17, 1975 · Exported to Canada · Windell Hambrick DBA Hambrick Flying Service N8990VCessna 172M · S/N 172-64345Cancelled Feb 12, 1975 · Exported to Canada · Hambrick Windell N66559Cessna 150M · S/N 15076123Cancelled Jan 29, 1975 · Exported to Guatemala · Hambrick Windell N16002Cessna 150L · S/N 15073401Cancelled May 29, 1974 · Exported to Canada · Built 1972 · Hambrick W Wendell N5470BCessna 182 · S/N 182-33470Cancelled Oct 25, 1973 · Exported to Canada · Ruth Donald W N2700YBeech 95 · S/N TD-31Cancelled Jun 29, 1970 · Shore John N4587EChampion 7CCM · S/N 7CCM-159Cancelled Jun 8, 1970 · Shaw Flying Service N78552Cessna 172K · S/N 17257665Cancelled Mar 9, 1970 · W Windell Hambrick N7436PPiper PA-24-250 · S/N 24-2625Cancelled May 21, 1965 · Johns Piper Sales N39643Aeronca 7AC · S/N 7AC-11Cancelled Apr 30, 1956 · Walker Forrest N1722EAeronca 7AC · S/N 7AC-5287Cancelled Jun 30, 1952 · Built 1946 · Johnson Flying Service N1373EAeronca 7AC · S/N 7AC-4934Cancelled Oct 4, 1951 · Johnson Flying Service

Back to Johnson, KS