Central Point, OR
Registered aircraft · 50
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 = 'CENTRAL POINT' 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 = 'CENTRAL POINT' 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.
N1126ACessna 182 · S/N 18265585N1136DCessna 140A · S/N 15699N140RBCessna T310R · S/N 310R1807N148WCBalony Kubicek Spol Sro BB42Z · S/N 1180N15WTCessna 550 · S/N 550-0423N160BRCessna 525B · S/N 525B0454N17801Hughes 369A · S/N 380352N1YXBlanchard Jim GLASAIR III · S/N 3131N206BSCessna TP206C · S/N P206-0434N215WCBalony Kubicek Spol Sro BB60Z · S/N 1248N228KKMcdonnell Douglas Helicopter 369E · S/N 0248EN232NDDiamond Aircraft Ind DA20-C1 · S/N C0032N238GRoyal RW WITTMAN W-10 · S/N 196CN250WCBalony Kubicek Spol Sro BB70Z · S/N 1179N27WYAviat A-1C-180 · S/N 3157N2900PPiper PA-22-150 · S/N 22-3163N2959DCessna 170B · S/N 26902N305MKMooney M20K · S/N 25-0264N355WCBalony Kubicek Spol Sro BB100Z · S/N 1293N3755GJason Broesder SLING TSI · S/N 310SKN40523Piper PA-18-150 · S/N 18-7509123N40618Piper J3F-65 · S/N 7374N426SRCirrus Design SR22 · S/N 2205N4663Talos Drones TALOS T60X · S/N 2104F7EZW255Q001QD15N47267Hughes 369A · S/N 68-17267N47546Piper PA-28R-201T · S/N 28R-7703395N480CJEnstrom Helicopter 480B · S/N 5123N49012Aeronca 0-58B · S/N 058B10943N519DJBeech 95-B55 (T42A) · S/N TC-2030N529FDCessna 525 · S/N 525-0192N5432UBeech 35-C33 · S/N CD-1098N56TWHughes 369A · S/N 1180880N590HRobinson Helicopter R44 II · S/N 12474N6073LAmerican AA-5 · S/N AA5-0173N6310ECessna 172 · S/N 46410N6320TGreg C Marron EXCALIBUR · S/N 92217N661PRRobinson Helicopter R66 · S/N 0635N662GMPiper PA 46-350P · S/N 4636569N668TCPartenavia P 68 C/TC · S/N 317-25/TCN711MVHughes OH-6A · S/N 69-16042N71665Cessna 182M · S/N 18259709N719DMCessna L-19A · S/N 24509N72RZCubcrafters CC11-160 · S/N CC11-00105N79UPCameron Balloons US N-77 · S/N 5609N87NHChristen Industries PITTS S-2B · S/N 5123N880YRBalony Kubicek Spol Sro BB30Z · S/N 1469N89DCMemmer Harry James LANCAIR FP · S/N L-IV-266N9099KPiper PA-28R-201 · S/N 28R-7837028N9822JCessna A150M · S/N A1500631N988BBMilani F W RV 4 · S/N BB1
Back to Central Point, OR