Salina, KS
Registered aircraft · 99
Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.
Query with SQL
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_state = 'KS' AND g.registrant_city = 'SALINA' 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_state = 'KS' AND g.registrant_city = 'SALINA' 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.
N127CTFlight Design CTSW · S/N 06-09-06N1362YCessna 172C · S/N 17249062First renewal noticeN137MSBell 206B · S/N 2686N151RCClark Randolph R KR-2 · S/N 1N1640NMcclish FUNK B85C · S/N 420N1863WTextron 525B · S/N 525B0749N19719Cessna 172L · S/N 17260697N200TKDJI AGRAS T20P · S/N 1581F574B239100100G5N20403Cessna 177B · S/N 17702669N2078APiper PA-28R-201 · S/N 28R-7837315N22SZRawlins F A/Houseman D VANS RV-8A · S/N 81381N242TNMooney International M20TN · S/N 31-0140N24327Cessna 152 · S/N 15280218First renewal noticeN269STHughes 269A · S/N 85-0363N2898EAeronca 7AC · S/N 7AC-6481N327NSDJI AGRAS T50 · S/N 1581F6BUB243J001911PN327SZDJI AGRAS T50 · S/N 1581F6BUB2431001C4R2N355DCPiper PA-46-310P · S/N 46-8408079N400GBReed Daniel B ACRO II · S/N 573N4042VCessna 170 · S/N 18361N432MMMeyette Brian RV-7A · S/N 71008N4573EAeronca 7CCM · S/N 7CCM-139N47547Taylorcraft DCO-65 · S/N L-4846N47KDMichalak Daniel A JR KITFOX V · S/N S94030002N4834ZPiper PA-22-108 · S/N 22-8408N496MMooney M-18C · S/N 246N50525Beech 65-A90 · S/N LJ159First renewal noticeN5106BCessna 152 · S/N 15283747N5500WBellanca 8KCAB · S/N 432-78N555LTBeech A36 · S/N E-737N56540Piper PA-34-200 · S/N 34-7350347N6010TCessna 162 · S/N 16200297First renewal noticeN60519Beech A36 · S/N E-1687N60669Cessna 162 · S/N 16200283First renewal noticeN6084BCessna T210M · S/N 21062678N6234CPiper PA-28-181 · S/N 28-7890349N6283HPiper J3C-65 · S/N 19467First renewal noticeN6355LAmerican AA-1A · S/N AA1A-0355N68KSPiper PA-34-200T · S/N 34-7770252N701CJCessna 401A · S/N 401A0022N70688Cessna 182M · S/N 18259358N710TRCessna R172K · S/N R1722768N723STPilatus PC-12/47 · S/N 723N7261QCessna 172L · S/N 17260561N7502JPiper PA-28R-180 · S/N 28R-30866N75263Boeing A75L300 · S/N 75-3621N7568QCessna 310Q · S/N 310Q0068N758DECessna R172K · S/N R1723006N7725KPiper PA-20 · S/N 20-547N802KSTextron 172S · S/N 172S13388
Back to Salina, KS