OpenAirDocs.org
Derby, KS

Cancelled registrations · 81

Query with SQL
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 = 'DERBY'
  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.

N9075GCessna 182N · S/N 18260615Cancelled Aug 11, 2025 · Expired dealer · Compass Rose Aviation LLCN3250PPiper PA-23-160 · S/N 23-1195Cancelled Feb 16, 2023 · Registration expired, pending cancellation · Built 1957 · Wojteczko Jason AN65667Aerostar International RAVEN S57-A · S/N S57A-3025Cancelled Nov 5, 2022 · Registration expired, pending cancellation · Built 1987 · Irvin Ronald LN250BJBomball DUSTER BJ-1B · S/N 1-250Cancelled Oct 30, 2021 · Registration expired, pending cancellation · Estagin Robert MN842RGGibfried Robert F KR2S · S/N 565Cancelled Feb 28, 2020 · Registration expired, pending cancellation · Built 2006 · Gibfried Robert FN53604Piper J3C-65 · S/N 10312Cancelled Sep 13, 2018 · Revoked, canceled · Built 1944 · Gibson H LN53607Taylorcraft DC-65 · S/N 6246Cancelled Sep 13, 2018 · Revoked, canceled · Built 1947 · Mc Nutt Robert EN1073DCessna 195A · S/N 7685Cancelled Jun 20, 2018 · Exported to Mexico · Built 1951 · Huckins Marvin EN1821PPiper PA-22-135 · S/N 22-2601Cancelled Jun 7, 2017 · Registration expired, pending cancellation · Built 1956 · Gibfried Robert FN3584JCessna 150E · S/N 15061284Cancelled Apr 27, 2015 · Sale reported, pending cancellationN7175WHebron Kalor 90 GYROCOPTER · S/N 0007Cancelled Oct 21, 2013 · Registration expired, pending cancellation · Built 1990 · Hebron Kalor AN7074JHilderbrand Michael A CHALLENGER II · S/N CH2-0502-2216Cancelled Sep 19, 2013 · Registration expired, pending cancellation · Built 2003 · Hilderbrand Michael AN51WSSullivan William L MONERAI-S · S/N WLS-IICancelled Jun 7, 2013 · Registration expired, pending cancellation · Built 1981 · Anderson Dennis WN758NPCessna R172K · S/N R1723231Cancelled Feb 26, 2013 · Sale reported, canceled · Built 1979N5336UCessna U206G · S/N U20605217Cancelled Feb 20, 2013 · Sale reported, pending cancellationN3183HHerbison A / Mitchell V CHALLENGER · S/N CH209-91R-0729Cancelled Feb 13, 2013 · Sale reported, canceled · Built 1992N12293Hilderbrand Michael SONEX · S/N 1017Cancelled Mar 2, 2011 · Exported to Canada · Built 2009 · Hilderbrand Michael AN6463XAerostar International RX-7 · S/N RX7-3112Cancelled Sep 27, 2007 · Triennial form not returned · Built 1987 · Spruhan Kelli CN176RFreet D A BUM BEE · S/N DAF-10Cancelled Nov 22, 2006 · Triennial form not returned · Hudson Thomas HN2507XCessna P206 · S/N P206-0007Cancelled Jan 17, 2002 · Built 1965 · Sky Tours IncN4330WHorton William M TEAM MINI MAX 1600R · S/N MK231Cancelled Sep 18, 1997 · Triennial form not returned · Horton William MN5372SBeech D55 · S/N TE545Cancelled Nov 30, 1995 · Second triennial mailing, no response · Kansair IncN12080Blackett EXPERIMENTAL AUTOGYR · S/N 1Cancelled Mar 8, 1993 · Triennial form not returned · Hebron Kalor AN1573HCessna 177RG · S/N 177RG0747Cancelled May 29, 1992 · Grosboll Marshall JN2312MHudson-Thomas VOLKSPLANE VP-2 · S/N V21571Cancelled Mar 29, 1991 · Triennial form not returned · Hudson Thomas HN6526SBeech 58P · S/N TJ-424Cancelled Apr 2, 1984 · Exported to United Kingdom · Kansair IncN5179BCessna 152 · S/N 15283795Cancelled Mar 21, 1983 · Built 1979 · Cook Airfield IncN9609GCessna U206G · S/N U20603818Cancelled Feb 3, 1982 · Exported to Bolivia · Cook Airfield IncN76551Cessna 140 · S/N 10987Cancelled Oct 6, 1981 · Exported to Canada · Chandler AllenN758VYCessna R172K · S/N R1723406Cancelled Mar 26, 1981 · Exported to Bolivia · Cook Airfield IncN4779NCessna 182Q · S/N 18267362Cancelled Sep 26, 1980 · Exported to Bolivia · Built 1979 · Cook Airfield IncN5283CCessna T210N · S/N 21063727Cancelled Sep 26, 1980 · Exported to Bolivia · Cook Airfield IncN758HWCessna R172K · S/N R1723118Cancelled Sep 9, 1980 · Exported to Bolivia · Cook Airfield IncN758URCessna R172K · S/N R1723375Cancelled Aug 22, 1980 · Exported to Bolivia · Cook Airfield IncN6110XCessna U206G · S/N U20605819Cancelled Aug 21, 1980 · Exported to Germany · Cook Airfield IncN733QKCessna U206G · S/N 20604787Cancelled Aug 31, 1979 · Exported to Bolivia · Cook Airfield IncN6424NCessna 210N · S/N 21063000Cancelled Aug 29, 1979 · Exported to Bolivia · Cook Airfield IncN6663NCessna 210N · S/N 210-63138Cancelled Aug 29, 1979 · Exported to Bolivia · Cook Airfield IncN732ZPCessna U206G · S/N U20604746Cancelled Aug 29, 1979 · Exported to Bolivia · Cook Airfield IncN733NYCessna U206G · S/N U20604784Cancelled Aug 29, 1979 · Exported to Bolivia · Cook Airfield IncN732NKCessna U206G · S/N U20604702Cancelled Jun 26, 1979 · Exported to Bolivia · Cook Airfield IncN733XCCessna U206G · S/N U20604804Cancelled Jun 26, 1979 · Exported to Bolivia · Cook Airfield IncN733BQCessna U206G · S/N U20604751Cancelled Jun 19, 1979 · Exported to Bolivia · Cook Airfield IncN64959Cessna 152 · S/N 15281500Cancelled Jan 10, 1979 · Exported to Switzerland · Cook Airfield IncN9888MCessna U206G · S/N U20604579Cancelled Nov 1, 1978 · Exported to Bolivia · Cook Airfield IncN756XSCessna U206G · S/N U20604444Cancelled Sep 15, 1978 · Exported to Bolivia · Cook Airfield IncN3803RCessna 172H · S/N 17255303Cancelled Apr 11, 1978 · Built 1966 · A I D Flying Club IncN756PJCessna U206G · S/N U20604245Cancelled Apr 7, 1978 · Exported to Bolivia · Cook Airfield IncN756MBCessna U206G · S/N U20604190Cancelled Apr 6, 1978 · Exported to Bolivia · Cook Airfield IncN761APCessna 210M · S/N 21062104Cancelled Nov 8, 1977 · Exported to Bolivia · Cook Airfield Inc
Back to Derby, KS