Post Falls, ID
Registered aircraft · 64
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 = 'POST FALLS' 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 = 'POST FALLS' 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.
N10843Cessna 150L · S/N 15075080N10951Cessna 150L · S/N 15075162N130TBVans RV-12 · S/N 120902N16TQBeech B-55 · S/N TC-2040N1731JPiper PA-28-140 · S/N 28-24144N180CYCessna 180B · S/N 50460N180SBCessna 180 · S/N 31405N18694Cessna 177B · S/N 17702547N20579Helmkamp Eugene E RV6A · S/N 23326N21PTGlasflugel STANDARD LIBELLE · S/N 190N223WTCirrus Design SR22T · S/N 0744N224EUDJI Innovations PHANTOM 3 PROFESSION · S/N P76DCF16016892N27099Piper J4A · S/N 4-1018N277WHHemmer Wilbur CHALLENGER II · S/N CH2-0900-2010N3021AS+ AC 4 · S/N 023N3063FCessna 182J · S/N 18257163N3146UCessna 182F · S/N 18254546N323TTRobinson Helicopter R44 II · S/N 14626N328FESchreder HP-11A · S/N 37N345ETCirrus Design SR22 · S/N 0492N360ACCessna 182P · S/N 18263631N386YXMiller Harvey L WAIEX · S/N W0086N3902CCessna 150H · S/N 15069101Registration pendingN39387Lake LA-4-200 · S/N 536Registration pendingN3DMMilton Don STODDARD HAMILTON GL · S/N 3138N4296MPiper PA-12 · S/N 12-3228N44436Taylorcraft BC12-D1 · S/N 10236N44617Piper PA-28-235 · S/N 28-7410100N4727KCessna 182P · S/N 18263726N4796HPiper PA-11 · S/N 11-765N4888KRyan NAVION · S/N NAV-4-1888N5156RCessna 172M · S/N 17263373N517TAeropro CZ A220 · S/N 458 15N518BCAmerican Champion 8GCBC · S/N 632-2023N531BXTextron B300 · S/N FL-1154N5324VCessna R172K · S/N R1722288N55MTPiper PA-23-250 · S/N 27-3575N5664ACessna 172 · S/N 28264N612DHHarjehausen Denton Dean RV-12 · S/N 120257N63GWCessna 182R · S/N 18268015N63RCAirbus Helicopters AS350B3 · S/N 8760N6410ACessna 182 · S/N 33210N660TMAmerican Champion 8GCBC · S/N 407-99N672MPSikorsky EH-60A · S/N 87-24674N677MReed Mike SMITHS SUPER CUB · S/N 003N696XXBell Helicopter Textron Canada 505 · S/N 65071N7030VAirborne Windsports PTY REDBACK 503 · S/N 503-1010N71PHCessna U206F · S/N U20602651N7243EBeech A36 · S/N E421N76129Cessna 120 · S/N 10526
Back to Post Falls, ID