Registered aircraft · 33

Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.

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_state = 'ID' AND g.registrant_city = 'KUNA' 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_state = 'ID' AND g.registrant_city = 'KUNA'
  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 = 'ID' AND g.registrant_city = 'KUNA'
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.

N121KKScott K/Krueger K KK-1 · S/N 1Built 2006 · Cripe Daniel J N130HAHiller UH-12E · S/N HA3030C&C Helicopters Inc N2091HEngineering & Research ERCOUPE 415-C · S/N 2714Built 1946 · Cripe Daniel J N2285CCessna 180 · S/N 30585Built 1953 · Iturriria John M N268TRCubcrafters CC11-160 · S/N CC11-00166Seid William E N29164Cessna TU206C · S/N U206-1133Built 1968 · Iturriria John N295BDDJI AGRAS T40 · S/N 52LBK6Q00100HWThornton Michael N2SSCessna 170A · S/N 19980Built 1952 · Flying M Aircraft LLC N2ZSTheodor L Mulder CCK-1865 · S/N CCK-1865-0031Built 2014 · Callahan Brian L Trustee N325DFDavid P Miller KITFOX S7 SUPERSPORT · S/N KA21128497Built 2021 · Miller David P N41429Piper PA-28R-200 · S/N 28R-7435180Built 1974 · Straight Arrow LLC N433KACirrus Design SR20 · S/N 9170Built 2023 · Nun-Yuh Business LLC N44033Taylorcraft BC12-D · S/N 9833Ercanbrack Nolan J N4740BCessna 180 · S/N 31638Built 1955 · Callahan Brian L Trustee N53HBBell 47G-2A · S/N 3257Built 1966 · Johnson Helicopter Service Inc N5661BCessna 182 · S/N 33661Built 1956 · Piekarski John G N59410Bell 47G3B2A · S/N 6868Built 1973 · Johnson Helicopter Service Inc N61556Cessna A185F · S/N 18504230Built 1981 · Clark William J N62052Piper PA-24-250 · S/N 24-1235Built 1959 · Bolinger Ray G N64BLLittlejohn Bobby LITTLEJOHN PT-19 · S/N 1Built 1944 · Piekarski John G N65YCJohn Iturriria CCK-1865 · S/N 062122Built 2025 · Iturriria John M N711YCDory Joseph A SMITH CUB · S/N 0023Built 2005 · Iturriria John M N734KCBeech/Clark K E FUJI B-45 (T-34A) · S/N 5907104Piekarski John G N80RXCessna R172K · S/N R1723276Built 1979 · Mccord Cheryl N8513BCessna 172 · S/N 36213Fisher Steven B N8602BCessna 172 · S/N 36302Built 1957 · Shannon Terrence M N864SBeech 95-B55 (T42A) · S/N TC-1208Built 1969 · Piekarski John S N91674North American NAVION · S/N NAV-4-167Built 1946 · Whale Charles R Jr N9272MMooney M20C · S/N 3460Registration pendingBuilt 1966 N93888Ercoupe 415-C · S/N 1211Built 1946 · Andrews Kenneth G N94085Engineering & Research 415-C · S/N 1408Built 1946 · Whale Charles R Jr N973SRCessna 182L · S/N 18258865Registration pendingBuilt 1968 N9886CCessna R182 · S/N R18200482Built 1978 · Alm Ronald

Back to Kuna, ID