Caldwell, ID
Registered aircraft · 211
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 = 'CALDWELL' 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 = 'CALDWELL' 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.
N101RAAmerican Champion 8GCBC · S/N 515-2009N1050HDelbert Coller MONSTRE DE BROUSSE · S/N 001N1115FRobinson Helicopter R22 · S/N 2765N117MTPiper PA-28-140 · S/N 28-21374N12032Maule M-4 · S/N 42N121PFWinship Thomas W VANS AIRCRAFT RV-4 · S/N 2498N131DWAmerican Champion 8GCBC · S/N 569-2015N132TCRobinson Helicopter R44 · S/N 1259N134USClarke Dale M YAK 3UR 2000 · S/N DMC0003N13PXIsaacs Steven G SONEX · S/N 674N141BHAmerican Champion 8GCBC · S/N 623-2022N1470ZBellanca 8GCBC · S/N 189-76N14KWWood Kenneth E CHRISTEN EAGLE II · S/N 0001N166FSRobinson Helicopter R66 · S/N 0513N17579Piper J-2 · S/N 1079N184SHRobinson Helicopter R22 BETA · S/N 4205N185JSmith Miniplane J-SMITH · S/N JS-101N1929MMichael K Choules PIETENPOL AIR CAMPER · S/N 1001N19CHColton H Hoskins AVID MAGNUM · S/N 40MN202PKMolino PIK-20E · S/N 02N20908Waco AGC-8 · S/N 5067Registration pendingN2094GGrumman F6F-5 · S/N 72094N211LLHoward James J SKY RAIDER SNGLE PL · S/N 106N212JSSinkbeil James W RV-7A · S/N 70146N2130FCessna 172S · S/N 172S9419N216RCDoebbeling Steven SLINGSHOT · S/N 005N2177SCessna 210L · S/N 21061138N2214PPiper PA-23 · S/N 23-823N2232BHink Henry T RV-3 · S/N 512N2233PPiper PA-23 · S/N 23-842N22366Aeronca 65-C · S/N C3659N2262ZSkyhawk Ventures A-4C SKYHAWK · S/N 60-12377N22764Piper J4A · S/N 4-451N23157Cessna 150H · S/N 15068760N231ADehavilland BEAVER U-6A · S/N 227N2331VCessna 140 · S/N 14567N2341CCessna 180 · S/N 30641N2371RCessna 182G · S/N 18255471N2402XCessna 182H · S/N 18256302N246MCChoules Michael K RV6 · S/N 20247N2479QCessna 182K · S/N 18257679N2504XCessna P206 · S/N P206-0004N2525FChampion 7ECA · S/N 419N25TBBradford-Thomas VARIEZE · S/N 255N2612MPiper PA-12 · S/N 12-964N2690DCessna 170B · S/N 20842N2690GCessna 182B · S/N 51990N2745UCessna 172D · S/N 17250345N284EWFunk B75L · S/N 210N2894QCessna 172L · S/N 17259894
Back to Caldwell, ID