Grants Pass, OR
Registered aircraft · 89
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 = 'GRANTS PASS' 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 = 'GRANTS PASS' 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.
N102GWGalloway/Ward RV-4 · S/N GW 102N1240JAero Commander 112 · S/N 240N1255PPiper PA-23 · S/N 23-281N127DDCessna 195 · S/N 7040N1529FCessna 185D · S/N 185-0872N165TVBellanca 14-19-3 · S/N 4189N1878ZCessna 210-5 · S/N 205-0078N188DMDavid P Mcgloon SONEX · S/N 0739N194DBDg-Flugzeugbau DG-1000M · S/N 10-203M21N19794Cessna 172L · S/N 17260758N2030VCessna 140 · S/N 14243N219DMDennis Mitchell ZENITH STOL CH 701 · S/N 7-6854N2238Brent L Clyde CCX-2300 · S/N CCX-2300-0115N2238JCessna 150G · S/N 15065438N231KVMooney M20K · S/N 25-0291First renewal noticeN2333CCessna R182 · S/N R18200152N237JCCampbell James W RV6A · S/N 20216N243LPCirrus Design SR22T · S/N 11489N246MHAvions Max Holste MH 1521 BROUSSARD · S/N 246N25633Beech V35B · S/N D-9438N2590DCessna 170B · S/N 20742N2601HEngineering & Research ERCOUPE 415-C · S/N 3226N2658TPiper PA-28-180 · S/N 28-7205067N2683RCessna 182K · S/N 18258383N2779XCarroll Robert Douglas JR KIT FOX MODEL 5 · S/N S94120086N2874KCessna 180K · S/N 18053110N299TTKlute Terrence A TITAN TORNADO II · S/N D98912SOHK0299N322TRMaloney Randy Wayne M1 · S/N M1N3255QCessna 152 · S/N 15283871N325JHLet L-23 SUPER BLANIK · S/N 917910N3339BPiper PA-22-135 · S/N 22-2154N360SXDavid G Skrock LANCAIR 360 · S/N 980-320-820N3648UCessna 182F · S/N 18255048N3720LCessna 172G · S/N 17253889N379GPCessna T182T · S/N T18208379N3826BBeech F35 · S/N D-4091N39621Piper PA-44-180 · S/N 44-7995016N418JGRosenfeld John ZENITH CH 701 · S/N 77536N41MXOverholtzer Max ZODIAC 601XL · S/N 6-6470N42369Cessna 182L · S/N 18258989N4291ANishan Hossepian CALIDUS · S/N C00572N441ADCessna 441 · S/N 4410226N4450YAerostar S A YAK-52 · S/N 855809N459WEPiper PA-28R-180 · S/N 28R-30530N460DDThompson Duane TORANDO S · S/N 460N4692QCessna 172M · S/N 17261745N4714VBellanca 17-30 · S/N 30069N516THRaytheon HAWKER 800XP · S/N 258418N5293PCessna T206H · S/N T20608962N5728PPiper PA-24-250 · S/N 24-802
Back to Grants Pass, OR