Bonners Ferry, ID
Registered aircraft · 41
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 = 'BONNERS FERRY' 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 = 'BONNERS FERRY' 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.
N1037TCessna 182P · S/N 18260859N1128UCessna 172M · S/N 17266857N11582Wolff Albert J KOLB MK III CLASSIC · S/N 11023N124PTBell UH-1H · S/N 63-08817Registration pendingN1255UCessna 172M · S/N 17266950N16901Fairchild 24 H · S/N 3210N185EMCessna 185 · S/N 1850078N247SVStampe ET Renard SV-4B · S/N 200.43N249MMAeronca 7BCM · S/N 7AC-2877N2614GChampion 7KCAB · S/N 64N2679FCessna 182J · S/N 18256779N273ABRay Johnson MARK IV · S/N 1027N297XZDJI AGRAS T20P · S/N 1581F574B23830010044N3167BCessna 170B · S/N 25409N3375THiller UH-12E · S/N 5237N3559ZPiper PA-22-150 · S/N 22-7472N3956DCessna 182A · S/N 34656N3992QCessna A185F · S/N 18502218N409WFlight Design CTSW · S/N 06-07-06N417SAndrews Gene R SOPWITH BABY · S/N 042822N4809RCessna TR182 · S/N R18200610N4887TPiper PA-28-140 · S/N 28-7225230N49423Cessna 152 · S/N 15281254N4947LPiper PA-28-180 · S/N 28-4316N52812Cessna 182P · S/N 18262866N6013DPiper PA-22-150 · S/N 22-4665N61VLCoussens Jerry LANCAIR 320/235 · S/N 61N653ACGteex Revolution INDEPENDENCE 19 · S/N 212985300C6D6N68KVKevin Cederquist KITFOX IV · S/N CCS-110N736EBCessna R172K · S/N R1722459N771ACAmerican Champion 8GCBC · S/N 379-96N80331Cessna 172M · S/N 17266525N812RLSkystar KITFOX SERIES-7 · S/N S70310043N84976Aeronca 7AC · S/N 7AC-3700N8648VBellanca 8GCBC · S/N 16575N8768XCessna 182D · S/N 18253168N87971Cessna 305A (O-1A) · S/N 21947N914WTDavid Peterson SEAREY · S/N 1DK418CN935KMRonald Kodimer JAVRON PA-18 REPLICA · S/N JA1703105N95MTMchenry Gavin C SUPER CYCLONE · S/N 71N9621DPiper PA-22-160 · S/N 22-6532
Back to Bonners Ferry, ID