Pocatello, ID
Registered aircraft · 71
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 = 'POCATELLO' 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 = 'POCATELLO' 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.
N1023XPiper PA-28-235 · S/N 28-7510074N10571Boeing B75N1 · S/N 75-1219N10805Piper PA-28-140 · S/N 28-22677N118GCCirrus Design SR22 · S/N 1912N119WMSix Chuter SR7 XL · S/N 0007N1240CCarson Lyle C COMMANDER · S/N LCC01N1324VCessna R172K · S/N R1722161N13348DJI AGRAS T40 · S/N 1581F574B2385001000JN1525MPowrachute PEGASUS · S/N A312PEGN155AVBeech B200 · S/N BB-1216N159ZBeech 58P · S/N TJ-178N15LWWestbrook Larry RV-9A · S/N 90016N165JVRaytheon A36 · S/N E-3180N201FJMooney M20J · S/N 24-0185N20877Cessna 182P · S/N 18261279N208AVCessna 560 · S/N 560-0358N208CMCostruzioni Aeronautiche Tecna P2008 · S/N 183N20CTCessna 152 · S/N 152-81952N2113FCessna U206 · S/N U206-0313N2207ECessna 172N · S/N 17271186N231AVRockwell International 690B · S/N 11353N242KQQuest KODIAK 100 · S/N 100-0242N28316Grumman American Avn. AA-5B · S/N AA5B0558N299AVRaytheon B200 · S/N BB-1680N310SMCirrus Design SR22 · S/N 2046Registration pendingN320TTCessna 320E · S/N 320E-0081N32KEEmbraer-Empresa Brasileira De EMB-500 · S/N 50000063N3473XMooney M20E · S/N 1149N35402Cessna 172I · S/N 17256749N367BBHylio AG 230 · S/N 17906100237N369VLMohammed Mominul Haque VL3 · S/N 569N37446Interstate S-1A · S/N 291N3747MBoeing PT-17 · S/N 75-4298N3894TPiper PA-28R-180 · S/N 28R-30223N40024Piper PA-28R-201 · S/N 28R-7737128N4415LBeech B100 · S/N BE67N4418RCessna 172M · S/N 17263166N4496YPiper PA-25-235 · S/N 25-4166N4721RCessna 172RG · S/N 172RG0017N499AVCessna 560XL · S/N 560-5602N5047DCessna 182A · S/N 51147N531CSJMB Aircraft S R O VL-3TE-915 · S/N VL-3-525N54SLCessna 525A · S/N 525A0339N560AVCessna 560 · S/N 560-0321N6002BCessna 182A · S/N 34002N6115SCessna TR182 · S/N R18201617N6286PPiper PA-24-250 · S/N 24-1396N63595Cessna 180K · S/N 18052856N64427Cessna 172M · S/N 17265219N6475WPiper PA-28-140 · S/N 28-20549
Back to Pocatello, ID