Coeur D Alene, ID
Registered aircraft · 98
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 = 'COEUR D ALENE' 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 = 'COEUR D ALENE' 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.
N1037LReiff D H/Reiff G S PULSAR 582 · S/N 348N104EEWestfall Benjamin C VANS RV-10 · S/N 001N106JDDenison SPEZIO SPORT DAL-1 · S/N 166N109KFFaribault Airport KITFOX IV · S/N 1488N1141YCessna LC41-550FG · S/N 411140N114LHine Derek L LANCAIR 4P · S/N 167N118TCDJI AGRAS T40 · S/N 64TBL5A00200NBN121YXEngert Larry R WAIEX · S/N W0121N1296CCessna 177B · S/N 17702699N13WDHughes 369HS · S/N 150685SN141EChristopher P Gage SHORTFIELD EXPLORER · S/N 001N1435SCessna 182P · S/N 18264983N143MFDJI AGRAS T30 · S/N 527BK4Q001007KN144MFDJI AGRAS T20P · S/N 64UBLA900200AFN145HRNeufeld Mark Wayne HARMON ROCKET II · S/N 1778N154MFDJI AGRAS T20P · S/N 64UBK6600100RSN1568WCessna T182T · S/N T18208394N170BRRegan Brent Ford LANCAIR IV P · S/N 170N17AUPiper PA-32R-301T · S/N 3257040N182DTCessna 182P · S/N 18263797N182MFCessna 182P · S/N 18262210N1834XCessna 182H · S/N 18255934N185JTCessna A185F · S/N 18503145N187RRRutan Aircraft Factory M 81 · S/N 001N1919DBeech C35 · S/N D-3191N199MFDJI AGRAS T50 · S/N 63YBM5E00200FHN2024BPilatus PC-24 · S/N 553N206DMCessna TU206F · S/N U20603512N208CGPilatus PC-12 · S/N 132N2094KSilvaire LUSCOMBE 8A · S/N 4821N211DHGulfstream Aerospace G-IV · S/N 1432N21453Cessna 182P · S/N 18261640N217WYAviat A-1C-200 · S/N 3280N2478PPiper PA-18-150 · S/N 18-8009056N2497GCessna 182B · S/N 51797N251WYAviat A-1C-180 · S/N 3251N252CAMooney M20K · S/N 25-1064N256PGQuest KODIAK 100 · S/N 100-0256N2696VCessna 170 · S/N 18206N274GTCessna 172RG · S/N 172RG1141N277MFTalos Drones TALOS T60X · S/N 78KBN1L00A01F3N27ZZCessna 310I · S/N 310I0100N2919KCessna 180K · S/N 18053129N3092SPiper PA-32R-301T · S/N 3257366N3104FCessna 182J · S/N 18257204N3359MPiper PA-12 · S/N 12-2216N33JPBeech D18S · S/N A-998N34271Cessna 182C · S/N 631N366ZTRobinson Helicopter R66 · S/N 0551N375BTElbert Rutan 375 SKIGULL · S/N 001
Back to Coeur D Alene, ID