Kansas Aircraft Corp
Earlier aircraft under this name · 24
Cancelled registrations that named this owner when they ended, newest first.
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_name = 'KANSAS AIRCRAFT CORP' OR list_contains(d.other_registrant_names, 'KANSAS AIRCRAFT CORP') 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_name = 'KANSAS AIRCRAFT CORP' OR list_contains(d.other_registrant_names, 'KANSAS AIRCRAFT CORP') 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.
N1096GHughes Helicopters HUGHES 369D · S/N 900785DN678SARaytheon B36TC · S/N EA-603N565BMooney M20R · S/N 29-0458N717CCCessna 210L · S/N 21060354N129PFCessna 206H · S/N 20608221N6032ABeech A36 · S/N E-1466N30JZPiper PA-34-200T · S/N 34-8070028N728TWCessna T206H · S/N T20608382N433RHBeech F33A · S/N CE-1290N793CBCessna 210N · S/N 21063278N503ERCessna 172S · S/N 172S8003N6ELPiper PA-34-220T · S/N 3449008N111EGBeech 95-B55 (T42A) · S/N TC-1855N703RRaytheon B200 · S/N BB-1699N731KKCessna P210N · S/N P21000482N888EXBeech 200 · S/N BB-240N5323YPiper PA-34-220T · S/N 3449286N5217MCessna T182T · S/N T18208159N9265QPiper PA-34-220T · S/N 3449077N8161QPiper PA-32R-301 · S/N 32R-8013045N2103BPiper PA-32RT-300T · S/N 32R7987024N206KBCessna TU206G · S/N U20605951N31ARCessna 404 · S/N 4040831N71327Cessna 182M · S/N 18259581
Back to Kansas Aircraft Corp