OpenAirDocs.org
Ontario, CA

Registered aircraft · 47

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 = 'ONTARIO'
  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.

N10DHBeech F90 · S/N LA-111Built 1981 · Vta Capital LLCN123GJCessna 172N · S/N 17270706Built 1978 · Aftcloud IncN12577Cessna 172M · S/N 17262088Built 1973 · Aftcloud IncN15633Piper PA-28R-200 · S/N 28R-7335076Built 1972 · Jime Aero LLCN188RAAmerican Champion 8KCAB · S/N 976-2005Built 2005 · Cook Gary LeeN225JCAdvanced Aerodynamics & Struct JETCRUZER 500 · S/N 002Built 1997 · Jetcruzer International LLCN23844Taylorcraft BL-65 · S/N 1480Registration pendingBuilt 1939N2398NPiper PA-38-112 · S/N 38-79A0824Wolf Aerospace CorpN254RWWebb Reginald LIV-P · S/N LIV-478Built 2006 · Webb Family Enterprises IncN289MTBoeing 727-223 · S/N 22467Built 1981 · Raytheon CoN2900ECessna 172N · S/N 17271368Built 1978 · Centaurus LLCN30NTAirbus Helicopters AS350B3 · S/N 8798Built 2020 · City Of OntarioN326HBTimbs Gary HATZ LCB · S/N 326Built 2020 · Timbs GaryN3295WPiper PA-32-260 · S/N 32-128Built 1965 · Chapman Daniel H JrN33151Piper PA-28R-200 · S/N 28R-7535127Built 1975 · Thayer VictoriaN33648Piper PA-28-140 · S/N 28-7525219Built 1975 · Sadiq AhmedN3904YCessna 210D · S/N 21058404Built 1964 · Otto William RN4000XCessna 172S · S/N 172S8010Built 1998 · Jp Skyward LLCN4432QBoeing PT-17 · S/N 75-1969Maglica JohnN477XWDJI MATRICE 4E · S/N 1581F7FUC251500CY7Q7Rash BeauN48024Cessna 152 · S/N 15283270Built 1979 · Aftcloud IncN505SPRaytheon B200 · S/N BB-1538Built 1996 · N505sp LLCN5157DCessna 182A · S/N 51257Built 1958 · Pari Gabe MN521CACessna 172S · S/N 172S9733Built 2004 · Aftcloud IncN52432Cessna 172P · S/N 17274517Built 1980 · Aftcloud IncN5292DCessna 172N · S/N 17272497Aftcloud IncN550GPGulfstream Aerospace GV-SP (G550) · S/N 5173Built 2007 · N550gp LLCN60NTAirbus Helicopters AS350B3 · S/N 8466Built 2017 · City Of OntarioN6208GCessna 150K · S/N 15071708Built 1969 · Wilson Tom PN627SJCirrus Design SR22T · S/N 10056Built 2024 · Jslbrv LLCN6570KDowner REPUBLIC RC-3 · S/N 843Wolf Aerospace CorpN6748KRepublic RC-3 · S/N 1036Wolf Aerospace CorpN7108XCessna 150A · S/N 15059208Built 1961 · Cortez NellyN760GPSikorsky S-76B · S/N 760448Built 1996 · Industrial Integrity Solutions LLCN77439Cessna 140 · S/N 11881Built 1947 · Timbs Gary ON7793BNimbus 3 · S/N 105Revoked, canceledBuilt 1958 · Sands James EN8095GPiper PA-28-236 · S/N 28-7911330Built 1979 · Trulock Todd NN8215DBeech H35 · S/N D-5302Built 1957 · Cronk Jerry LN85228North American T-28D · S/N 51-3557Built 1951 · Nightingale Robert WN8678HNorth American NAVION · S/N NAV-4-678Wolf Aerospace CorpN86JTSiegenfield Harold QUICKIE ACFT (Q-2) · S/N 2607 Q-2Built 2000 · Cabrera Monique EN8756CPiper PA-28-151 · S/N 28-7615125Built 1976 · Dt Aviation LLCN8795HNorth American NAVION · S/N NAV-4-795Wolf Aerospace CorpN91484Cessna 182P · S/N 18262006Built 1973 · Scovel Simeon EdwinN92362Maule MX-7-160 · S/N 19006CBuilt 1993 · Yeakley Gary GN9418UCessna 150M · S/N 15078366Built 1976 · Aftcloud IncN9922UGrumman American Avn. AA-1C · S/N AA1C0156Built 1978 · Owen Christian B
Back to Ontario, CA