Boise, ID
Registered aircraft · 592
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 = 'BOISE' 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 = 'BOISE' 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.
N1004MCessna 172L · S/N 17259404N10073Cessna 150L · S/N 15074770N101GVCessna 172S · S/N 172S8021N101TMooney M20C · S/N 2887N1048EBellanca 7GCAA · S/N 343-77N104PSTextron T206H · S/N T20609566N1055RApollo MONSOON · S/N 00004N1056EBellanca 7GCBC · S/N 974-77N105CPBalony Kubicek Spol Sro BB30Z · S/N 1831N106FSDehavilland DHC-2 MK. I(L20A) · S/N 477N10807Smith Max E TITAN TORNADO TWO · S/N D95912SOHK0167N109RSCessna TU206G · S/N U20606002N10CLStinson 108-2 · S/N 108-2587N10DUPiper PA-18-150 · S/N 18-7409071N10RZIsrael Aerospace Industriesltd GULFSTREAM G150 · S/N 258N110ZShort Bros SD3-60 SHERPA · S/N SH3409N111BEChampion 7GCBC · S/N 277-70N111EZCessna 185C · S/N 1850753N111ZCessna TU206F · S/N U20602919N1121ERuscito Joseph KITFOX S7 SUPER SPRT · S/N KA18333388N114ZShort Bros SD3-60 SHERPA · S/N SH3408N115ZTextron B200GT · S/N BY-396N118ADDassault FALCON 2000EX · S/N 186N11HXProgressive Aerodyne SEAREY LSA · S/N 1029N11PPBell 412EP · S/N 36316N120AUDornier ALPHA-JET · S/N 120N1212DCessna 170A · S/N 19766N1217FCessna A185F · S/N 18502779N121JSTextron 680 · S/N 680-0581N1224CPiper PA-22-135 · S/N 22-1030N122ECCirrus Design SR22T · S/N 10267N1240XMooney M20E · S/N 113N124WFPilatus PC-24 · S/N 595N12579Cessna 172M · S/N 17262090N125ZQuest KODIAK 100 · S/N 100-0226N1262SCessna 182P · S/N 18264830N127ETCessna 182R · S/N 18268234N12SMVans RV-12 · S/N 121036N130BSRobert Saum GLASTAR · S/N 5458N13154Cessna 172M · S/N 17262533N132PSCessna 206H · S/N 20608278N1330VCessna R172K · S/N R1722166N135LCub Crafters CC18-180 · S/N CC18-0079N136TVCessna 182A · S/N 51388N137DFDaniel R Yocum KITFOX S7 STI · S/N KA20339474N141ZDehavilland DHC-6-300 · S/N 803N142DLCessna 182T · S/N 18281470N142ZShort Bros SD3-60 SHERPA · S/N SH3421N143ZDehavilland DHC-6-300 · S/N 437N1454ZDehavilland DHC-2 · S/N 972
Back to Boise, ID