Camas, WA
Registered aircraft · 79
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 = 'WA' AND g.registrant_city = 'CAMAS' 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 = 'WA' AND g.registrant_city = 'CAMAS' 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.
N120CPPorter Charles J RV-8 · S/N 001N140JTCessna 140 · S/N 10711N167DRReed Dan M REED RV-7A · S/N 70581N16NHBeech A36 · S/N E-2220N16RFRichard L Frost RV-9A · S/N 90065N180BACessna 180J · S/N 18052419N180PBCampbell Collin BEARHAWK PATROL · S/N 056N18586Cessna 150L · S/N 15073964N185PCCessna A185F · S/N 18503003N190SERandy L Albritton RKM1 · S/N 101N20640Cessna 180K · S/N 18053202N20LUSocata TB21 · S/N 685N2127FCessna U206 · S/N U206-0327N21667Piper J3C-65 · S/N 2558N21851Piper J3C-65 · S/N 2635N22872Salovich-Nick BABY LAKES · S/N 7411-M-542BN232SWMark J Paras SEAWIND 3000T · S/N 33N234QACessna 182C · S/N 52409N23PBBlock Paul A AVD STOL C TAILDRAGG · S/N 1027N242MMMatthew Miller SUPERCUB EXP · S/N 001N2453QCessna 182K · S/N 18257653N24952Piper J4A · S/N 4-770N260MJPitts Aerobatics S-2B · S/N 5045N2688VCessna 177RG · S/N 177RG0657N270WBGatherer R/Gatherer W WBG-18 · S/N 0001N27905Piper J5A · S/N 5-48N279EEclipse EA500 · S/N 000241N2849ACessna 180 · S/N 30049N2908AAlbritton Randy L KITFOX MODEL I · S/N 201N2939XCessna 177 · S/N 17700339N29949Waco UPF-7 · S/N 5446N3009ACessna 170B · S/N 25653N3023WBeech V35B · S/N D-9517N32023Waco UPF-7 · S/N 5654N3337DCessna 180 · S/N 32131N45PGRobinson Helicopter R44 · S/N 0991N461BAIcon A5 · S/N 00185N485ABBajc Andrew RV-4 · S/N AB-485N4WWaco ASO · S/N X3101N505PDCessna 182 · S/N 18260611N5107HCessna 172M · S/N 17265342N512CNChristopher Michael Nail ZENITH 650B · S/N 65-7644N5137ACessna 172 · S/N 28137N53986Bellanca 7ECA · S/N 1158-76N56LKKlingmuller Lothar M L RV-6A · S/N 123N56SWWilson Steven K GS-2 SPORTSMAN · S/N 7109N5814JCessna 182P · S/N 18263551N6028FBeech S35 · S/N D-7808N6048HPiper J3C-65 · S/N 19194N6100BCessna 210B · S/N 21058068
Back to Camas, WA