Registered aircraft · 25

Registered to this exact name, as owner or co-owner. Owners who share a name are listed together; other spellings aren’t included.

Query with SQL

SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code WHERE g.registrant_name = 'KANSAS AVIATION MUSEUM' OR list_contains(g.other_registrant_names, 'KANSAS AVIATION MUSEUM') ORDER BY g.n_number

duckdb -csv -c "SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code
  WHERE g.registrant_name = 'KANSAS AVIATION MUSEUM' OR list_contains(g.other_registrant_names, 'KANSAS AVIATION MUSEUM')
  ORDER BY g.n_number"

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 g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code
WHERE g.registrant_name = 'KANSAS AVIATION MUSEUM' OR list_contains(g.other_registrant_names, 'KANSAS AVIATION MUSEUM')
ORDER BY g.n_number

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.

N1473VPretty Prairie Special III 1 · S/N 1Built 1954 · Wichita, KS N19450Swallow TP · S/N TPW-1107First renewal noticeWichita, KS N24NSSwallow NEW SWALLOW · S/N 47Wichita, KS N29SWBoeing 737-2H4 · S/N 21340Wichita, KS N302VWatkins SKYLARK SL · S/N 102Wichita, KS N3153KBalentine Thomas/Edra TJ-2 · S/N 2Wichita, KS N3261USuperior CULVER V · S/N V-173Wichita, KS N3924Swallow SWALLOW · S/N 1005Wichita, KS N394KRCessna AT 17B · S/N 69138First renewal noticeWichita, KS N41672Rawdon T1 · S/N T1-3CSBuilt 1949 · Wichita, KS N41775Detroit GULL · S/N 324First renewal noticeWichita, KS N41PPPrescott Aeronautical PUSHER · S/N 001Built 1985 · Wichita, KS N4227UJohnson Carl A BABY GREAT LAKES · S/N GJ-002First renewal noticeBuilt 1982 · Wichita, KS N44770Rawdon R-1 · S/N 1Wichita, KS N492MMooney M-18C · S/N 245Built 1951 · Wichita, KS N5124CBeech B35 · S/N D-2409Built 1950 · Wichita, KS N5228UCessna 206 · S/N 206-0228Wichita, KS N536EAmerican Eagle 129 · S/N 397First renewal noticeWichita, KS N569YStearman 4D · S/N 4027Wichita, KS N719WWilkes Steven Edward SONERAI IIL · S/N 719Built 1984 · Wichita, KS N80271Culver V · S/N V-190Built 1946 · Wichita, KS N81162Funk B85C · S/N 292First renewal noticeBuilt 1946 · Wichita, KS N812EAmerican Eagle 129 · S/N 517Wichita, KS N8196Swift 18 · S/N 1002Wichita, KS N9067Stearman C3-B · S/N 204Wichita, KS

Back to Kansas Aviation Museum