Rancho Cucamonga, CA
Registered aircraft · 80
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 = 'RANCHO CUCAMONGA' 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 = 'RANCHO CUCAMONGA' 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.
N10769Cessna 175C · S/N 17557025N107LTHawker Beechcraft HAWKER 850XP · S/N 258901N10AMCessna 750 · S/N 750-0202N111MBPiper PA-28-236 · S/N 28-8211003N112SBeech S35 · S/N D-7466N114RKDJI INSPIRE 1 · S/N W13DCC23020945N118RSCessna T210L · S/N 21060583N120RKDJI INSPIRE 1 · S/N W13DCC15020321N1281QCessna 172S · S/N 172S10333N1335WMooney M20E · S/N 223N144CCGrumman American Avn. AA-5B · S/N AA5B-84N162CTTronaas Chris E EXEC 162F · S/N 6445N191SGBell 206B · S/N 3805N192RSDassault MYSTERE FALCON 900 · S/N 143N193BCCasazza Burt R MUSTANG II · S/N M-II 193N1ZMCessna T337G · S/N P3370200N2049HEngineering & Research ERCOUPE 415-C · S/N 2672N20SVAviat A-1C-180 · S/N 3380N2251TCessna R182 · S/N R18200007N24553Cessna 152 · S/N 15280328N24637Piper J3L · S/N 3316N25VMRaytheon G36 · S/N E-3690N2602UCessna 172D · S/N 17250202N2859TPiper PA-28-140 · S/N 28-7225254N28835Cessna 421A · S/N 421A-0050N32HLLynch Jerry COZY · S/N 176N3373RCessna 182L · S/N 18258673N3647BAerostar International RX 8 · S/N RX8-3065N375BZSocata TBM 700 · S/N 472N4075FCessna 172 · S/N 36975N4176FCessna 172 · S/N 46076N4286VCessna 170 · S/N 18700N429EGPiper PA-28-180 · S/N 28-7405188N4306DBeech D-50 · S/N DH-65N444HDCessna 421C · S/N 421C0480N4462KRyan NAVION A · S/N NAV-4-1462N4521UCessna 150D · S/N 15060521N45619Luscombe 8A · S/N 2146N45918Canadian Car & Foundry HARVARD MK IV · S/N CCF4-246N4603XDillon Gregory A RV-9A · S/N 90488N4672JPiper PA-28R-180 · S/N 28R-30573N5074YAerostar International AEROSTAR S53H · S/N S53H-3008N520RDehavilland TIGER MOTH DH 82A · S/N 82960N522ADBombardier BD-100-1A10 · S/N 20664N5253XCessna 172S · S/N 172S9169N52740Boeing A75N1(PT17) · S/N 75-274N5276SCessna TR182 · S/N R18201535N55PPCessna 414 · S/N 414-0366N602AJCanadair CL-600 CHALLENGER · S/N 1020N6033BCessna T182T · S/N T18208559
Back to Rancho Cucamonga, CA