Klamath Falls, OR
Registered aircraft · 111
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 = 'OR' AND g.registrant_city = 'KLAMATH FALLS' 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 = 'OR' AND g.registrant_city = 'KLAMATH FALLS' 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.
N101KMBeech A36 · S/N E-2253First renewal noticeN1041KBruce Boyd AVID FLYER · S/N 1603N1055CMaule MX-7-180A · S/N 20051CN107PBCirrus Design SR22 · S/N 2292N108KXCox John KITFOX IV 1200 · S/N 1908N10AFRobinson Helicopter R44 II · S/N 11079N11509Wygant Mark B ZODIAC CH650 B · S/N 65-10999N1157VCessna R172K · S/N R1722125N1163XPiper PA-28-151 · S/N 28-7515396N11994Little Toot WPI · S/N 15N1228EEgli Fred W LANCAIR IV LIV · S/N LIV190N125TSHawker Beechcraft B200 · S/N BB-1993N1532ZBeech P35 · S/N D-6855N15RMPiper PA-18-150 · S/N 18-8814N174ALABZ Innovation KFT ABZ INNOVAT L30-V2 · S/N 1759FABZL30V22500071N174KMRedd George M REDDS RV7 · S/N 70457N1767RCessna A185F · S/N 18502487N1831SBeech 77 · S/N WA-302N1966PPiper PA-18A 150 · S/N 18-4197N2101YKurt A Yancey 4/1200 · S/N 101N213PDBell 206B · S/N 1992N2157ZCessna 180F · S/N 18051257N2236QCessna 421A · S/N 421A0036N236VFairchild KR-21 · S/N 1043N255Cessna T337G · S/N P3370213N256KAPiper PA-38-112 · S/N 38-78A0759N257RMCessna 560 · S/N 560-0485N2580GCessna 182B · S/N 51880N264RMBell UH-1H · S/N 70-16424N2698XCessna 182S · S/N 18280318N2711GCessna 182B · S/N 52011N2FGBell 206B · S/N 2514N300VTHarbert Charles VELOCITY RG · S/N DM0276N3063DCessna 310 · S/N 35263N307RWQuest KODIAK 100 · S/N 100-0230N31672Waco VKS-7F · S/N 6113N329HSSwearingen SA226-T(B) · S/N T-323N3718MPiper PA-28-181 · S/N 28-7890325N394VRountree Ronald QUICKSILVER SPORT 2S · S/N SPORT S2 0141N3TECentrair 101A · S/N 101A0198N40875Piper J5B · S/N 5-1184N4118NMcintire Shane GT 500 · S/N 0066N411RMMckune-Ralph SMYTH SIDEWINDER · S/N 212139N4210RPiper PA-32-300 · S/N 32-40575N4353DTracy Donald E AVID MARK IV · S/N 1070DN44318Piper PA-28-151 · S/N 28-7415621N496EDDassault-Breguet FALCON 50 · S/N 64N496PTSwearingen SA227-AT · S/N AT-427N504EDDassault-Breguet FALCON 50 · S/N 67N51297Cessna 172M · S/N 17264232
Back to Klamath Falls, OR