OpenAirDocs.org
Fresno, CA

Registered aircraft · 294

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

N100AFPilatus PC-12/47G · S/N 3022Built 2025 · Barrier Equipment LLCN1112DCessna 140A · S/N 15676Murray Russell JN11643Bellanca 7KCAB · S/N 549-75Built 1975 · Henderson George LN1194MCessna 172K · S/N 17258694Built 1969 · Gadamic LLCN11VLLebon SMITH DSA-1 · S/N VL934Jury Steven TN122VWBeech M35 · S/N D-6435Jk Aviation LLCN1298BLuscombe 8E · S/N 5925Built 1947 · Jury Steven TN12FHBeech D-50 · S/N DH-63Built 1956 · R&B Leasing And Finance LLCN12SCCogswell Steve L KR-2 · S/N A1Ruiz Luis Fernando LinaresN1384SCessna 182P · S/N 18264946Built 1976 · Adventure Aviation LLCN144CBeech B300 · S/N FL-49Built 1991 · Meyers Construction IncN1463KLuscombe 8A · S/N 4190Built 1946 · Aasness Todd DN1494CCessna T210N · S/N 21063065Built 1978 · Four C'S Equipment Leasing LLCN1527ZFirefly Balloons FIREFLY 8B-15 · S/N F8B-2044Built 2003 · Pierre Peter AN154SKCessna 152 · S/N 15282110Built 1978 · Reign Aviation LLCN156LATextron B300 · S/N FL-1153Built 2018 · Fresno Beverage Co Inc DBAN1577EEnstrom Helicopter 280C · S/N 1131Seibert Lynn KN1578LBeech A36 · S/N E-826Built 1976 · Baloian Packing Co IncN157TWCessna 525B · S/N 525B0157Built 2007 · Hf Air LLCN15KCBeech D35 · S/N D-3478Gostanian Gregory KN160TMCompagnie Daher TBM 700 · S/N 1394Built 2021 · Tbm N160tm LLCN169JDHawker Beechcraft B200GT · S/N BY-148Built 2012 · Blackhorse LLCN172YYCessna 172M · S/N 17263986Built 1974 · Apr AviationN176CStinson 108-2 · S/N 108-3176Built 1947 · Purvis David SN1802EAeronca 7AC · S/N 7AC-5369Built 1946 · Viau RobertN180HAHiller UH-12E · S/N HA3080Built 1980 · Ambrosini Helicopters IncN181LSPiper PA-28-181 · S/N 2843227Built 1999 · Lee Jerry RN182RRCessna 182T · S/N 18281675Built 2005 · Dont Be Nosy LLCN1858PBeech 58P · S/N TJ-372Built 1981 · Baron N1858p LLCN18BFMitsubishi MU-2B-20 · S/N 173Built 1969 · Center For Endodontics IncN1932SBombardier BD-100-1A10 · S/N 20318Built 2011 · Shehadey Enterprise Solutions LLCN199FFMcdonnell Douglas Heli 369FF · S/N 0099FFBuilt 1994 · Heavy Lift Helicopters IncN201AACessna 150 · S/N 17352Built 1959 · Adventures In The Sky Aviation LLCN20277Rhodes Michael BOWERS FLYBABY 1A · S/N 5099Built 2002 · Rhodes Michael JN205JGGarlick Helicopters UH-1H · S/N 67-17686Frederico Leonard AN20687Luscombe 8 · S/N 841Built 1938 · Dillahunty Chris DN2108BLuscombe 8 · S/N 6535Built 1948 · Reitz Douglas AN210DSCessna T210N · S/N 21064275Built 1981 · Sevel Garry SN210YYCessna 210 · S/N 57408Built 1960 · Apr AviationN21147Cessna T182T · S/N T18208234Built 2004 · Woolf Sarah ClarkN212HLBell 212 · S/N 30621Built 1974 · Rogers Helicopters IncN212SGSkyranger SKR0207202 · S/N 2000Built 2002 · Gill StephenN212THBell 212 · S/N 31109Built 1980 · Cougar Aviation LLCN2136DBeech D35 · S/N D-3481Built 1953 · Leake RichardN218TCCone Timothy E VANS RV-8 · S/N TC 82071Built 2007 · Cone Timothy EN221USCostruzioni Aeronautiche Tecna P2010 TDI · S/N 212/USBuilt 2023 · Golden State Flyers LLCN222SGCessna T210N · S/N 210-64410Pacific Aviation Aircraft Management IncN2239GCessna 182A · S/N 51539Built 1958 · Potter Cleve JN223BDCessna TR182 · S/N R18201454Built 1980 · N223bd LLCN223ERCirrus Design SR22 · S/N 2658Built 2007 · Kern Delta Co LLC
Back to Fresno, CA