Nampa, ID
Registered aircraft · 192
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 = 'ID' AND g.registrant_city = 'NAMPA' 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 = 'NAMPA' 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.
N1011EMikoyan Gurevich MIG-21F · S/N 1011N103PPMulholland SPORT TRAINER · S/N 3839N107NRiley D-16 · S/N TN-4N110PECessna 208B · S/N 208B0858N113BRWalker Donald G RV-8 · S/N 81636N116GSSpittler Gerald S-16 SHEKARI · S/N 1298009N119BSFormolo Curt J RV-7 · S/N 70517N11EZOdonnell Greg N VARI EZ · S/N 04N120KQQuest KODIAK 100 · S/N 100-0120N121MCessna 182Q · S/N 18265624N122PSTilton Edwin J PITTS S1T · S/N 269-20-3757N1233Ulrich VPI · S/N 1066VN123YAveryt H D/Averyt B T RV-10 · S/N 40278N128CJJason F Gray KITFOX SERIES 7 STI · S/N KA18235378N1293FCessna 172N · S/N 17272987N1299PCarr J/Miller T WAIEX · S/N W0057N13686Cessna 172M · S/N 17262943N1428KLuscombe 8A · S/N 4155N1453RGrumman American Avn. AA-1B · S/N AA1B-0553N1470BPiper PA-31-325 · S/N 31-7512061N161CCCubcrafters CC11-160 · S/N CC11-00315N161TRBeech F33A · S/N CE-1619N1720Rolladen-Schneider LS-6B · S/N 6172N17749Waco EGC-7 · S/N 4588N1778UCessna T207A · S/N 20700378N1834DBeech C35 · S/N D-3101N185TPCessna A185E · S/N 185-1234N18963Beech C23 · S/N M-1984N1939YMooney M20E · S/N 246First renewal noticeN1951XCessna 182H · S/N 18256051N206MFCessna T206H · S/N T20609160N2089RHall Donald M SUPER ACRO SPORT · S/N 17N20KSEclipse EA500 · S/N 000244N2114GCessna 208B · S/N 208B0782N212WAWilson Ron WILSON · S/N 001N21344Cessna 182P · S/N 18261576N2144RCessna 182G · S/N 18255344N2163ZCessna 180F · S/N 18051263N2172YCessna 172D · S/N 17249672N2296JWSK PZL Mielec M-18A · S/N 1Z 019-17N22KFKenneth M Jones KITFOX 7 · S/N S70303024N234EXArnold Daniel R CCK-1865 · S/N CCK-1865-1044N2385HErcoupe 415-C · S/N 3010N2486GCessna 182B · S/N 51786N2595NCessna 120 · S/N 12855N2664KSilvaire LUSCOMBE 8E · S/N 5391N27225Hylio AG-272 · S/N 17906070303N2756Toby J Ashley CCK-1865 · S/N CCK-1865-1066Registration pendingN2764UCessna 172D · S/N 17250364N2776JCessna A185E · S/N 185-1526
Back to Nampa, ID