Holdrege, NE
Registered aircraft · 60
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 = 'NE' AND g.registrant_city = 'HOLDREGE' 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 = 'NE' AND g.registrant_city = 'HOLDREGE' 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.
N112HBAir Tractor AT-502B · S/N 502B-2825Registration pendingN128CMAir Tractor AT-602 · S/N 602-1309N141ANPiper PA-32-300 · S/N 32-7940062N14NVRockwell International S-2R · S/N 2270RN15074Air Tractor AT-402A · S/N 402A-0825N19NNDJI AGRAS T50 · S/N 63YBL8N002000JN20310Cessna 172M · S/N 17261180N206DGBell 206B · S/N 3679N2298QPiper PA-34-200T · S/N 34-7770185N242LMTextron 525 · S/N 525-0970N249FUDJI AGRAS T50 · S/N 63YBM4A0020016N250RMEmbraer Executive EMB-500 · S/N 50000432N2806CCessna 170B · S/N 26349N285FUDJI AGRAS T40 · S/N 1581F574B2398001009LN3067WAir Tractor AT-502B · S/N 502B-2977N310XDDJI AGRAS T50 · S/N 63YBLAW002000VN313AQTextron 510 · S/N 510-0479N323RSHeilongjiang Huida Tech HD580 · S/N 212985300C751N329LAAir Tractor AT-802A · S/N 802A-0345N3725EPiper PA-36-300 · S/N 36-7960055N3760EPiper PA-36-300 · S/N 36-7960064N39425Carlson David QUICKIE Q2 · S/N 2236N3954PPiper PA-22-150 · S/N 22-3631N4011GAyres S2R-T34 · S/N 6020N402FHAir Tractor AT-402B · S/N 402B-1254N41111Snow S2C · S/N 1213CN4182RPiper PA-32-300 · S/N 32-40513N4234ZPiper PA-18-150 · S/N 18-8460N4365Wells PITTS SPECIAL · S/N PA-PAN4631MPiper PA-11 · S/N 11-135N4742UCessna T210N · S/N 21064810N490SFAir Tractor AT-802A · S/N 802A-1152N5007GAir Tractor AT-502B · S/N 502B-0417N502PVAir Tractor AT-502A · S/N 502A-3355N502SEAir Tractor AT-502A · S/N 502A-3486N5263TPiper PA-32-300 · S/N 32-7240102N571BMAmerican Champion 8KCAB · S/N 1042-2007N5893ZPiper PA-22-108 · S/N 22-9758N60153Air Tractor AT-502B · S/N 502B-2709N6018TAyres S2R-T34 · S/N T41-192N6181QAir Tractor AT-502B · S/N 502B-0395N677LAAir Tractor AT-502B · S/N 502B-2738N689BRXag P150 · S/N 1863FPEG8223449Y171RN701NTAir Tractor AT-502B · S/N 502B-2824N7245Grumman Acft ENG Cor-Schweizer G-164A · S/N 916N729CFAir Tractor AT-802A · S/N 802A-0101N759KKCessna 182Q · S/N 18266053N77933Luscombe 8A · S/N 3660N7QFCessna 510 · S/N 510-0456N802RSAir Tractor AT-802A · S/N 802A-0634
Back to Holdrege, NE