Roseburg, OR
Registered aircraft · 88
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 = 'ROSEBURG' 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 = 'ROSEBURG' 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.
N103HPPiper PA-24-260 · S/N 24-4153N104BCHoudek PITTS SPECIAL S-1D · S/N 7-0162N112XLFern Duane B S12-XL · S/N 05980844N11KRCessna T210L · S/N 21061249N1283Aviat A-1C-200 · S/N 3314N128BLPiper J3C-65 · S/N 7569N1451MCessna 182P · S/N 18264335N173JDiemert Flying LANCAIR IV-PT · S/N LIV-574N1818PMooney M20J · S/N 24-0853N18767Beech C24R · S/N MC-503N1926PPiper PA-22-150 · S/N 22-2677N19ZBCessna 175 · S/N 55732N208CTFlight Design CTSW · S/N 07-04-12N223DBBellis Dennis G RV-6 · S/N 010197N223VTDJI AGRAS T25 · S/N 63NIM2Q0AR0004Sale reportedN229ERAmerican General Acft AG5B · S/N 10125N2440VCessna T206H · S/N T20608176N2486APiper PA-11 · S/N 11-880N2686QCessna 182K · S/N 18257886N2849FCessna 182J · S/N 18256949N284MMBell UH-1H · S/N 6413813N285MMBell UH-1H · S/N 65-10029N2916DCessna 170B · S/N 26859N2973XPiper PA-28-161 · S/N 28-8016011N2MGBombardier BD-700-1A10 · S/N 9603N32DAAero Rampart STEEN SKYBOLT · S/N 200N33463Piper J3C-65 · S/N 5973N3391VBeech 35 · S/N D-865N35858Cessna 177RG · S/N 177RG1063N36DPCessna 510 · S/N 510-0391N3765RCessna 172H · S/N 17255565N383SCHane William GLASAIR SH2R · S/N 547N387DRRose Dennis K GLASTAR · S/N 5049N3943YCessna 210D · S/N 21058443N3974UCessna 150E · S/N 15061374N405UMMott Robert L RANS S-7S · S/N 0506436N4105CCessna R182 · S/N R18200322N411CCBeech B200 · S/N BB-1520N414RBCessna 414A · S/N 414A0270N4260QCessna 172L · S/N 17260160N43422Piper PA-28-151 · S/N 28-7415487N441MECessna 441 · S/N 441-0266N462SHeather J P Swan J430 · S/N 975N4724MPiper PA-11 · S/N 11-236N47842Piper PA-28R-201T · S/N 28R-7803025N503SCSprague Daniel SUPERCAT · S/N 001N5056BBeech F35 · S/N D-4352Registration pendingN505RJCessna 501 · S/N 501-0009N5532PPiper PA-24-250 · S/N 24-596N5638HPiper PA-16 · S/N 16-249
Back to Roseburg, OR