Oakdale, CA
Registered aircraft · 56
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 = 'CA' AND g.registrant_city = 'OAKDALE' 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 = 'CA' AND g.registrant_city = 'OAKDALE' 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.
N1047UMaule M-7-235B · S/N 23043CN1082KLuscombe 8A · S/N 3809N1137NBoeing A75N1(PT17) · S/N 75-5336N117RJAviat A-1 · S/N 1314N1345DCessna 170A · S/N 19921N1411GColumbia Aircraft Mfg LC42-550FG · S/N 42556N1516XBellanca 7KCAB · S/N 379-73N1546SBeech P35 · S/N D-6988N1819MBeech A36TC · S/N EA-245N2028WBeech 95-C55 · S/N TE-87N2068DBeech D35 · S/N D-3425N20AFAyres S-2R · S/N R1820-021DCN2338UDJI AGRAS T30 · S/N 3TNDJ5S002K1ZDN24895Cessna 152 · S/N 15280438N248RRCessna T206H · S/N T20608481N273UAXag P100 PRO · S/N 821934381X5YN2935UPiper PA-28-181 · S/N 28-7990565N3001VBeech 35 · S/N D-400N3239WBeech A36 · S/N E-2939N365YSXag P100 PRO · S/N 8219425Y4C42N3732TPiper PA-28R-180 · S/N 28R-30040N373BGGordon Robert E STARDUSTER · S/N 1169N4155XRockwell International S-2R · S/N 1932RN4871VCessna 172RG · S/N 172RG0406N496PBXag P150 · S/N 186324P182234434G2Q7N5316NBoeing E75 · S/N 75-5810N5387RCessna 172F · S/N 17252922N53952Bellanca 7ECA · S/N 1150-76N542RTMichael S Verkaik VANS RV-8 · S/N 83342N5590XAero Commander S2R · S/N 1690RN56094Air Creation TANARG · S/N T06111N59578Bell 206B · S/N 1475N60688Boeing A75L3 · S/N 75-4694N6078RCessna 172G · S/N 17253747N61600Boeing A75N1(PT17) · S/N 75-1011N627SStaples Leven E RV-10 · S/N 40232N639APiper PA-22 · S/N 22-43N645DBBailey Dennis L VANS ACFT RV-6A · S/N 24345N6731RBeech V35B · S/N D-10331N68141Cessna 152 · S/N 15282144N6923HPiper J3C-65 · S/N 20156N708RWCirrus Design SR22 · S/N 0514N714ABCessna 150M · S/N 15079017N71978Luscombe 8A · S/N 3405N7250EBell 206B · S/N 1529N7276TCessna 172A · S/N 46876N735ZKCessna 182Q · S/N 18265813N77901Luscombe 8A · S/N 3628N7FNCessna 140 · S/N 10748N839PCKeyes Charles B XAIR STANDARD · S/N 839
Back to Oakdale, CA