Mccall, ID
Registered aircraft · 77
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 = 'MCCALL' 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 = 'MCCALL' 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.
N125RRRuble Randy S-6S · S/N 070214495N1474Maule M-7-235B · S/N 23013CN180LJCessna 180J · S/N 18052408N182PXCessna 182B · S/N 51941N1992XCessna 182H · S/N 18256092N1996APiper PA-22-135 · S/N 22-1092N19BCN19bc BACKCOUNTRY SUPERCUB · S/N BC31122R031N206GVCessna TU206G · S/N U20604833N206HHCessna TU206G · S/N U20605675N2150KCessna T206H · S/N T20608407N215GHEurocopter AS 350 B3 · S/N 3147N2265QPiper PA-32-300 · S/N 32-7740048N2343HPiper PA-18-150 · S/N 18-7909173N2462SCessna T337C · S/N 337-0762N26SRRemsen T Schenck RV-6 · S/N 92628N271LHSiai-Marchetti SM-1019B · S/N 0010N2768XCessna 180H · S/N 18051568N2CWCessna A185F · S/N 18502486N303KDCirrus Design SR22T · S/N 8522N3148RCessna 182L · S/N 18258548N3195YCessna 182E · S/N 18254195N40040Piaggio P.136-L2 · S/N 239N4014YCessna 185 · S/N 185-0214N414STCessna 414 · S/N 414-0627N428JGRobinson Helicopter R44 II · S/N 10168N4385BCessna 170B · S/N 26729N444GTExtra Flugzeugbau EA-300 · S/N 019N500BCAmerican Champion 8GCBC · S/N 557-2013N505VBoeing A75N1(PT17) · S/N 75-2732N5148DCessna 182A · S/N 51248N5172RCessna A185F · S/N 18503012N519LGBritten-Norman BN2A-26 ISLANDER · S/N 2005N5203XCessna TU206G · S/N U20605592N520YHCessna A185F · S/N 18503619N5341GCessna T182T · S/N T18208195N5351DCessna 180A · S/N 50249N5412QCessna 150L · S/N 15073312N54KDCessna TU206G · S/N U20606181N550UCessna 182Q · S/N 18267182N562KWKen Lawson KITFOX S7 STI · S/N KA19209415N5753ZPiper PA-18-150 · S/N 18-8026N6052JCessna T182T · S/N T18208603N60956Cessna A185F · S/N 18504083N60JGDehavilland DHC-2 · S/N 1453N6128NCessna 182R · S/N 18267794N6299PCessna P210N · S/N P21000165N664PSRobinson Helicopter R66 · S/N 0299N6741LPiper PA-18-150 · S/N 18-7409121N711SQRussell Dell Murri KITFOX IV CLASSIC · S/N 1652Sale reportedN729DPiper PA-28-180 · S/N 28-2930
Back to Mccall, ID