Liberal, KS
Registered aircraft · 57
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 = 'LIBERAL' 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 = 'LIBERAL' 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.
N1045JHusted Dean SPORT TRAINER · S/N 004N107SBRaytheon 400A · S/N RK206N121DCClinton David L TURBINE-LEGEND · S/N 112TN1234EAeronca 7AC · S/N 7AC-4792N1432LBeech A23 · S/N M-826N178RSCessna 172M · S/N 17262925N1LQCessna T210F · S/N T210-0148N203DFRaytheon 400A · S/N RK-203N2119FWhite P/Foelsch G PT-2 · S/N PT-1119N228SBRaytheon 400A · S/N RK-224N230SBLyddon S/Lyddon W LYDDON PITTS S1S · S/N 001N232DTCessna 414A · S/N 414A0232N2458PPiper PA-22 · S/N 22-2833N253SBCessna 441 · S/N 4410258N264ECDJI AGRAS T40 · S/N 1581F574B227400102KYN280DHClabaugh Robert R DAKOTA HAWK · S/N DH28N284SBPiper PA-31T · S/N 31T-7820074N2931LPiper PA-34-200T · S/N 34-7970387N32450Cessna C-165 · S/N 583N381SBCessna 441 · S/N 441-0323N389SBCessna 441 · S/N 441-0011N390SBRaytheon 400A · S/N RK-390N3991EJones Peter M BOEING/JONES 75 · S/N AR-28N425SBCessna 425 · S/N 425-0017N485SBCessna 172N · S/N 17271485N498SBRaytheon 400A · S/N RK-498N499EGlaser-Dirks DG-400 · S/N 4-99N500CTCessna 340A · S/N 340A1236N513PPRosel Airlines RV-8 · S/N 83365N515GRRodriguez Glenn G RANS S-12 · S/N 10950660N518QAEa Vision EA J100 · S/N EAVUAV502586221N5219FEa Vision EA J100 · S/N EAVUAV502586307N5380NCessna 182Q · S/N 18267675N5960QMooney M20C · S/N 3197N6091SBeech A36 · S/N E-787N645SBCessna 425 · S/N 425-0217N6482BCessna 172 · S/N 29682N649SBDaudt Larry K TEAM ROCKET F-1 · S/N 001N650WFFly Holly W PA-18 · S/N TC0801037N6834KPiper PA-16 · S/N 16-669N702SBPiper AEROSTAR 601P · S/N 61P07218063349N7181PPiper PA-24-250 · S/N 24-2350N759VVCessna 182Q · S/N 18266302N7727MMooney M22 · S/N 690002N7735NPiper PA-28-180 · S/N 28-5180N774CCBeech 400A · S/N RK-7N77HTBeech A36 · S/N E-1324N78MKCessna T210M · S/N 21062587N7952Grumman Acft ENG Cor-Schweizer G-164A · S/N 831N814SBLyddon Steven R RHINN DR-1 · S/N SL001
Back to Liberal, KS