Independence, OR
Registered aircraft · 216
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 = 'OR' AND g.registrant_city = 'INDEPENDENCE' 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 = 'OR' AND g.registrant_city = 'INDEPENDENCE' 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.
N104DBBeech B24R · S/N MC-309N105GGoble Ted MARGART CHARGER MA-5 · S/N 307N1062FCessna A185F · S/N 18502718Sale reportedN107DMDavid E Olson CHRISTAVIA MK I · S/N DM2017-1N107MFairchild KR-21 · S/N 1011N10MHHull Michael D CHRISTEN EAGLE II · S/N HULL-0001N117WDWainfan Barnaby S SPEARHEAD · S/N FMXJ-4D-1N118SABeech E18S · S/N BA-14N11HBHenry P Bartle PITTS S-1SX · S/N 1N12389Monocoupe D145 · S/N D-108N124GHKelliher Robert E LANCAIR IV · S/N LIV-115Sale reportedN124XDVans RV-12 · S/N 120692N12SQDouglas L Davis SQ2002 · S/N 1N13297Cessna 180K · S/N 18053167N132PMFlightstar II SC · S/N 395N137DWGyroflug SC 01 B-160 · S/N S 37N1433HAeronca 15AC · S/N 15AC-496N1488Thorp T-18 · S/N 303N14TLGillespie Briggs A GLASAIR RG · S/N 507RN153WWWineland Wayne J RV-7A · S/N 72678N164MKMichael Kelley M KELLEY LANCAIR ES · S/N KES-091N16MCGrumman American Avn. AA-5B · S/N AA5B0447N17038Porterfield 35-70 · S/N 238N1741BEasley PE-1 · S/N 1N177JMCessna 177A · S/N 17701307N1803BLuscombe 8E · S/N 6230N180NVCessna 182A · S/N 34291N180SNCessna 180 · S/N 32399N183BCCrickmer Christopher C RV-14A · S/N 140051N184DJJackson Dennis RV-8 · S/N 80396N188MMStone Michael E PT 2 · S/N MS1N196SSponsler Scott R RV6A · S/N 22763N197RSVans RV-12IS · S/N 120535N19HBBartle Henry LANCAIR 360 · S/N 19N200WFSchleicher KA4 · S/N 97/60N2202Schweizer SGU 2-22 · S/N 8N2212KLuscombe 8A · S/N 4939N2238HCessna 170B · S/N 25644N2278GDunn James K SONERAI - II · S/N 445N22SALarson David A LANCAIR IV-P · S/N LIV-409N230RJames A Oveross TURBO CUB · S/N 001N234BDGillett Robert H PULSAR III · S/N 559N2405WSchweizer SGS 1-23H-15 · S/N 73N2532ZCessna 185B · S/N 185-0532N27473Taylorcraft BL-65 · S/N 2115N274GBGary Brown RV-7 · S/N 74608N2772ZSchweizer SGU 2-22E · S/N 215N278CTFlight Design CTSW · S/N 07-01-11N28366Raven Industries S-60A · S/N S60A-430N292DACessna 172H · S/N 17255066
Back to Independence, OR