Salem, OR
Registered aircraft · 255
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 = 'SALEM' 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 = 'SALEM' 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.
N1026EAeronca 7DC · S/N 7AC-4577N105JBRobert R Henderson P 5151 · S/N 5151-880401001N1072ZMooney M20J · S/N 24-1126N1101BLuscombe 8A · S/N 5728N110SRMichael Ryer R-S9-MOD 1 · S/N MR-R-S9-001N11289Cessna 150L · S/N 15075302N116MMRyer Michael RANS S-6-S · S/N 11021463N116TMUltramagic M-90 · S/N 90/62N1196JAmerican General Acft AG5B · S/N 10112N12382Cessna 172M · S/N 17261958N1312ECessna 172N · S/N 17270950N135AKStevens Jerrold B RV-4 · S/N 731N1403VCessna 172M · S/N 17263550N140SWSeawind Associates SEAWIND 3000 · S/N 203N1416ECessna 172N · S/N 17270989N1426CVans RV-12IS · S/N 12107N1438RGrumman American Avn. AA-1B · S/N AA1B-0538N143PDehavilland DHC-1B-2 · S/N 105 143N1447BLuscombe 8F · S/N 6074N14EXExtra Flugzeugbau EA-400 · S/N 15N150BCDassault FALCON 7X · S/N 103N1526MBeech 58 · S/N TH-1711N155TLWilliams Helicopter Corp/Oas UH-1E · S/N 154779N15741Piper PA-28-180 · S/N 28-7305134N1636HPiper PA-28-140 · S/N 28-7725148N163MCessna 525C · S/N 525C0035N171MHCessna R182 · S/N R182-01766N17386Cessna T206H · S/N T20608800N175PCXag P150 · S/N 1863FPEG822351243MJ7N176PDBell Helicopter Textron 206B · S/N 4658N17758Sikorsky/Orlando S-55 · S/N V55-396TN1787EAeronca 7AC · S/N 7AC-5354N179LADiamond Aircraft Ind DA 62 · S/N 62.214N180CBCessna 180 · S/N 31489N184PCXag P150 · S/N 1863FPEG82235120P69QN185AACessna 185D · S/N 185-0881N185FSCessna A185F · S/N 18502354N186PCXag P150 · S/N 1863FPEG8223512JQ662N18MDBeech D55 · S/N TE-455N19TACessna 177B · S/N 17701912N1BSCessna 750 · S/N 750-0081N1SKBeech V35B · S/N D-9339N200MVDassault FALCON 2000EX · S/N 229N209HVCessna 172N · S/N 17272302N21058Dehavilland DHC-2 MK. I(L20A) · S/N 630N2105YCessna 172D · S/N 17249605N211TTTolsma Tony Gene AVID FLYER · S/N 386Sale reported, pending cancellationN21230Cessna 182P · S/N 18261502N214MJKen Hendrickson RANS S-21 · S/N 11190073N2181NCessna 182T · S/N 18281339
Back to Salem, OR