Valley Center, KS
Registered aircraft · 51
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 = 'VALLEY CENTER' 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 = 'VALLEY CENTER' 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.
N1127George-Smith MINIPLANE · S/N G-1N1171KLuscombe 8A · S/N 3898N1379BHannasch Leonard H RV-3 · S/N 71N16DCColchin TAYLOR MONOPLANE · S/N SC1N170DBDavid L Blanton BUGEATER · S/N IN1729Curtis Richard D FOKKER DR1 TRIPLANE · S/N 13N2222DCessna 170B · S/N 20374N245HMMurphy Harvey CHALLENGER II · S/N HM01N3358EAeronca 11AC · S/N 11AC-1691N36299James M Aspenson RV-6 · S/N 20863N3708JCessna 150G · S/N 15065008N37442Interstate S-1A · S/N 287N3788WWiebe James Richard CASSUTT RACER · S/N 233N38484Piper J3C-65 · S/N 7057N4079EAeronca 11BC · S/N 11BC-173N413DJDavid Nolte RV-7A · S/N 72299N414BPCessna 414A · S/N 414A0506N418PCCessna A185E · S/N 185-01843N44551Team AIR BIKE · S/N AB152N45DBCessna 150 · S/N 17190N4652VWelch Raymond X SAL 2/3 MUSTANG · S/N RXW-1N47DPAeronca 7BCM · S/N 7AC-5722N5005LMooney M-20G · S/N 680048N5267LPiper PA-28-180 · S/N 28-4565N5315PPiper PA-24-250 · S/N 24-356N545LLa France Tailwind W-8 · S/N 45N5907ECessna 172N · S/N 17271957N6092Flying Machine SUPER KOALA · S/N 7-1427N61094Cessna 150J · S/N 15070795N6184TCessna 150E · S/N 15060884N628DBeech C35 · S/N D-2889N631PSShireman Paul M RANS S6ES · S/N 09051689N6600XCessna 210A · S/N 21057600N6661WPiper PA-28-140 · S/N 28-20764N6772NMooney M20C · S/N 680083N678JPBlanton Jeffrey D HARMON ROCKET II · S/N 313N6826MStinson 108-3 · S/N 108-4826N732LADiamond Aircraft Ind DA 50 C · S/N 50.C.A.A.032N8156ZBeech C90A · S/N LJ-1333N830SWCessna A185F · S/N 18503631N839SE A A Chapter 839 RV6 · S/N 22061N9006WGregory Dale S SONEX · S/N 0526N907JJAviat A-1C-200 · S/N 3319N9085LChampion 7GCAA · S/N 226-70N9120LChampion 7ECA · S/N 799-71N9204EAeronca 11AC · S/N 11AC-838N93394Ercoupe 415-C · S/N 717N9617DPiper PA-22-160 · S/N 22-6528N97SRBlanton D L/Blanton P J BLANTON SPRT RCR SPR · S/N 1N982VRichard Douglas Curtis SKYOTE · S/N 16-108
Back to Valley Center, KS